Create Table Space and Users in 3 Steps


CREATE TABLESPACE sqljunkie 
logging 
datafile ‘C:\app\oradata\orcl\sqljunkie.dbf’ 
size 32m 
autoextend ON NEXT 32m 
maxsize 2048m extent management local;
CREATE undo TABLESPACE 
sqljunkie_undodatafile ‘C:\app\oradata\orcl\undo.dbf’
size 100M;
CREATE TEMPORARY TABLESPACE sqljunkie_temptempfile 
‘C:\app\oradata\orcl\sqljunkie_temp.dbf’ 
size 32m 
autoextend ON NEXT 32m 
maxsize 2048m extent management local;
CREATE USER sqljunkie 
IDENTIFIED BY sqljunkieDEFAULT 
TABLESPACE sqljunkie 
TEMPORARY TABLESPACE sqljunkie_temp;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s