oracle相关-卸载-安装-建立用户等-优快云博客

本文详细介绍了如何在Oracle数据库环境中，在sys管理员账号下建立用户空间、创建用户并分配权限，包括使用exp和imp命令进行数据导出和导入。同时，提供了tnsnames.ora文件配置示例，确保了数据库连接的正确性。

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

orcl

http://jingyan.baidu.com/article/380abd0aadb63a1d90192cec.html

http://jingyan.baidu.com/album/922554468d4e6b851648f4e3.html?picindex=7

http://wenku.baidu.com/link?url=lw7AQFNSBPlKPqZMP4t5Bzl7V4wFGPfrmGnDmHLqs8bbdR5_I8NkMoErX9sPeLk3lerdSBh08sZ7HLjZ_kf0Xl-wbGu62X3cotKVDUSi2NO

--在sys最高管理员下建立
--用户空间
create tablespace Hdmzuser
datafile 'E:\worksoft\oracle\oradata\orcl\Hdmzuser.dbf'
size 50m autoextend on next 10m maxsize unlimited
logging extent management local segment space management auto;
--建立用户
create user Hdmzuser
identified by Hdmzuser default tablespace Hdmzuser
temporary tablespace temp;
--赋予权限
grant dba to Hdmzuser;

--导出
exp Hdmzuser/Hdmzuser@orcl file=e:\a.dmp
--导入
imp Hdmzuser/Hdmzuser@orcl file=e:\a.dmp full=y

# tnsnames.ora Network Configuration File: E:\worksoft\oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

DEV =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.124.86)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dev)
)
)