创建oracle数据库命令
(一)数据库导入方式
1、建库
system默认:manager
sys默认:change_on_install
运行安装程序带的: Database configuration Assistant
数据库实例 dbs_db
2.用SYS用户登陆创建表空间
CREATE TABLESPACE TSP_YDEMR
logging
DATAFILE ‘e:\oracle\product\10.2.0\oradata\dbs_db\DBSMR.DBF’
SIZE 32m
AUTOEXTEND ON
NEXT 32m
EXTENT MANAGEMENT LOCAL;
注意:
**DATAFILE:**数据库实例的路径
3.创建用户
create user dbsdba identified by sa
default tablespace TSP_YDEMR;
4.给用户授予权限
grant connect,resource,dba to dbsdba
GRANT
CREATE SESSION, CREATE ANY TABLE , CREATE ANY VIEW , CREATE ANY INDEX , CREATE ANY PROCEDURE ,
ALTER ANY TABLE , ALTER ANY PROCEDURE ,
DROP ANY TABLE , DROP ANY VIEW , DROP ANY INDEX , DROP ANY PROCEDURE ,
SELECT ANY TABLE , INSERT ANY TABLE , UPDATE ANY TABLE , DELETE ANY TABLE
TO dbsdba ;
5.用imp导入备份数据库