"EMPLOYEE_ARCHIVE" TO "HR";
. . .
BEGIN
dbms_cube_exp.schema_info_imp_beg(1, '11.01.00.00.00');
dbms_cube_exp.schema_info_imp_loop(1, '11.01.00.00.00',
'
');
dbms_cube_exp.schema_info_imp_end(1, '11.01.00.00.00');
COMMIT;
END;
The SQLFILE output is a plain-text file, so you can edit the file, use it with SQL*Plus or SQL
Developer, or keep it as documentation of your application??™s database structures.
Comparing Data Pump Export/Import to Export/Import
The original Export and Import utilities are still available via the exp and imp executables. As
shown in this chapter, there are many ways in which Data Pump Export and Import offer superior
capabilities over the original Export and Import utilities. Data Pump??™s server-based architecture
leads to performance gains and improved manageability. As of Oracle Database 11g, any features
available in the original Export and Import are available in Data Pump. Therefore, the original
export utility is desupported for general use; you may, however, need to use the original export
utility to import data into a version of Oracle prior to 10g.
Chapter 11: Backup and Recovery Options 411
Implementing Offline Backups
An offline backup is a physical backup of the database files made after the database has been
shut down cleanly via a shutdown normal, a shutdown immediate, or a shutdown transactional
command.
Pages:
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639