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)
)
)