Home » RDBMS Server » Server Utilities » import
import [message #72916] Wed, 10 December 2003 07:10 Go to next message
Juliana Hernandez
Messages: 4
Registered: December 2003
Junior Member
Hi

How can I export a complete database and then create a repository (in another place) to import that database?

Thanks in advance,

Juliana.
Re: import [message #72917 is a reply to message #72916] Thu, 11 December 2003 02:46 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
-- 1. export the source database

exp dbaUser/passCode@sourceDb full=y file=somefile.dmp

-- 2. Prepare the target database
make sure u have the tablesepaces same as target (else, u have to do the import one schema at a time).
create the users.

-- 3. do the import

imp dbaUser/passCode@targetDb full=y file=somefile.dmp

-- if you dont have the same tablespaces or want the objects in new tablespaces

dbaUser/passCode@targetDb file=somefile.dmp fromuser=user1_in_sourceDb touser=user1_in_targetdb

dbaUser/passCode@targetDb file=somefile.dmp fromuser=user2_in_sourceDb touser=user2_in_targetdb

Previous Topic: SQL Worksheet and command window
Next Topic: Test database setup
Goto Forum:
  


Current Time: Mon Jul 01 07:43:15 CDT 2024