Friday, March 6, 2015

relocate tempfile oracle

EXAMPLE:

sql>alter database tempfile 'D:\APP\PRAMOTE.L\ORADATA\DW\TEMP01.DBF' offline;

copy tempfile to new location

sql>alter database rename file 'D:\APP\PRAMOTE.L\ORADATA\DW\TEMP01.DBF' to 'E:\oradata\dw\temp01.dbf';

sql>alter database tempfile 'E:\oradata\dw\temp01.dbf' online;

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

ALCATEL 6900

write memory copy running certified reload from working no rollback-timeout