Filter
Top Products
Back-end Server Maintenance 209
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
Table Data
Once saved, (see Exporting Table Data) the data can be imported into any
authentication server database as long as the version numbers for the
exporting and importing authentication 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.
Clearing the
Configurable Tables
Use this procedure to clear all the data tables in either the accounting,
authentication, or directory server.
Once data is deleted it must be reloaded from the text files.