|
Re: Adding old datafiles to new installation of oracle 8 [message #52017 is a reply to message #52011] |
Wed, 26 June 2002 12:11 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Trifon Anguelov
Messages: 514 Registered: June 2002
|
Senior Member |
|
|
That would be the export/import of those tables. If you are using 9i, then tablespace export is also available.
Or if you still have both databases running, create db link between them and then use on the new dataabase:
CREATE TABLE <name> AS SELECT * FROM <old_table>@db_link;
If you need more info, or want to learn how to clone db/tablepsaces check Here
Hope that helps,
clio_usa
OCP - DBA
Visit our web site [url=http://www.dbaclick.com]Click Here
|
|
|