Home » RDBMS Server » Server Utilities » Urgent: Recover/"Copy" a database with export/import
Urgent: Recover/"Copy" a database with export/import [message #72489] Mon, 30 June 2003 02:46 Go to next message
Christine
Messages: 18
Registered: March 2002
Junior Member
I have to move a whole database (call it database A)from one server to another!!! I have full_database export.dmp-file.
I created a new default database (created it with server-cd), call it database B) and then startet imp_full_database.
There is no data from database A in database B (just the system-data) all the data from the users and tablespaces in database A are not imported in database B. Do I have to create the Database B just exactly the same as database A ??? Or what can I do to move all the database and its data from one place to another or how do I "copy" a whole database that it really works at the new destiny???
Any help for me? Thanks very much!!
Regard Christine
Re: Urgent: Recover/"Copy" a database with export/import [message #72491 is a reply to message #72489] Mon, 30 June 2003 03:45 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
create the tablespaces in new database with the same name in old database.
now do the full import.
Previous Topic: Database Mounting
Next Topic: SQL Loader
Goto Forum:
  


Current Time: Sun Jun 30 10:43:13 CDT 2024