oracle数据库常用命令

来源：互联网发布：极致追击知乎编辑：程序博客网时间：2024/06/06 01:35

创建表空间
create tablespace TESTDB datafile 'E:\oracle\product\10.2.0\oradata\test\testdb.dbf' size 10240M
autoextend on next 10250M maxsize 10270M
default storage(initial 10M next 1M)
permanent
online
logging;
create tablespace YLBXTEMP datafile 'D:\oracle\product\10.2.0\oradata\ylbx\ylbxtemp.dbf' size 5120M
autoextend on next 7680M maxsize 10240M
default storage(initial 10M next 1M)
permanent
online
logging;

创建用户并指定表空间
create user SYSDATA identified by SYSDATA
default tablespace TESTDB
profile DEFAULT;

create user webuser identified by web
default tablespace ylbx01
temporary tablespace YLBXTEMP
profile DEFAULT;

给用户授予权限

grant dba,connect,resource to SYSDATA;
grant connect to webuser;

导入数据备份文件
imp userid=yjjcdb/yjjcdb file='D:\yjjc.dmp' fromuser=yjjcdb touser=yjjcdb log='D:\import.log'

imp userid=yjjcdb/yjjcdb@igrp_127.0.0.1 file='D:\yjjc.dmp' fromuser=yjjcdb touser=yjjcdb log='D:\import.log'

exp yjjcdb/yjjcdb@igrp_127.0.0.1 file=yjjcdb_20110617.dmp owner=yjjcdb

exp carmot/carmot@igrp_127.0.0.1 file=D:\carmot_20110822_tbmenurolelist.dmp owner=carmot

删除表空间
drop tablespace ylbx01 including contents and datafiles;
删除用户名：
drop user jmyb cascade;

drop user SYSDATA cascade;