Creating a tablespace and user in Oracle Database
TABLESPACE :
create tablespace sample datafile 'C:\oracle\product\10.2.0\oradata\orcl\sample.dbf' size 10M autoextend on next 10M;
USER:
CREATE USER sample IDENTIFIED BY sample DEFAULT TABLESPACE sample TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON sample;
GRANT ALL PRIVILEGES TO sample;
No comments:
Post a Comment