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;

No comments:

Post a Comment

How to create user in MY SQL

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