Filter
Top Products
210 CHAPTER 9: MAINTAINING THE V7000 IP TELEPHONY SUITE
To clear the configurable tables from the back-end server database:
1 Log on to the directory server as cworks.
2 Change to the /opt/3com/VCX/<schema>/bin directory:
cd /opt/3com/VCX/<schema>/bin
3 Clear the data by entering the following command:
./besbulkload.pl -s <TNSname> -n <schema> -p
<schema_password> -clear
Running Individual
Tasks on the
Accounting Server
You can run the following individual tasks using SQL*Plus:
■ Exporting CDRs
■ Deleting CDRs
Exporting CDRs
This procedure is for extracting CDR fields (customer configured in table
JOB_EXPORT_FIELDS_MAP) into flat files. According to oracle file I/O, the
output path must be an existing directory, where Linux user "oracle" has
write permission, and this path must be defined or compatible in the
oracle initialization file (init<SID>.ora) under the entry of UTL_FILE_DIR.
To export CDRs, from a SQL Plus command line, login as the cwacct user
and execute CWE.OUTPUT. Refer to the following example, making sure
to set the p_dir and p_filename variables equal to the correct directory
and filename. You can also modify the p_separator variable to change the
column separator.
SET SERVEROUTPUT ON;
DECLARE
p_dir varchar2(250);
p_filename varchar2(250);
p_separator varchar2(10);
BEGIN
p_dir:='/export/home/users/oracle/temp/output';
p_filename:='CDR';
p_separator:='|';
CWE.OUTPUT(p_dir,p_filename,p_separator);
END;
After the procedure has completed successfully, check the content of
the output file. The actual file name is the p_filename affixed with the
timestamp.