| tablespace maintenance [message #56931] |
Wed, 07 May 2003 12:52  |
bill mcbride
Messages: 12
Registered: May 2003
|
Junior Member |
|
|
I have installed Oracle9i on a server running Redhat Advanced Server and have the following issue:
I have a .dbf file that is consuming all capacity in the fiesystem it sits in. What is the procedure for moving the file to a different directory and making Oracle aware of this new location? I appreciate any help I can get!
|
|
|
|
| Re: tablespace maintenance [message #56932 is a reply to message #56931] |
Wed, 07 May 2003 14:14  |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
Hello here is a sample.
Alter tablespace Temp offline;
alter database rename file 'D:oracleoradataprincetemp01.dbf' to
'D:oracletemp01.dbf';
If required u have to say
Alter database recover datafile <datafile#>;
Else u can say
Alter tablespace temp online;
thats it..
your datafile is moved from 'D:oracleoradataprincetemp01.dbf' to
'D:oracletemp01.dbf';
hope that helps..
sai
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
