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"

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 07 16:26:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.