Thanks for the question, vishnudas.
Asked: October 05, 2018 - 12:03 pm UTC
Last updated: October 06, 2018 - 6:21 am UTC
Version: 11.2.0.1.0
Viewed 1000+ times
You Asked
Hi there
in our production database,we have a tablespace called TESTDB and this tablespace has 2 DATAFILEs.
location for these 2 datafiles are
D:\ORADATA\TESTDB\TESTDB01.DBF
D:\ORADATA\TESTDB\TESTDB02.DBF
Recently i have added a new datafile for the tablespace TESTD,But when i specified the path
i put 'D:\ORADATA\TESTDB03.DBF' instead of 'D:\ORADATA\TESTDB\TESTDB03.DBF'
so i want to move this datafile to
D:\ORADATA\TESTDB would you guys please help me t resolve this...
i have an another doubt is there any problem with datafile location mismatch as mentioned above??
and Connor said...
alter tablespace TESTDB offline;
move the file to the new location
alter database rename file 'D:\ORADATA\TESTDB03.DBF' to 'D:\ORADATA\TESTDB\TESTDB03.DBF';
alter tablespace TESTDB online;
should take care of it.
Is this answer out of date? If it is, please let us know via a Comment