Solved

Can I use copy command in PL/SQL?

Posted on 1999-01-29
4
1,634 Views
Last Modified: 2008-02-26
Can I use copy(SQL Plus command, not the OS copy command) command in PL/SQL?
If I can't why?
0
Comment
Question by:srikumar_p
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 1083907
What are you trying to copy? Data from one Oracle table to another?  An operating system file? Something else?
0
 

Author Comment

by:srikumar_p
ID: 1083908
Data from one table to another.
Another question is
Will copy command create redo while copying?
0
 
LVL 2

Accepted Solution

by:
avico earned 50 total points
ID: 1083909
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
 

Author Comment

by:srikumar_p
ID: 1083910
Looks perfect. How can I check whether it generates redo or not?
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to recover a database from a user managed backup
Suggested Courses

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question