Warning: include_once(/home/tabrez/www/talk/mtrefsearch.php) [function.include-once]: failed to open stream: No such file or directory in /home/tabrezsyed/mandalivia.com/talk/archives/000489.php on line 118
Warning: include_once() [function.include]: Failed opening '/home/tabrez/www/talk/mtrefsearch.php' for inclusion (include_path='.:/usr/local/lib/php:/usr/local/php5/lib/pear') in /home/tabrezsyed/mandalivia.com/talk/archives/000489.php on line 118
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 July 22, 2003 11:45 AMComments
Post a comment