Friday, July 18, 2014

How to create and drop tablespace

How to create New Tablespace

create tablespace users datafile '/shared/sync/data/users_o1.dbf' size 2G;

How to drop tablespace

DROP TABLESPACE users;
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to create user in MY SQL

Create  a new MySQL user Account mysql > CREATE USER ' newuser '@'localhost' IDENTIFIED BY ' password '...

  • Lock Script
    Hii All  Today i'm posting  lock script. sometime some session block to other session. This situation is very critical because our wh...
  • IMPOTED Excel/Text File Data USING TOAD
    IMPOTED Excel/Text File Data Into Oracle Table Using TOAD Step 1 :  Open TOAD. Step 2 :  Write the following query to create a test tabl...
  • Audit - Enabling or Disabling Audit Trail
    Auditing in Oracle Database The Oracle Server provides several auditing options. The following three types of audits are provi...