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
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.
Useful Link :
1-Oracle Document .