Home » RDBMS Server » Server Administration » Adding old datafiles to new installation of oracle 8
Adding old datafiles to new installation of oracle 8 [message #52011] Wed, 26 June 2002 08:52 Go to next message
Daniel Frechette
Messages: 2
Registered: June 2002
Junior Member
Currently I am trying to add a data file from an older install to a new implementation. I was wondering what was the best way to access the data files in order to dump the tables I need. Any and all help would greatly be appreciated.

Report message to a moderator

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
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

Report message to a moderator

Previous Topic: sqlplus as dba
Next Topic: Oracle installation problem - Font not found
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 21:44:25 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.