全部博文
-
编辑 删除
orcal快速新建表空间，创建用户语句 zs
创建表空间：创建用户： CREATE SMALLFILE TABLESPACE "GWBZB200W" DATAFILE 'E:oracleproduct10.2.0oradatazbgwdbgwbzb200w ' SIZE 1000M AUTOEXTEND ON NEXT 102400K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; CREATE USER "W200" PROFILE "DEFAULT" IDENTIFIED BY "111111" DEFAULT TABLESPACE "GWBZB200W" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK; GRANT "CONNECT" TO "W200"; GRANT "DBA" TO "W200"; GWBZB200W为创建的表空间名称，E:oracleproduct10.2
