Oracle DB import/export

30 pts.
Tags:
Oracle
Oracle 10g
Oracle 10g Database
Oracle Database
Oracle import/export
hi everybody!

I'm using oracle 10g db. I do have an oracle instance with user name aa and password aa. And also I do have another oracle instance with user name bb and password bb. I want to import a data base from aa into bb. I know that bb has to have accesses atleast what aa has. With these differrent user names and passwords, is it possible doing that?

I'm wainting for your help.

         Thanks!



Software/Hardware used:
software

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi there,

First of all, if you are using Oracle 10g, I believe to utilize data pump would be a better idea as it’s the enhanced version of the older export/import utility provided if given the source database and destination database are both Oracle 10g.

Using data pump, your entire user schema aa in source database can be basically “transported” to destination database. By that I mean, the user along with all privileges will also be created in the destination database.
The only thing you have to be concerned is whether in your source database, are profiles being set for your user schema aa. If it has, you have to create the same profile in the destination database as well prior to importing of the dump file.

The next thing would be whether identical tablespaces to host the data is a requirement during the migration of your user schema aa to the destination database. If it is a requirement, you probably have to create the same tablespaces with the same amount of storage and attributes in your destination database. If identical tablespaces are not a requirement in the destination database and you can house the imported data in current tablespaces in your destination database, data pump utility can immediately do the job.

I hope this helps. Let me know if you have problems with the command syntax. I think there’re lots of assistance on the syntax if you searched under data pump.

Merry Xmas

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Michael Morisy
    Great answer Paladine! Thanks for the help.
    8,323 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following