✍ Kashif M
Trends

Friday, 26 July 2013


To Drop Tablespace in oracle


By on July 26, 2013


SQL> drop tablespace kk including contents;
Tablespace dropped.

SQL>
SQL> select username from dba_users:
It will display all the username in the DB

SQL> select name from v$database;
NAME
ORCL
It will display the DB name


Sql> select count(*) from user_objects;
It will display all the objects in that schema.

Kashif
mkashu: To Drop Tablespace in oracle
Review : Kashif | Kashif
Update: July 26, 2013 | Rating: 4.5

Comment for "To Drop Tablespace in oracle"

0 comments

Post a Comment

Blog Archive