-
Contributing Member
Tips of the Day
Dear Team,
Good Morning
Display Database version, installed options and port string
select banner
from sys.v_$version;
select ' With the '||parameter||' option'
from sys.v_$option
where value = 'TRUE';
select ' The '||parameter||' option is not installed'
from sys.v_$option
where value <> 'TRUE';
-
Expert Member
Re: Tips of the Day
The SQL*Plus COPY command can copy data between two databases via SQL*Net. The preferred method of doing this is to use SQL*Plus on the host where the database resides. If performing the copy command from a client SQL*Net connection, the data is transferred through the client machine.
The copy command copies data from one Oracle instance to another. The data is simply copied directly from a source to a target. The format of the copy command is:
COPY FROM database TO database action -
destination_table (column_name, column_name...) USING query
The action can include:
create – If the destination table already exists, copy will report an error, otherwise the table is created and the data is copied.
replace – If the destination table exists, copy will drop and recreate the table with the newly copied data. Otherwise, it will create the table and populate it with the data.
insert – If the destination table exists, copy inserts the new rows into the table. Otherwise, copy reports an error and aborts.
append– Inserts the data into the table if it exists, otherwise it will create the table and then insert the data.
SQL> copy from scott/tiger@ORCL92 -
to scott/tiger@ORCL92-
create new_emp –
using select * from emp;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules