Tuesday, October 27, 2009

move table

SELECT 'ALTER TABLE '|| OWNER ||'.'|| TABLE_NAME || CHR(10) ||
'MOVE TABLESPACE '||TABLESPACE_NAME ||';'
FROM DBA_TABLES
WHERE OWNER IN('TEST')
AND TEMPORARY ='N'
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)