Experts,

I need your help. We have a database that contain around (2000) tables.
We need to move those tables to another tablespace using DBMS_REDEFINITION
package. It is impossible to go manually by this process. I need to write a
procedure that will select every table, pass it to the procedure
dbms_redefinition.can_redef_table and then move it to the new tablespace if it
can be moved or raise an exception if it can't. Please Please please, any kind
of help would be highly appreciated. I am new to the PL/SQL stuff. That's why i
need your help.


Thanks,

Al

Oracle LazyDBA home page