| Backup / Export database (urgently needed) [message #68410] |
Sun, 03 August 2003 23:48  |
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  |
 |
Mahesh Rajendran
Messages: 10707
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
