oracle 基本操作

来源：互联网发布：c语言实现多线程编辑：程序博客网时间：2024/06/10 19:19

1、用户登录
sqlplus 帐号/密码

2、查看当前登录用户
show user;
3、查看所有的用户
select username from all_users;

4、创建临时表空间

create temporary tablespace test_temp
tempfile 'D:\oracle\oradata\testserver\test_temp01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;

5、创建数据表空间
create tablespace test_data
logging
datafile 'D:\oracle\oradata\testserver\test_data01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;

6、创建用户并指定表空间
create user tb_test identified by tb_test
default tablespace test_data
temporary tablespace test_temp
quota unlimited on test_data
account unlock;

7、用户角色授权

GRANT CONNECT,DBA, RESOURCE TO tb_test

8、删除用户
DROP USER tb_test CASCADE

9、导出数据
exp.exe tb_test/tb_test@test owner=tb_test file="d:\daochu.dmp" compress=n

10、导入数据
imp tb_test/tb_test@test full = y file="d:\daochu.dmp" ignore=y log=e:\log.txt