Home » RDBMS Server » Enterprise Manager » Backup / Export database (urgently needed)
Backup / Export database (urgently needed) [message #68410] Sun, 03 August 2003 23:48 Go to next message
Sanif
Messages: 1
Registered: August 2003
Junior Member
can anybody give me guides to backup or export a database from a computer, so that the database become portable and can be imported by another computer.

i'm currently doing a project using the Oracle 8i Personal Edition and Oracle Developer 6i, and must be summitted this coming 10th august 2003.

i've tried the OMS, by creating new job, but the job status always failed after being summitted. i guess because of the time to execute is always being set to before the job was created.

please help me, because it is an urgent.
Re: Backup / Export database (urgently needed) [message #68411 is a reply to message #68410] Mon, 04 August 2003 13:08 Go to previous message
Mahesh Rajendran
Messages: 10697
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
all docs are avaialble in technet.oracle.com/docs
and 
tahiti.oracle.com
look for utilities manual.

----------------------------------------------------------------------

outline is
1. export takes only the logical structures.
2. so to import, create the same users, tablespaces 
   in target.
3. run the import.

exp username/password@sourcedb owner=schema1 file=schema1.dmp

imp username/password@targetdb fromuser=schema1 touser=schema2 file=schema1.dmp

Previous Topic: How to start in.dbsnmp service.
Next Topic: RMAN-ora-Error During BACKUP
Goto Forum:
  


Current Time: Fri May 20 15:13:05 CDT 2022