市场经营部署文档步骤
环境:windows服务器、tomcat、oracle数据库、pl/sql、javaweb项目war包
第一步:
1、创建表空间:
CREATE TABLESPACE "SUPP_DATA" DATAFILE
'D:\APP\ADMINISTRATOR\ORADATA\ORCL\SUPP_DATA01.DBF' SIZE 33554432
AUTOEXTEND ON NEXT 10485760 MAXSIZE 1073741824
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
ALTER DATABASE DATAFILE
'D:\APP\ADMINISTRATOR\ORADATA\ORCL\SUPP_DATA01.DBF' RESIZE 1073741824
2、创建用户:
用户名和密码相同。
授予权限:
GRANT
CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,DBA,
ALTER ANY TABLE, ALTER ANY PROCEDURE,
DROP ANY TABLE, DROP ANY VIEW, DROP AN