Home » RDBMS Server » Backup & Recovery » Remap_schema (oracle 10 g)
Remap_schema [message #539690] Wed, 18 January 2012 01:10 Go to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
I am trying to remap schema from dump file to new user but my import fails and giving me error. please help
THanks in advance.





-----------------------------------
Using username "oracle".
Last login: Tue Jan 17 17:41:30 2012 from 192.168.100.11
[oracle@cvs ~]$ dbstart
Processing Database instance "cvsdbm": log file /home/oracle/oracle/product/10.2.0/db_1/startup.log
Processing Database instance "cvmdb": log file /home/oracle/oracle/product/10.2.0/db_1/startup.log
[oracle@cvs ~]$ /as sydba
-bash: /as: No such file or directory
[oracle@cvs ~]$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 18 11:32:05 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: /as sydba
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
Enter user-name: /as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> drop user copy_tstcvs;
drop user copy_tstcvs
*
ERROR at line 1:
ORA-01918: user 'COPY_TSTCVS' does not exist


SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@cvs ~]$ impdp cvmlive/cvmlive schemas=tstcvs remap_schema=tstcvs:copy_tstcvs directory=TEST_DIR dumpfile=13-01-12-tstcvs.dmp logfile=impdp13-01-12-tstcvs.log;

Import: Release 10.2.0.1.0 - Production on Wednesday, 18 January, 2012 11:33:34

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "CVMLIVE"."SYS_IMPORT_SCHEMA_04" successfully loaded/unloaded
Starting "CVMLIVE"."SYS_IMPORT_SCHEMA_04": cvmlive/******** schemas=tstcvs remap_schema=tstcvs:copy_tstcvs directory=TEST_DIR dumpfile=13-01-12-tstcvs.dmp logfile=impdp13-01-12-tstcvs.log
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39171: Job is experiencing a resumable wait.
ORA-01659: unable to allocate MINEXTENTS beyond 160 in tablespace USERS

Import>
=======================================================


Re: Remap_schema [message #539691 is a reply to message #539690] Wed, 18 January 2012 01:13 Go to previous message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01659: unable to allocate MINEXTENTS beyond %s in tablespace %s
 *Cause:  Failed to find sufficient contiguous space to allocate MINEXTENTS
          for the segment being created.
 *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the
          tablespace or retry with smaller value for MINEXTENTS, NEXT or
          PCTINCREASE


Regards
Michel
Previous Topic: RMAN copy from tape to disk
Next Topic: Crosscheck Backup - number of expired backups issue
Goto Forum:
  


Current Time: Sat Oct 20 02:09:17 CDT 2018