| 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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
