Home » RDBMS Server » Server Utilities » Re: oracle server
Re: oracle server [message #368091] Thu, 16 March 2000 10:37
Kieron Smythe
Messages: 11
Registered: March 2000
Junior Member
You could use the following command to copy the table to a new table space. I think.....

I think it will not cause any disruptions to operations. Don't quote me on that.

COPY [[FROM username /password [[@database_specification]]|
TO username /password [[@database_specification]]]]
{APPEND|CREATE|INSERT|REPLACE} destination_table
[[(column, column, column, ...)]] USING query

e.g. COPY from scott/tiger@mydatabase TO
john/biggs@yourdatabase CREATE table_name USING
select * from table_name;
Previous Topic: Re: DB sequence in Sql*loader, not SEQUENCE function.....
Next Topic: Re: SQL*Loader and CGI
Goto Forum:
  


Current Time: Mon May 23 21:39:20 CDT 2022