In particular, the human resources ( hr) schema is often used.Įxamples that specify a dump file to import assume that the dump file exists. Most of the examples use the sample schemas of the seed database, which is installed by default when you install Oracle Database. You must supply a password before a database connection is made. If you try running the examples that are provided for each parameter, then be aware of the following:Īfter you enter the username and parameters as shown in the example, Import is started and you are prompted for a password. Also, note that if you use a parameter file and the parameter value being specified does not have quotation marks as the first character in the string (for example, TABLES=scott."EmP"), then the use of escape characters may not be necessary on some systems. To avoid having to supply additional quotation marks on the command line, Oracle recommends the use of parameter files. If you were to specify that on the command line, then some operating systems would require that it be surrounded by single quotation marks, as follows: TABLES = '\"MixedCaseTableName\"' Suppose you specify the TABLES parameter in a parameter file, as follows: TABLES = \"MixedCaseTableName\" Be aware that they may not apply to your particular operating system and that this documentation cannot anticipate the operating environments unique to each user. The following examples are provided to illustrate these concepts. Some operating systems may require an additional set of single or double quotation marks on the command line around the entire parameter value containing the special characters. This is true both on the command line and within parameter files. Some operating systems treat quotation marks as special characters and will therefore not pass them to an application unless they are preceded by an escape character, such as the backslash (\).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |