OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » tablespace query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

tablespace query [message #341814]

Wed, 20 August 2008 07:15

diamond
Messages: 26
Registered: July 2008

Junior Member

hi,

I hav a doubt.

when the tablespace is taken offline.. n then we issue a select statement to one of the tables in that tablespace....how wil the data be accessed?i mean from where???

Thakns & regards

Report message to a moderator

Re: tablespace query [message #341815 is a reply to message #341814]

Wed, 20 August 2008 07:21

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

SQL> alter tablespace users offline;

Tablespace altered.

SQL> select count(*) from scott.emp;
select count(*) from scott.emp
                           *
ERROR at line 1:
ORA-00376: file 4 cannot be read at this time
ORA-01110: data file 4: 'F:\ORACLE\PRODUCT\10.1.0\ORADATA\ORAMFE\USERS01.DBF'

Did you able to perform select statement?

[Updated on: Wed, 20 August 2008 07:22]

Report message to a moderator

Previous Topic:	set up an Oracle 10g database from existing ones
Next Topic:	Regular interval backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 07:17:09 CDT 2024