AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Oracle export parameter file table list11/28/2023 ![]() ![]() %U : Unchanged from previous releases.The following substitution variables are available for both export and import operations. %t, %T : The current date in YYYYMMDD format.%y, %Y : The current year in YYYY format.%m, %M : The current month in MM format.%d, %D : The current day of the month in DD format.The following substitution variables are only available for export operations. ![]() Oracle 12.2 includes additional substitution variables. In previous releases the only substitution variable available was "%U", which generated a two digit number from 01-99. This is achieved using substitution variables. Multiple files are generated by parallel exports, so each file needs to have a unique name. Transport_datafiles=/my/path/file1?.dbf New Substitution Variables for File Names Transport_datafiles=/my/path/file10.dbf,/my/path/file11.dbf,/my/path/file12.dbf The wildcards are not allowed in directory names, just file names, and the wildcards can't match files that are not present in the transport set, or an error will be produced. When using the TRANSPORT_DATAFILES parameter, the datafile definition can now use wildcards in the file name. If possible, the import will use parallelism up to the value of the PARALLEL parameter for both metadata and data import. The order of operations is important during an import, so the possible levels of parallelism may vary throughout the import job. In Oracle 12.2 both metadata and data can be exported in parallel provided it is not a transportable tablespace operation. In previous releases the PARALLEL parameter was only relevant to the export/import of data, with all metadata processed serially. Data Pump (expdp, impdp) : All Articles.Parameter File Contents Written to Log File.New Substitution Variables for File Names.Some of these features are not listed in the expdp -help or impdp -help usage text. ![]()
0 Comments
Read More
Leave a Reply. |