July 22, 2003

define tablespaceName = TBS_USER
define userName = USER
define userPW = PASSWORD

CREATE TABLESPACE &tablespaceName
DATAFILE '&tablespaceName..ora'
SIZE 1M REUSE AUTOEXTEND ON
NEXT 1M MAXSIZE 2040M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 100K;

CREATE USER &userName. IDENTIFIED BY &userPW.
DEFAULT TABLESPACE &TablespaceName.
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON &tablesapceName;

GRANT connect,resource,create session,select any table,create table,create procedure,create trigger,create view,create sequence,create synonym,create public synonym TO &userName;

Posted at 11:45 AM | Comments (0)
Search


Archives
December 2002
November 2002
October 2002
September 2002
August 2002
July 2002
June 2002
May 2002
April 2002
March 2002
February 2002
January 2002
Recent Entries
Omnibus disputantum
Zen and science
Do not be
A map of Madras
Gift Giving
Abstract Expressionism
Magritte's Pipe
Is it a Bird? A work of Art?
Feminism
Newspaper boy problem
Categories
business
general
history
misc
philosophy
pop-culture
quotes
tech
Blogs
Metafilter
Arts and Letters Daily
Sapta-Sindhu
Beemblog
Misc...
Movies seen
Books read
Bush Says