Tuesday, September 4, 2012

Copy Command in Sqlplus

Today as any Database administrator i wake up on new task , they want import some tables from Developer environment to Production , So I used Copy Command .

its usual used for copy tables from database to Another  , but you have to know this way is very useful specially if you have long Data type in your tables , i will explain it , and Define Two Database in your TNS.


create table osama as select * from long_table ;

You will Get this error :


ERROR at line 1:
ORA-00997: illegal use of LONG datatype

copy from user1/password@orcl  to user2/password@orcl2 create using ;






The Output :
Array fetch/bind size is 30. (arraysize is 30)
Will commit when done. (copycommit is 0)
Maximum long size is 40. (long is 40)
Table osama created.


Simple !!!

Useful Link : 
1-Oracle Document .
2-Examples. 


Thank you 
Osama Mustafa 





No comments:

Post a Comment