oracle imp usage

[xzhang9]

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

[Oviwan]

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]

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.