复制内容到剪贴板
代码:
CREATE TABLESPACE "DAT"
LOGGING
DATAFILE
'/data/orcl/oradata/dbms/dat00.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
'/data/orcl/oradata/dbms/dat01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
'/data/orcl/oradata/dbms/dat02.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
'/data/orcl/oradata/dbms/dat03.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;
CREATE TABLESPACE "IDX"
LOGGING
DATAFILE
'/data/orcl/oradata/dbms/idx00.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
'/data/orcl/oradata/dbms/idx01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
'/data/orcl/oradata/dbms/idx02.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
'/data/orcl/oradata/dbms/idx03.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;
DROP USER DEV CASCADE;
CREATE USER "DEV" PROFILE "DEFAULT"
IDENTIFIED BY "dev" DEFAULT TABLESPACE "DAT"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;
GRANT "CONNECT" TO "DEV";
GRANT "DBA" TO "DEV";
GRANT "RESOURCE" TO "DEV";