By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,985 Members | 1,694 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,985 IT Pros & Developers. It's quick & easy.

How to export and import oracle DB using toad?

P: 1

I am new to Oracle administration and hope someone can help me out on this as i am struggling to make it work....

I am doing development work using oracle database on my own development pc.. the oracle database is installed locally on my pc... how should i port the whole database (including tables, pl sql, triggers, indexes, etc) to another server after all development/testing is completed?

I have tried using toad function (DBA -> Data Import/Export -> Data Pump Export Wizard) to export the whole database and then used (DBA -> Data Import/Export -> Data Pump Import Wizard) to import to another database. The export works with the dmp file created (no errors). However, the import log shows a whole long list of errors about "object type already exists..." and unique constrait (PK) violated etc...

I have chosen the settings where if table exists to replace.. is there something that i have done wrongly or are there easier steps to that? Seems that those tables with errors are mostly system tables (eg MGMT$CSA_HOST_NICS, DBA_OLAP_FUNCTIONS, etc)

Would greatly appreciate if some one can advise me.. .thanks lots :)
Jan 15 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.