How to bring a tablespace offline?

Question Posted / saurabh pandey

How to bring a tablespace offline?..

Answer / Shyamveer

To bring a tablespace offline in Oracle, you can use the ALTER TABLESPACE command: n`ALTER TABLESPACE my_tablespace OFFLINE IMMEDIATE;`

Is This Answer Correct ?

0 Yes

0 No

More Oracle General Interview Questions

What is Public Database Link ?

What is a user account in oracle?

Will you be able to store pictures in the database?explain.

How to assign a tablespace to a users in oracle?

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

difference between imlicit cursor and explicit cursor ?

What is oracle sid?

1.display list of all users from ur data base.what is the query?

How to pass a parameter to a cursor in oracle?

What is difference between sid and service name in oracle?

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

For more Oracle General Interview Questions Click Here