86
C
HAPTER
5: M
ANAGING
A
UTHENTICATION
AND
D
IRECTORY
S
ERVICE
D
ATABASES
To export all the tables in a schema:
1
From a SQL Plus command line, login as
<schema>
.
2
Execute 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
Table Data
Once saved, (see
) 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.
Summary of Contents for VCX V7000
Page 26: ...26 CHAPTER 1 VCX SYSTEM MAINTENANCE OVERVIEW ...
Page 68: ...68 CHAPTER 3 MANAGING VCX SERVERS ...
Page 78: ...78 CHAPTER 4 BACKING UP AND RESTORING A VCX CONFIGURATION ...
Page 88: ...88 CHAPTER 5 MANAGING AUTHENTICATION AND DIRECTORY SERVICE DATABASES ...
Page 100: ...100 CHAPTER 6 MANUALLY CONFIGURING MULTI MASTER REPLICATION ...
Page 140: ...140 CHAPTER 8 MANAGING UNINTERRUPTIBLE POWER SUPPLIES ...
Page 250: ...250 APPENDIX B UPGRADING VCX SERVER SOFTWARE FROM V7 1 X TO V7 1 Y ...
Page 290: ...290 APPENDIX C UPGRADING VCX SERVER SOFTWARE FROM V6 0 TO V7 0 ...
Page 328: ...328 APPENDIX D DOWNGRADING VCX SERVER SOFTWARE ...
Page 339: ...CLI Command Descriptions 339 ...