SLTechnology News&Howtos › Database ›

Oracle11G script to build users, tablespaces and tables under windows

Shulou Source: shulou.com Published: 2022-06-01 06:56:39 11月15日 Update

@ echo off

Set uname=%1%

Set pword=%2%

Echo uname%

Echo pword%

Echo @ echo off > C:\ createUser.sql

Echo create temporary tablespace user_temp > > C:\ createUser.sql

Echo tempfile'C:\ app\ Administrator\ oradata\ user_temp.dbf' > > C:\ createUser.sql

Echo size 50m > > C:\ createUser.sql

Echo autoextend on > > C:\ createUser.sql

Echo next 50m maxsize 20480m > > C:\ createUser.sql

Echo extent management local; > > C:\ createUser.sql

Echo create tablespace user_data > > C:\ createUser.sql

Echo logging > > C:\ createUser.sql

Echo datafile'C:\ app\ Administrator\ oradata\ user_data.dbf' > > C:\ createUser.sql

Echo size 50m > > C:\ createUser.sql

Echo autoextend on > > C:\ createUser.sql

Echo next 50m maxsize 20480m > > C:\ createUser.sql

Echo extent management local; > > C:\ createUser.sql

Echo create user uname% identified by pword% > > C:\ createUser.sql

Echo default tablespace user_data > > C:\ createUser.sql

Echo temporary tablespace user_temp; > > C:\ createUser.sql

Echo grant connect,resource,dba to% uname%; > > C:\ createUser.sql

Echo exit; > > C:\ createUser.sql

Echo @ echo off > C:\ createTable.sql

Echo CREATE TABLE DEPT > > C:\ createTable.sql

Echo (DEPTNO NUMBER (2) CONSTRAINT PK_DEPT PRIMARY KEY, > > C:\ createTable.sql

Echo DNAME VARCHAR2 (14), > C:\ createTable.sql

Echo LOC VARCHAR2 (13); > C:\ createTable.sql

Echo INSERT INTO DEPT VALUES (1) > C:\ createTable.sql

Echo INSERT INTO DEPT VALUES (2) > C:\ createTable.sql

Echo INSERT INTO DEPT VALUES (3 recordings wirelessness recordings Piane); > > C:\ createTable.sql

Echo COMMIT; > > C:\ createTable.sql

Echo exit; > > C:\ createTable.sql

Sqlplus / as sysdba @ C:\ createUser.sql

Sqlplus% uname%/%pword%@orcl @ C:\ createTable.sql

Exit 0