How to rename temp files in temporary tablespace

SHUTDOWN
STARTUP MOUNT
ALTER DATABASE RENAME FILE 'oldpath' TO 'newfile path';
ALTER DATABASE OPEN;


delete older file

1 comment:

Pablo (yo) said...

Great blog!!!
If you like, come back and visit mine: http://albumdeestampillas.blogspot.com

Thanks,
Pablo from Argentina