| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 9i problems.. renaming datafiles
>
> SYS_at_PRACTICE> alter database datafile 4 offline;
>
> Database altered.
>
> SYS_at_PRACTICE> alter database datafile 4 online;
> alter database datafile 4 online
> *
> ERROR at line 1:
> ORA-01113: file 4 needs media recovery
> ORA-01110: data file 4: 'C:\ORACLE\ORADATA\PRACTICE\INDX01.DBF'
>
You should take the tablespace offline, not the datafile.
R. Received on Wed Jun 19 2002 - 11:55:15 CDT
 |
 |