| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Backing up Ora7.3 database
>I was wondering if any of you could provide some help here. I am new to
>Oracle DB Administration, and I have a need to create a exact duplicate of
>an Oracle 7.3 database under a different schema name. I am wondering if
>anyone could explain how to accomplish this, or point me out to a good
>reference.
If you are just trying to duplicate one schema, you could do it with an export/import. First export the user you wish to duplicate, then import it under a different name. If you have access to the "Oracle7 Server Utilities" manual you can read up on the commands.
exp73 system/manager_at_dbname owner=XXXXX file=expfile
should give you an output file with everything owned by that user. Then you could do:
imp73 system/manager_at_dbname from=XXXXX to=YYYYY file=expfile
to import all that back into the YYYYY schema.
If you want to create an exact duplicate of your entire database, then that is a bit more involved. What you want to do is to create another instance. I've only done this a few times, and I don't have a good step-by-step description of the procedure handy. Perhaps someone else will.
regards,
Jonathan Gennick
 |
 |