Prev | Current Page 612 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"

"SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for RJB.SYS_EXPORT_SCHEMA_01 is:
/Temp/DataPumpXfer/metadata_only.dmp
Job "RJB"."SYS_EXPORT_SCHEMA_01" successfully completed at 09:48:12
[oracle@dw ~]$
The output file, as shown in the listing, is named metadata_only.dmp. The output dump file
contains a binary header and XML entries for re-creating the structures for the RJB schema. During
the export, Data Pump created and used an external table called SYS_EXPORT_SCHEMA_01.
NOTE
Dump files will not overwrite previously existing dump files in the
same directory unless you use the REUSE_DUMPFILES parameter.
You can use multiple directories and dump files for a single Data Pump export. Within the
DUMPFILE parameter setting, list the directory along with the filename, in this format:
DUMPFILE=directory1:file1.dmp,
directory2:file2.dmp
Using multiple directories in the DUMPFILE parameter has two benefits: the Data Pump job can
use parallel processes (using the PARALLEL parameter), in addition to spreading out the dump file
to wherever disk space is available. You can also use the substitution variable %U in the filename
specification to automatically create multiple dump files that can be written to by multiple processes
automatically. Even if only one process is writing the dump file, using the %U substitution variable
in combination with the FILESIZE parameter will limit the size of each dump file.


Pages:
600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624
asus netbooki Chirurg łódź apartamenty swinoujscie Namioty Mazury i interesująca cena Szkoły policealne fryzjer w warszawie