Home » RDBMS Server » Server Utilities » Re: Export/import only those tables that contain data
Re: Export/import only those tables that contain data [message #70548] Thu, 27 June 2002 11:40
andrew again
Messages: 2577
Registered: March 2000
Senior Member
analyze table A COMPUTE statistics;
analyze table B COMPUTE statistics;
..
analyze table Z COMPUTE statistics;

select table_name||',' from user_tables where num_rows > 0;

Put that into a parfile and then specify "exp ... parfile=myparfile.par"
Previous Topic: import data in oracle 8.1.5.0 using Export file of version 8.0.3.0
Next Topic: how to import procedure
Goto Forum:
  


Current Time: Mon Dec 23 07:14:02 CST 2024