Monday, November 18, 2013

User names and tablespace names


Select all schema user names
select username from dba_users;


Select all tablespace names
select tablespace_name from dba_tablespaces;


Create a simple tablespace
CREATE TABLESPACE POOL_TS
  DATAFILE 'pool_ts.dat'
  SIZE 20M AUTOEXTEND ON;

No comments: