Posts

Showing posts from November, 2011

EXP utility on 11gR2 will not work on empty tables with zero rows

1)Identify tables with 0 rows 2)Issue following command on those tables ALTER TABLE <<%empty_table%>> ALLOCATE EXTENT; 3) Now EXP utility will work

Identify empty tables in oracle

SELECT * FROM User_Tables s WHERE s.num_rows=0

To find PORT availability on unix systems

To find PORT availability on unix systems netstat -an | grep <<%PORTNUMBER%>>