GoldenGate

ORACLE-BASE - Oracle Data Pump (expdp and impdp) in Oracle Database 10g

----

Ramin Hashimzade

HI,

Can use the EXP / IMP for data migration.

Please read following link:

http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php

http://docs.oracle.com/cd/B19306_01/server.102/b14215/exp_imp.htm

Moving Data Using Data Pump and Export/Import

Thank you

Hi ,

We will receive data from Siebel DB. So we want to migrate Siebel Data to Oracle .So could you please provide me easy steps/script to move the data and let me know how can we /where can we find out and figure out where the issues can happen and how to resolve those issues..

Thanks.

What do you mean by Siebel database? Which database it is?

HI,

I'm sorry, Siebel DB I don't know. Which database it is. Can you please more information about Siebel DB .

Thank you

I have a doubt here.. I got XML file which contain oracle username,password and connection strings to connect to toad. but I am not able to find whta is the username and password and connection string form the XML file. can any one please let me know how can I find the user name and Password and connections tring from the given XML file.

Appreciate your help.

Thanks.

You can't.  Passwords will not be shown in plain text as they are encyrpted or hashed for security.  You need to speak to whoever knows the username and password for the database schema you want to connect to.

That's the nature of security.

Can any one please let me know if I want to migrate data from any legacy system to Oracle tables , are there any automation scripts.. please send me the scripts if available.

Thanks

The best way to migrate a database from one RDBMS to another is to understand the database structure and requirements of the original system and then re-develop that on the new RDBMS so that you leverage the power and functionality of that new RDBMS.  This is why, often, there are very few tools or scripts around to do it for you, and when there are such scripts they often only do a very basic job of moving the structure and data, but then you're still required to get deep into it and re-design/develop as necessary to get the best out of the new environment.

I don't know about Siebel, so don't know if anyone has any tools or scripts for it, but you could be waiting a while if you're hoping someone will just turn up and say "yes, I've got scripts you can use".  May be a good time to start looking at doing it yourself.

Sure. Thank you