Filter
Top Products
208 CHAPTER 9: MAINTAINING THE V7000 IP TELEPHONY SUITE
■ For all the tables under one schema (except the runtime tables). See
Exporting Table Data for all Tables in a Schema
.
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:
1 From a SQL Plus command line, login as the cwauth user.
2 Execute 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 in a Schema
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.
To export all the tables in a schema:
1 From a SQL Plus command line, login as the <schema> user.
2 Execute the following: