Hi,
ORA-03114: not connected to ORACLE
I am copying some tables from Oracle8i to 11gR2 thru sql copy command. for that i am calling a script to copy three tables from the source. The scripting is some times working good but some times it gives me the above error or some time its copy one or two table and then gives the error. I am calling this script from a batch file. Here is my batch file and SQL file. I am not sure why i am getting this error. Please suggest. Thanks.
Note: Since the DB link does not work for Oracle 11gR2. So that's why i am using the Oracle 10g client to copy from Oracle 8i....
=====================batch file=====================
set ORACLE_HOME=C:\oracle\product\10.2.0\client_1
set PATH=C:\oracle\product\10.2.0\client_1\BIN\
sqlplus target/pass@targetdb @ test.sql
=================================================
========test.sql====================================
copy from source/pass@sourcedb -
to target/pass@targetdb -
create emp_test -
using select * from emp_test;
commit;
copy from source/pass@sourcedb -
to target/pass@targetdb -
create dept_test -
using select * from dept_test;
commit;
copy from source/pass@sourcedb -
to target/pass@targetdb -
create temp_test -
using select * from temp_test;
commit;
exit.
=====================================================