Home » RDBMS Server » Server Administration » tablespace query
tablespace query [message #341814] Wed, 20 August 2008 07:15 Go to next message
Messages: 26
Registered: July 2008
Junior Member

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
Re: tablespace query [message #341815 is a reply to message #341814] Wed, 20 August 2008 07:21 Go to previous message
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:

Current Time: Mon Oct 24 05:31:17 CDT 2016

Total time taken to generate the page: 0.13060 seconds