470,566 Members | 1,752 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,566 developers. It's quick & easy.

How to export and import oracle DB using toad?


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
0 18238

Post your reply

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

Similar topics

2 posts views Thread by Christian Brennsteiner | last post: by
reply views Thread by Julie Warden | last post: by
1 post views Thread by mickeyav | last post: by
reply views Thread by GBR | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.