Originally posted by psychofun
THANKS AMAR


I set serveroutput on and run the procedure. It runs successfully but there is no output. What am I missing?

Hi psychofun,

Mind doing a simple test ?

just create a new empty table (e.g.

sql> create table junk ( c1 number);

) and then run the script - if you get "junk" in your output (no pun ) then maybe you don't have any other tables with 0 rows ???

Just an afterthought, you did put the proper TABLESPACE name in place right?

-amar