rename pen drive to harddisk

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jan 7 14:12:53 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn / as sysdba;
Connected to an idle instance.
SQL> startup;
ORACLE instance started.

Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.
SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
Database mounted.
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------

H:\ORACLE\ORADATA\KUMAR\SYSTEM01.DBF
H:\ORACLE\ORADATA\KUMAR\UNDOTBS01.DBF
H:\ORACLE\ORADATA\KUMAR\CWMLITE01.DBF
H:\ORACLE\ORADATA\KUMAR\DRSYS01.DBF
H:\ORACLE\ORADATA\KUMAR\EXAMPLE01.DBF
H:\ORACLE\ORADATA\KUMAR\INDX01.DBF
H:\ORACLE\ORADATA\KUMAR\ODM01.DBF
H:\ORACLE\ORADATA\KUMAR\TOOLS01.DBF
G:\USERS01.DBF
H:\ORACLE\ORADATA\KUMAR\XDB01.DBF

10 rows selected.

SQL> alter database rename file 'g:\users01.dbf' to 'h:\oracle\oradata\kumar\use
rs01.dbf';

Database altered.

SQL> alter database open;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> alter tablespace users offline immediate;

Tablespace altered.

SQL> recover tablespace users;
Media recovery complete.




SQL> alter tablespace users online;

Tablespace altered.

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------

H:\ORACLE\ORADATA\KUMAR\SYSTEM01.DBF
H:\ORACLE\ORADATA\KUMAR\UNDOTBS01.DBF
H:\ORACLE\ORADATA\KUMAR\CWMLITE01.DBF
H:\ORACLE\ORADATA\KUMAR\DRSYS01.DBF
H:\ORACLE\ORADATA\KUMAR\EXAMPLE01.DBF
H:\ORACLE\ORADATA\KUMAR\INDX01.DBF
H:\ORACLE\ORADATA\KUMAR\ODM01.DBF
H:\ORACLE\ORADATA\KUMAR\TOOLS01.DBF
H:\ORACLE\ORADATA\KUMAR\USERS01.DBF
H:\ORACLE\ORADATA\KUMAR\XDB01.DBF

10 rows selected.

SQL>
SQL>