Can I use copy command in PL/SQL?

Can I use copy(SQL Plus command, not the OS copy command) command in PL/SQL?
If I can't why?
srikumar_pAsked:
Who is Participating?
 
avicoCommented:
Absolutely No !

The copy command is a part of the product SQL*Plus, and it's neither an SQL command nor a Pl/Sql command.
You can find enforcements in Oracle's documentation, in the SQL*Plus book.

Regarding your second question, SQL*Plus copy command does generate redo data. In fact, everything you do in Oracle generates a redo data, except whenever you (can) use the 'UNRECOVERABLE' predict. For instance, the following command will not generate redeo data :
Alter index idx rebuild tablespace indexes unrecoverable;Create table a as select * from b;

The copy command simply does smart inserts.
0
 
Mark GeerlingsDatabase AdministratorCommented:
What are you trying to copy? Data from one Oracle table to another?  An operating system file? Something else?
0
 
srikumar_pAuthor Commented:
Data from one table to another.
Another question is
Will copy command create redo while copying?
0
 
srikumar_pAuthor Commented:
Looks perfect. How can I check whether it generates redo or not?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.