Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
Showing results for 
Search instead for 
Did you mean: 

oracle imp usage

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.


Honored Contributor

Re: oracle imp usage


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


the user USER_OF_ORCL_DB must have enough space.

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.