Originally posted by ksarav

i took that tablespace ts1 offline
hi Saravann, taking a tablespace offline makes it unavailable for access, according to oracle documentation, you may want to take a tablespace offline for one of the following reasons:

1- To make a portion of the database unavailable while allowing normal access to the remainder of the database.
2- To perform an offline tablespace backup (even though a tablespace can be backed up while online and in use).
3- To make an application and its group of tables temporarily unavailable while updating or maintaining the application.

for more information on taking tablespace offline check the following link:
http://download-west.oracle.com/docs...spaces.htm#819

Hope this helps.

Regards.