Home » RDBMS Server » Backup & Recovery » import from user to user
import from user to user [message #139795] Thu, 29 September 2005 11:09 Go to next message
fabio_sax
Messages: 5
Registered: September 2005
Junior Member
Hello there,
I'm trying to import a dmp getting the following error message:
IMP-00015
IMP-00003
ORA-01658

So I exported data form userA with the following commadn:

exp userA/passwd@tsfdb file=user.dmp

Now i'trying to import this file using:

imp system/passwd@tsfdb file=user.dbm fromuser=userA touser=new

getting the errors mentioned above.I aslo revoked the privilege RESOURCE to the new userbut nothing changed.
The import is copying the data always to the old tablespace that is the default tablespace of userA.

Could you please help me?
regards and thanks in advance.
Fabio
Re: import from user to user [message #139798 is a reply to message #139795] Thu, 29 September 2005 11:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
post the session log, oracle versions
Re: import from user to user [message #139934 is a reply to message #139795] Fri, 30 September 2005 02:21 Go to previous messageGo to next message
fabio_sax
Messages: 5
Registered: September 2005
Junior Member
Hello,
8.1.7 and here you are a part of the log:

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path

Warning: the objects were exported by CQREP, not by you

import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. importing CQREP's objects into CQ_REPOLD
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "MASTER_DBS" ("MASTER_DBID" NUMBER(10, 0), "VERSION" NUMBER(10"
", 0), "DB_NUM" NUMBER(10, 0), "NAME" VARCHAR2(5), "DESCRIPTION" VARCHAR2(80"
"), "VENDOR" NUMBER(10, 0), "SERVER" VARCHAR2(30), "DATABASE_NAME" VARCHAR2("
"255), "TABLE_PREFIX" VARCHAR2(100), "METASCHEMA_VERSION" NUMBER(10, 0), "SC"
"HEMA_ID" NUMBER(10, 0), "SCHEMA_REV" NUMBER(10, 0), "SCHEMAREV_VERSION" NUM"
"BER(10, 0), "INITIALIZED" NUMBER(10, 0), "IS_MASTER" NUMBER(10, 0), "IS_DEL"
"ETED" NUMBER(10, 0), "DB_OWNERSHIP" NUMBER(10, 0), "IS_VISIBLE" NUMBER(10, "
"0), "F1" VARCHAR2(255), "F2" VARCHAR2(255), "CONNECT_OPTIONS" LONG) PCTFRE"
"E 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 20480 NEXT "
"20480 MINEXTENTS 1 MAXEXTENTS 249 PCTINCREASE 50 FREELISTS 1 FREELIST GROUP"
"S 1 BUFFER_POOL DEFAULT) TABLESPACE "CQ_REP""
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "MASTER_GLOBAL" ("SITE_ID" NUMBER(10, 0), "SITE_NAME" VARCHAR2"
"(5), "SET_NAME" VARCHAR2(255), "METASCHEMA_VERSION" NUMBER(10, 0), "NEXT_MA"
"STER_ID" NUMBER(10, 0), "NEXT_DB_NUM" NUMBER(10, 0), "NEXT_SCHEMA_NUM" NUMB"
"ER(10, 0), "NEXT_PACKAGE_ID" NUMBER(10, 0), "NEXT_PACKAGE_OWNERSHIP_ID" NUM"
"BER(10, 0), "NEXT_PACKAGE_SCRIPT_ID" NUMBER(10, 0), "CHECK_TIMEOUT_INTERVAL"
"" NUMBER(10, 0), "TIMEOUT_INTERVAL" NUMBER(10, 0), "DB_LOCKED" NUMBER(10, 0"
"), "DB_LOCKED_INFO" VARCHAR2(255), "ROLL_USER_IDS_SCRIPT" LONG) PCTFREE 10"
" PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 20480 NEXT 2048"
"0 MINEXTENTS 1 MAXEXTENTS 249 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 "
"BUFFER_POOL DEFAULT) TABLESPACE "CQ_REP""
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "MASTER_GROUPS" ("MASTER_DBID" NUMBER(10, 0), "VERSION" NUMBER"
"(10, 0), "NAME" VARCHAR2(30), "IS_ACTIVE" NUMBER(10, 0)) PCTFREE 10 PCTUSE"
"D 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 20480 NEXT 20480 MINEX"
"TENTS 1 MAXEXTENTS 249 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_"
"POOL DEFAULT) TABLESPACE "CQ_REP""

It seems that is still copying into the original tablespaces.
Regards,
FAbio
Re: import from user to user [message #139935 is a reply to message #139934] Fri, 30 September 2005 02:22 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
use IGNORE=Y in imp statement.
Re: import from user to user [message #139942 is a reply to message #139935] Fri, 30 September 2005 02:35 Go to previous messageGo to next message
fabio_sax
Messages: 5
Registered: September 2005
Junior Member
Hello Girish,
using it the proscess is going on but ii got the following error messages:
IMP-00019 row rejected due to ORACLE error 1
IMP-00003 Oracle error 1 encountered
ORA-00001 unique constraint <CQ_REPOLD.M_ACTIONDEF_ID> violated.

Thanks in advance.
FAbio
Re: import from user to user [message #139953 is a reply to message #139934] Fri, 30 September 2005 03:02 Go to previous messageGo to next message
fabio_sax
Messages: 5
Registered: September 2005
Junior Member
Hello,
here others error:

Warning: the objects were exported by CQREP, not by you

import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. importing CQREP's objects into CQ_REPOLD
. . importing table "MASTER_DBS"
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (CQ_REPOLD.MASTER_DBS_IDS) violated

Column 7 1 0 rows imported
. . importing table "PACKAGEREV_USAGE"
IMP-00058: ORACLE error 1536 encountered
ORA-01536: space quota exceeded for tablespace 'CQ_REP'
IMP-00028: partial import of previous table rolled back: 132 rows rolled back
. . importing table "PACKAGE_RELEASES" 0 rows imported
. . importing table "RELEASE_SCHEMAREVS" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE TABLE "SCHEMAREV_BINARIES" ("SCHEMA_ID" NUMBER(10, 0), "SCHEMA_REV" "
"NUMBER(10, 0), "ID" NUMBER(10, 0), "DATA" LONG RAW) PCTFREE 10 PCTUSED 40 "
"INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 19681280 NEXT 9818112 MINEX"
"TENTS 1 MAXEXTENTS 249 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_"
"POOL DEFAULT) TABLESPACE "CQ_REP""
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CQ_REP
. . importing table "SCHEMAREV_TEXTS" 0 rows imported
Import terminated successfully with warnings.


thanks in advance.
Fabio
Re: import from user to user [message #140005 is a reply to message #139953] Fri, 30 September 2005 08:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
First truncate the existing data in tables.
then use Ignore=y ( As girish said).
Else you will get uniqe constraint violated ( if there is a PK in the table).
For the second issue,
You dont have adequate space in the desitnation tablespace.
Always export with compress=n, have enough space in destination.
Re: import from user to user [message #140012 is a reply to message #139795] Fri, 30 September 2005 08:36 Go to previous message
fabio_sax
Messages: 5
Registered: September 2005
Junior Member
Thanks so much to everyone...
I used the index file and then rerun import and everything worked fine.

Regards to everyone.
I appreciated your fantastic help.

/Fabio
Previous Topic: Data Pump Export Errors
Next Topic: Import error
Goto Forum:
  


Current Time: Thu Mar 28 18:08:03 CDT 2024