86 CHAPTER 5: MANAGING AUTHENTICATION AND DIRECTORY SERVICE DATABASES
To export all the tables in a schema:
1From a SQL Plus command line, login as <schema>.
2Execute the following:
For this procedure, change the following to match the system:
■Change the value of p_dir to the export directory.
■Make sure to enter the procedure name EXACTLY as shown.
SET SERVEROUTPUT ON
declare
p_dir varchar2(255);
begin
p_dir:='/tmp/export';
CWDATA.DUMP_ALL_TAB(p_dir);
end;
Importing Saved
Tabl e D ata
Once saved, (see Exporting Table Data) the data can be imported into any
Authentication and Directory server database as long as the version
numbers for the exporting and importing servers match.
The following methods may overwrite existing files in the
/opt/3com/VCX/<schema>/db/<schema>/bulkload directory. To prevent
files from being overwritten, rename or move the current .txt files.
If the data in the database and the data being importing have duplicated
data, the duplicate data needs to be cleared before loading custom data.
Tables need to be manually edited using a graphic tool such as Oracle DB
Studio if the entire database is not being cleared.
Import the saved table data as follows:
■To install a new back-end server database, before bulk loading, copy
the exported files to the
/opt/3com/VCX/<schema>/db/<schema>/bulkload directory and then
load the data into the database.
■To add the exported data to an existing database that already has data
loaded, copy the exported files to the
/opt/3com/VCX/<schema>/db/<schema>/bulkload directory and then
load the data into the database one table at a time.