mv expdat.expdp.BRV11T2.sonder.N4TOST2.B3.0_C1.13 /home/oracle/app/oracle/admin/satu/dpdump/expdat.dmp impdp
Zegt zelf wel waar hij problemen mee heeft. Mekkert over users, table spaces en niet genoeg ruimte in de table space.
sqlplus /nolog
connect / as SYSDBA
create user N4TOST2 identified by S3marang;
create tablespace N4TOST2 DATAFILE '/home/oracle/app/oracle/oradata/satu/n4tost2.dbf' size 1G extent management local autoallocate;
alter database datafile '/home/oracle/app/oracle/oradata/satu/n4tost2.dbf' resize 10G;
select dbms_metadata.get_ddl('TABLESPACE','N4TOST2' ) from dual;
=== TNSNAMES ===
[oracle@burung ~]$ tnsping satu
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 24-JUL-2013 14:53:14
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
[oracle@burung ~]$ vi ./app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
[oracle@burung ~]$ tnsping satu
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 24-JUL-2013 15:05:32
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = burung.mcint.local) (PORT=1521))) (CONNECT_DATA = (SERVICE_NAME = satu)))
OK (20 msec)