UNIX for Dummies Questions & Answers

Hi All,

I have a full oracle dump file that I have exported from a production server. I want to import a specific schema out of the full dump.


Is that possible in oracle. What will be the command for that?

In your import deck, you need to specify a FROMUSER & TOUSER. What do you have so far?

Code:

imp rdsuser@oracledb FILE=fulldb.dmp TOUSER=rdsuser FROMUSER=SYSTEM FULL=Y buffer=100000

So far I have tried this but it imports entire database. I need to import a particular schema

Try removing the FULL=Y

In addition to removing FULL=Y, why are you importing into system? System is a special account. You should create a different user and import into that user.

Also imp dates back to 7.3.4 and probably before that. You should start using impdp or data pump. With data pump and enterprise edition you can compress the export, use multiple channels and change table space names and user names on import. data pump has a lot more functionality than the old exp/imp. Of course you need to run at least 9i to use data pump.

But I do not want the full dump to import, the fulldb.dmp command contains full databse dump, I just want to import a single schema can u help me with this?

Just go with

Code:

imp rdsuser@oracledb FILE=fulldb.dmp FROMUSER=SYSTEM TOUSER=rdsuser

.... and see if that is what you want. This should (I think) only give you the objects owned by SYSTEM. That is, of course a very unusual thing to want and there may be errors given that some of them are for managing the instance and there might be conflict. A careful tidy up after the import will be needed to removed stuff you really don't want rdsuser to have, such as those containing encrypted passwords, database links, synonyms, functions/stored procedures etc.



Robin