分兩步
1。建立bat文件，內(nèi)容如下：
@echo off
title 代開系統(tǒng)數(shù)據(jù)庫搭建
sqlplus system/systemmanager@oracle @createCompareDB.sql
pause
2。建立sql文件，內(nèi)容如下：
DROP USER NXCOMPARE CASCADE;
/
DROP TABLESPACE COMPARE INCLUDING CONTENTS AND DATAFILES;
/
COMMIT;
CREATE TABLESPACE "COMPARE"
LOGGING
DATAFILE 'D:\ORACLE\ORADATA\ORACLE\COMPARE.ora' SIZE
512M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
/
CREATE USER "NXCOMPARE" PROFILE "DEFAULT"
IDENTIFIED BY "64compare" DEFAULT TABLESPACE "COMPARE"
TEMPORARY TABLESPACE "TEMP"
QUOTA UNLIMITED
ON "COMPARE"
ACCOUNT UNLOCK
/
GRANT "CONNECT" TO "NXCOMPARE"
/
--用戶表==================================================
create table NXCOMPARE.USERS(
userID varchar2(10) ,
userName varchar2(50),
password varchar2(20),
purview varchar2(5),
userCode varchar2(20),
step char(1),
dk_pc_ip varchar2(20),
creator varchar2(10),
creatDate timestamp,
updater varchar2(10),
updateDate timestamp,
primary key (userID)
)
/
posted on 2011-09-14 16:28
kxbin 閱讀(1378)
評論(0) 編輯 收藏 所屬分類:
ORACLE