cancel
Showing results for 
Search instead for 
Did you mean: 

oracle imp usage

xzhang9
Occasional Contributor

oracle imp usage

Hi All,

I have an user schema in one database and I would like to duplicate it in my personal ORCL.

I already export the user schema in some dmp file. But my questions are?

1. do I need to create this user in my ORCL instance? Then I have to create tablespace for the users as this user is on a tablespace which does not exist in ORCL.

2. do I need use "system" to do the export and then import.

Please let me the steps.

Thanks,

Jane
2 REPLIES
Oviwan
Honored Contributor

Re: oracle imp usage

Hi

you can import it in a new schema with this parameters of the imp command:

FROMUSER=USER_OF_ORG_DB
TOUSER=USER_OF_ORCL_DB

the user USER_OF_ORCL_DB must have enough space.

Regards
Paul Sperry
Honored Contributor

Re: oracle imp usage

Yes do the import as system.
Also you will need to grant permissions to the tablespaces for that schema before the import whish means yes you need to create the user/schema befor the import.