linux下安装完数据库后,新建表空间的地址不在oracle安装目录内,相关操作记录如下:
用root用户授权: chown -R oracle.dba /mnt/ 切换回oracle用户,
su - oracle 登录sqlplus
sqlplus / as sysdba 创建表空间
create tablespace usc logging datafile'/mnt/oracle/oradata/orcl/usc/usc.dbf' size 1024m autoextend on next 100m maxsize unlimited extent management local; 创建用户 create user usc identified by usc default tablespace usc temporary tablespace temp; 用户授权 grant dba to ups,usc;
数据库的连接地址 ups-cloud =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =IP地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
) 导入数据库 impdp ups/ups@ip:1521/orcl schemas=dmp内用户 dumpfile=ups.dmp remap_schema=dmp用户:ups REMAP_TABLESPACE=dmp表空间:ups REMAP_TABLESPACE=mp表空间::ups REMAP_TABLESPACE=mp表空间::ups version=10.2.0 |