oracle创建用户导入数据

最新推荐文章于 2023-01-10 17:25:58 发布

原创最新推荐文章于 2023-01-10 17:25:58 发布 · 296 阅读

0 ·

CC 4.0 BY-SA版权

oracle 专栏收录该内容

4 篇文章

订阅专栏

本文详细介绍了Oracle数据库中表空间的创建与删除方法，包括临时表空间和数据表空间的操作，并演示了如何创建用户及授予相应的权限。此外，还提供了导入数据库及修改密码的具体步骤。

--删除表空间
drop tablespace PMSTEST_TEMP including contents and datafiles;
drop tablespace PMSTEST_DATA including contents and datafiles;

--select username,sid,serial# from v$session;
--alter system kill session '160,1769';

select username from dba_users;

drop user PMSTEST cascade;

--drop tablespace wds_temp including contents and datafiles
--创建临时表空间
create temporary tablespace pmstest_temp
tempfile 'D:\oracle11g\oradata\pmstest_temp.dbf'
size 10m
autoextend on
next 20m maxsize 2048m
extent management local;

--创建数据表空间
create tablespace pmstest_data
logging
datafile 'D:\oracle11g\oradata\pmstest_data.dbf'
size 10m
autoextend on
next 20m maxsize 2048m
extent management local;

--创建用户并指定表空间
/*create user pmstest identified by pmstest
default tablespace pmstest_data
temporary tablespace pmstest_temp;

--给用户授予权限
grant connect,resource,dba to pmstest;

*/
---创建用户
create user pmstest
identified by "pmstest"
default tablespace pmstest_data
temporary tablespace pmstest_temp
profile DEFAULT;
----赋予用户权限
grant connect to pmstest;
grant dba to pmstest;
grant resource to pmstest;

grant select on sys.dba_pending_transactions to pmstest;
grant select on sys.pending_trans$ to pmstest;
grant select on sys.dba_2pc_pending to pmstest;
grant execute on sys.dbms_system to pmstest;

---------------------------------------------------------
--导入数据库
--imp pmstest/pmstest@ORCL file=C:\pms20150108.dmp full=yes ignore=y
--修改密码
--update t_sys_user t set t.passd='z80ghJXVZe9m59/5+Ydk2g=='--0