PL/SQL creates tablespaces, creates users, and authorizes users.
DeclareusrName varchar2 (20): = 'username'; pwd varchar2 (20): = 'Password'; tsName varchar2 (20): = 'xmszcgl _ aid '; dfPath varchar2 (300): = 'd: \ dataSource \ xmszcgl_aid.data '; tmpStr varchar2 (300); isDelUsrAndTs boolean: = false; begin www.2cto.com
If isDelUsrAndTs thentmpStr: = 'drop user' | usrName | 'cascade '; execute immediate tmpStr; tmpStr: = 'drop tablespace' | tsName | 'including contents and datafiles'; execute immediate tmpStr; end if; tmpStr: = 'create tablespace' | tsName | 'datafile' | dfPath | '''size 300 m autoextend on next 5 m maxsize unlimited'; execute immediate tmpStr; tmpStr: = 'create user' | usrName | 'identified by' | pwd | 'default tablespace' | tsName; execute immediate tmpStr; tmpStr: = 'Grant connect, resource, dba to '| usrName; execute immediate tmpStr; end; Author: fengxuezhiye