Monday, December 16, 2013

Creating tablespace in Oracle and assigning users to schema

CREATE TABLESPACE JournalEntry
datafile 'JournalEntry.dbf'
size 100M;

CREATE USER JE IDENTIFIED BY Journal;

grant all privileges to JE;

alter user <username> default tablespace <tablespace_name>;

No comments:

Post a Comment