| ORa-01135 [message #193512] |
Mon, 18 September 2006 00:54  |
rtjk
Messages: 33
Registered: February 2005
|
Member |
|
|
Hai ,,
need a urgent help.. I have a tablespace having two datafiles.
I was trying to resize (increase) the particular tablespace (2nd data_file).
Iam getting the error - ora -01135. But the tablespace is in available status in dba_data_files,but in V$datafile it shows that particular datafile status is showing recover.Our db is in archive log mode ..
Please tell me what to do in this case.ths is urgent
regards
jay...
|
|
|
|
| Re: ORa-01135 [message #193576 is a reply to message #193512] |
Mon, 18 September 2006 05:53  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
From SQL*Plus:
CONNECT SYS/... AS SYSDBA
ALTER DATABABSE DATAFILE ... OFFLINE;
RECOVER DATAFILE ...
ALTER DATABASE DATAFILE ... ONLINE;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
