CREATE USER PUBSYS
IDENTIFIED BY YYC_PUBSYS
DEFAULT TABLESPACE PUBSYS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
/
GRANT CONNECT TO PUBSYS WITH ADMINOPTION
/
GRANT DBA TO PUBSYS WITH ADMIN OPTION
/
GRANT RESOURCE TO PUBSYS WITH ADMINOPTION
/
GRANT SELECT ANY TABLE TO PUBSYS WITHADMIN OPTION
/
GRANT UNLIMITED TABLESPACE TO PUBSYSWITH ADMIN OPTION
2.创建对于的表空间(4610M)
CREATE TABLESPACE PUBSYS
DATAFILE 'C:\APP\ADMINISTRATOR\ORADATA\TJXY\PUBSYS.DBF' SIZE