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 > ALLOCATE EXTENT; 3) Now EXP utility will work
Post a Comment
Read more

Identify empty tables in oracle

-
SELECT * FROM User_Tables s WHERE s.num_rows=0
Post a Comment
Read more

To find PORT availability on unix systems

-
To find PORT availability on unix systems netstat -an | grep >
Post a Comment
Read more