QUOTE(fsloke @ 8 Aug, 2008 - 08:51 AM)
Question 1
-------------
Oracle 10g how to extract the data from existing DB?
Any link?
Any client software needed?
Is it as easy as Mysql database or MS SQL [ Just Click on Extract database to script... ] Then load back to the new database...
The script will create the schema and insert the data into the database....
Question 2
------------
Let say the database too huge 100G, can I extract a portion of the data?
Let say I extract 80% from the existing database...
How can I do this?
Thank you...
You'll want to use the SELECT statement to extract the data that you are going to need from the data base. You are going to need to know the table names other informtiaton. Select statements can be very simple or very complex.
here is an example
SELECT * FROM Products WHERE Product_ID = '8'
this is selecthing everything from the products table where the producut ID = 8
I am assuming this is your 1st time doing database stuff?
| 