Steps to Export a Schema from a dump file

[patnim17]

Hi,
I have Personal Oracle (9i) installed in my Local Machine.I have the Dump file of a Schema also with me. I need to export this schema into my Personal Oracle 9i ..in my Local machine.

Can someone point me to a resource or tell me the steps to export this schema into my personal DB?

thanks in Advance.
pat

 

[SantaMufasa]

Pat,

Your terminology is a source of confusion...If you "have the dump file of a Schema", you have already exported it; now you want to import that file into your Personal Oracle 9i.

To do the import of the schema, you must have an empty schema on your target Oracle database ready to accept the contents of the dump file. (You must also know the name of that schema.) Then, at a Windows command prompt, cd to your $ORACLE_HOME\bin path (something like C:\Oracle\ora92\bin).

You have available two options for importing the dump file:

1) interactive mode, and
2) command-line mode.

If you wish to import into the same username that was the export schema, you can use interactive mode.

Interactive mode:

C:\Oracle\Ora92\bin> imp
username: <some valid username, preferrably a DBA>
password: <password for that user>

Import file: EXPDAT.DMP > <name of your incoming dump file>
Enter insert buffer size (minimum is 8192) 30720> <enter>
List contents of import file only (yes/no): no > <enter>
Ignore create error due to object existence (yes/no): no > <enter>
Import grants (yes/no): yes > <enter>
Import table data (yes/no): yes > <enter>
Import entire export file (yes/no): no > <enter>
Enter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done:<enter>

Command-line mode (with the entire command all on one line):

imp buffer=15000000 grants=y feedback=1000 fromuser=<original username> touser=<target username> file=<fully qualified dumpfile name> userid=<DBA user>/<password>@<tns alias>

Let us know if this leads you to success.







Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.