shlamshtas: Move tablespace ORACLE

2012 m. rugpjūčio 21 d., antradienis

1.My:

SELECT name FROM v$datafile;

ALTER TABLESPACE test_xe OFFLINE;

ALTER TABLESPACE test_xe RENAME DATAFILE 'C:\test_xe.dbf' TO 'D:\test_xe.dbf';

ALTER TABLESPACE test_xe ONLINE;

kazkuris Oracle servisas trukdo ištrinti senąji :\test_xe.dbf.

restartavus galima trinti arba reikia sustabdyti servisą, trinti ir startuoti is naujo.

2.http://www.oracle-base.com/articles/misc/renaming-or-moving-oracle-files.php

SQL> SELECT name FROM v$datafile;

NAME

---------------------------------------------------------

C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\SYSTEM01.DBF

C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\UNDOTBS01.DBF

C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\SYSAUX01.DBF

C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\USERS01.DBF

4 rows selected.

SQL>

SQL> SHUTDOWN IMMEDIATE

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> HOST MOVE C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\USERS01.DBF C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\RENAME_USERS01.DBF

SQL> STARTUP MOUNT

ORACLE instance started.

Total System Global Area 167772160 bytes

Fixed Size 787968 bytes

Variable Size 61864448 bytes

Database Buffers 104857600 bytes

Redo Buffers 262144 bytes

Database mounted.

SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\USERS01.DBF' -

> TO 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\RENAME_USERS01.DBF';

Database altered.

SQL> ALTER DATABASE OPEN;