Orcale 操作

最新推荐文章于 2024-08-27 15:56:04 发布

qsbxx

最新推荐文章于 2024-08-27 15:56:04 发布

阅读量92

点赞数

文章标签： SQL C C++ C# F#

本文链接：https://blog.csdn.net/qsbxx/article/details/83367715

版权

1、建立用户

CREATE TABLESPACE NNC_DATA01 DATAFILE 'D:\NcOradata\nnc_data01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;

CREATE TABLESPACE NNC_DATA02 DATAFILE 'D:\NcOradata\nnc_data02.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;

CREATE TABLESPACE NNC_DATA03 DATAFILE 'D:\NcOradata\nnc_data03.dbf' SIZE 500M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K ;

CREATE TABLESPACE NNC_INDEX01 DATAFILE 'D:\NcOradata\nnc_index01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;

CREATE TABLESPACE NNC_INDEX02 DATAFILE 'D:\NcOradata\nnc_index02.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;

CREATE TABLESPACE NNC_INDEX03 DATAFILE 'D:\NcOradata\nnc_index03.dbf' SIZE 500M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;

CREATE USER zhongtou IDENTIFIED BY zhongtou DEFAULT TABLESPACE NNC_DATA01 TEMPORARY TABLESPACE temp;

GRANT connect,dba to zhongtou;

2、导入数据
imp zhongtou/zhongtou@ORCL_ga file=F:\nc.dmp full=y

3、删除用户
drop user user1 CASCADE ;


create tablesapce tabs 2 datafile "c:/tab.dbf" size 10M;

alert user test default tablespace tabs;

grant unlimited tablespace,dba to test;

connect test/test1;


grant select on scott.test to test with grant option;
connect test/test1;
grant select on scott.test to qqq;

revoke select on scott.test from test;