For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Hi All,
Can any one please send me sample data migration scripts to get knowledge on Data migration.
Thanks,
Vas
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?
I'm sorry, Siebel DB I don't know. Which database it is. Can you please more information about Siebel DB .
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.
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