Hi Guys, I have one export (.exp)

[SudhanshuKulshreshth]

Hi Guys,
I have one export (.exp) file of Oracle 8.0 It has around 1000 tables and indexes etc. Out of 1000 tables there are few tables that have rows in millions.

Is there any way to import the file without data of the heavy tables? More specifically my mean is "Can i exclude these heavy tables while importing".

Note: I want to import data for low volume tables in one go.

 

[alexhu]

use

TABLES=(table1, table2, table3)

in you import statement

Alex

 

[SudhanshuKulshreshth]

There are 2479 total tables...So it is difficult to do import by specifying table names. Is there any way to exclude tables. i.e. Can i give only those table names which i want to exclude....that will be easy for me.

With Regards
Sudhanshu Kulshreshtha
Software Consultant

 

[alexhu]

I don't see why its difficult

You can create the list of tables using

select table_name from dba_tables where user_name='YOURUSER';

edit out the tables you don't want to import
add a comma to the end of each table (easy in UNIX, a little more convoluted in Windows)

add the import command line to the front of the list and run it

or break it down into 10 imports

No - you can't exclude tables

Alex

 

[SudhanshuKulshreshth]

Thanks alexhu....