Oracle开发基本操作语句

最新推荐文章于 2022-06-27 11:56:04 发布

原创最新推荐文章于 2022-06-27 11:56:04 发布 · 470 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle数据库操作基本语句

java开发经验专栏收录该内容

27 篇文章

订阅专栏

本文介绍在Oracle数据库中创建表空间、用户及其权限分配的过程，并演示了数据导入导出的操作步骤。此外，还提供了调整表空间大小及删除表空间和用户的示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

--创建表空间并赋用户权限
create tablespace CIQ_BUDGET datafile 'D:\oracle\product\10.2.0\oradata\orcl\ciq_budget.dbf' size 100M;
create user ciq identified by ciq default tablespace CIQ_BUDGET;
grant connect,resource,dba to ciq;

--总局
CREATE USER ciqbudget_zj IDENTIFIED BY ciqbudget_zj DEFAULT TABLESPACE CIQ_BUDGET ACCOUNT UNLOCK;
grant connect,resource to ciqbudget_zj;
--技术中心
CREATE USER ciqbudget_js IDENTIFIED BY ciqbudget_js DEFAULT TABLESPACE CIQ_BUDGET ACCOUNT UNLOCK;
grant connect,resource to ciqbudget_js;

CREATE USER bjciqportal IDENTIFIED BY bjciqportal DEFAULT TABLESPACE CIQ_BUDGET ACCOUNT UNLOCK;
grant connect,resource to bjciqportal;

--导入总局用户数据
imp ciq/ciq@ORCL　file=d:ciq_budget_8_11_2013-12-11-23-00-00.dmp fromuser=CIQ_BUDGET touser=ciqbudget_zj ignore=y log=ciqbudget_zj.log

--导入技术中心用户数据
imp ciq/ciq@ORCL　file=d:ciq_budget_2013-01-15.DMP fromuser=CIQ_BUDGET touser=ciqbudget_js ignore=y log=ciqbudget_js.log
imp ciq/ciq@ORCL　file=d:*********.DMP fromuser=CIQ_BUDGET touser=bjciqportal ignore=y log=ciqbudget_js.log

--删除表空间
DROP TABLESPACE CIQ_BUDGET_ZJ INCLUDING CONTENTS;
--删除用户
DROP USER ciq_budget CASCADE;
--调整表空间大小
alter database datafile 'D:\oracle\product\10.2.0\oradata\orcl\ciq_budget.dbf' resize 200M;

CREATE USER CIQ_BUDGET IDENTIFIED BY CIQ_BUDGET DEFAULT TABLESPACE CIQ_BUDGET ACCOUNT UNLOCK;
grant connect,resource to CIQ_BUDGET;

imp ciq/ciq@ORCL　file=d:ciq_budget_2013-01-15.DMP fromuser=CIQ_BUDGET touser=CIQ_BUDGET ignore=y log=CIQ_BUDGET.log

导出
exp CIQ_FOODSTUFF/CIQ_FOODSTUFF@172.20.18.80 file=d:CIQ_FOODSTUFF_20140402.dmp