Exporting Table Data 85
cd /opt/3com/VCX/scripts/rc3.d
./S20vcxdata start
Exporting Table Data
Use the CWDATA package to export tables into flat files. Export data as
follows:
■For one table in a schema (except the runtime tables). See Exporting
Table Data for a Single Table.
■For all the tables under one schema (except the runtime tables). See
Exporting Table Data for all Tables.
Exporting data saves the current configuration.
Exporting Table Data
for a Single Table
Data for a single table can be exported to the export directory listed in
the Oracle initialization folder.
Runtime tables cannot be exported.
To export data for a single table:
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.
■Change the p_tabname to the name of the table being exported.
■Make sure to enter the procedure name EXACTLY as shown.
SET SERVEROUTPUT ON
declare
p_dir varchar2(255);
p_tabname varchar2(255);
begin
p_dir:='/tmp/export';
p_tabname:='table_name';
cwdata.DUMP_ONE_TAB(p_dir, p_tabname);
end;
Exporting Table Data
for all Tables
Data for all tables can be exported in a schema to the export directory
listed in the Oracle initialization folder.
Runtime tables cannot be exported.