shutdown db,and listener
check datafile with size with command
SQL>select name,bytes from v$datafile;
old oldname:
/u01/oracle/VIS/db/apps_st/data/undotbs_04.dbf
/u01/oracle/VIS/db/apps_st/data/summary14.dbf
/u01/oracle/VIS/db/apps_st/data/demantra02.dbf
/u01/oracle/VIS/db/apps_st/data/demantra01.dbf
new name:
/NEW1/oracle/VIS/db/apps_st/data/undotbs_04.dbf
/NEW1/oracle/VIS/db/apps_st/data/summary14.dbf
/NEW1/oracle/VIS/db/apps_st/data/demantra02.dbf
/NEW1/oracle/VIS/db/apps_st/data/demantra01.dbf
cp "oldlocation" to "new location"
SQL>startup mount
SQL>alter database rename file 'old name' to 'new name';
SQL>alter database open;
database altered
now check name of datafile again with command
SQL>select name,bytes from v$datafile;
check datafile with size with command
SQL>select name,bytes from v$datafile;
old oldname:
/u01/oracle/VIS/db/apps_st/data/undotbs_04.dbf
/u01/oracle/VIS/db/apps_st/data/summary14.dbf
/u01/oracle/VIS/db/apps_st/data/demantra02.dbf
/u01/oracle/VIS/db/apps_st/data/demantra01.dbf
new name:
/NEW1/oracle/VIS/db/apps_st/data/undotbs_04.dbf
/NEW1/oracle/VIS/db/apps_st/data/summary14.dbf
/NEW1/oracle/VIS/db/apps_st/data/demantra02.dbf
/NEW1/oracle/VIS/db/apps_st/data/demantra01.dbf
cp "oldlocation" to "new location"
SQL>startup mount
SQL>alter database rename file 'old name' to 'new name';
SQL>alter database open;
database altered
now check name of datafile again with command
SQL>select name,bytes from v$datafile;
No comments:
Post a Comment