[fsloke]

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...

[jjsaw5]

fsloke, on 8 Aug, 2008 - 08:51 AM, said:

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?

[fsloke]

Quote

I am assuming this is your 1st time doing database stuff?

Not really first time...

I just want to extract the existing data from the database using Oracle...

How can I do it?

Thank

[jjsaw5]

You'll want to use select statements.

Like the example i gave above, and you can use those to pull whatever data you need out of the database.

If you can give me some table names and what data you would like to pull out I would be more then happy to help you out.

[1lacca]

Oracle Export/Import FAQ