Oracle 11g Datapump

You cannot use datapump.

Use oracle imp/exp utility.

http://www-it.desy.de/systems/services/databases/oracle/impexp/impexp.html.en

No, you have to make an export using the 9i client exp.

Then, import using the 11g command imp into the new database.

Datapump was implemented in Oracle 10g.

so the dump we make in 9i can be readable in 11g? that is the .dmp file.
what are the parameters i need to give for this cross database transfer..

I will recommend to try the Data Pump import via DB link to the source DB.
If this fails you have no chance to use the Pump

can you give me an example? for example lets say the source table is src_test and the dest table is table_dest.
do we need to have the table to be created in the destination to facilitate the import? or it will automatically create a table based on the name we give?

Thanks!

I just want to do few tables. can we do it without creating schema?
How to dump it in the 11g server and import later with a different table name in the 11g?
is that possible?

Thanks!

Nope, you need to have a schema created. Or maybe use an existent schema.

You cannot import a table with another name, with the imp utility (you could with Data Pump, but not in your case because you are getting data from a 9i database).

However, you can create another table with the new name, like this:

CREATE TABLE NEW_TABLE AS SELECT * FROM OLD_TABLE;
DROP TABLE OLD_TABLE;

And it will be renamed. Easy ;-)

Thanks...
But some of tables are more than 125 gb and its not letting me to export the table dump file.
Any way around for this?
Thanks!

I am gonna exp the tables one by one...

The only way you could rename those tables during export is that you upgrade your 9i database to at least 10g, and then use Data Pump. Conventional export/import doesn't have that option.

Hope to help, if you have further questions don't bother to ask

Ok Thanks!