CREATE TABLESPACE USER

-
create user scott identified by tiger default tablespace userdata;



User created.


0.03 seconds


granting privileges;

grant connect , resource to scott;


Statement processed.


0.04 seconds


SQL> conn scott/tiger;
Connected.
SQL> select default_tablespace from user_users;

DEFAULT_TABLESPACE
------------------------------
USERDATA

SQL>

Comments

Post a Comment

Popular posts from this blog

ADD DATAFILE TO USERDATA

-
alter  tablespace userdata add datafile 'C:\oraclexe\oradata\xe\userdata2.dbf' size 2m; Statement processed. 0.55 seconds SELECT TABLESPACE_NAME, FILE_NAME, FILE_ID FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'USERDATA'; USERDATA C:\ORACLEXE\ORADATA\XE\USERDATA1.DBF 5 USERDATA C:\ORACLEXE\ORADATA\XE\USERDATA2.DBF 7 SELECT  FILE_NAME, BLOCKS    FROM DBA_DATA_FILES where TABLESPACE_NAME = 'USERDATA'; FILE_NAME                                                       BLOCKS C:\ORACLEXE\ORADATA\XE\USERDATA1.DBF    256 C:\ORACLEXE\ORADATA\XE\USERDATA2.DBF    256
Read more

CREATE TABLESPACE

-
create tablespace userdata datafile 'C:\oraclexe\oradata\xe\data1.dbf' size 1m; Statement processed. 0.58 seconds select tablespace_name ,status ,contents  from dba_tablespaces; USERDATA ONLINE PERMANENT select tablespace_name ,status ,contents , block_size from dba_tablespaces; USERDATA ONLINE  PERMANENT    8192
Read more