Home » RDBMS Server » Server Utilities » export and import
export and import [message #197900] Fri, 13 October 2006 03:20 Go to next message
guru_karnam
Messages: 142
Registered: May 2005
Senior Member
While exporting i got warning as questionable statistics.


I created a new user with same default tablespace,same temp tablespace and tried to import the dump.

But it is giving errors in creating the types and dbms_job

The log file looks like

Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production

Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and UTF8 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing BAM's objects into BAM1
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "BUNDLEDRMINFO" TIMESTAMP '2006-10-12:16:06:25' OID '1F9ABE5204"
"C485BDE0407D0A3E4F5067' AS OBJECT"
"("
"PURCHASECODE VARCHAR2(20 CHAR),"
"YEAR NUMBER(38),"
"MONTH NUMBER(38),"
"CID VARCHAR2(50 CHAR),"
"SEK VARCHAR2(200 CHAR),"
"DCOID NUMBER(3),"
"SERVICEID VARCHAR2(20),"
"SAS VARCHAR2(200 CHAR),"
"DEFAULT_PERM_CATEGORY NUMBER(3),"
"SERVICE_COMPATIBILITY VARCHAR2(16)"
");"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "BUNDLEDRMINFOLIST" TIMESTAMP '2006-10-12:16:06:25' OID '1F9ABE"
"5204D185BDE0407D0A3E4F5067' AS VARRAY(20000) OF BUNDLEDRMINFO;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "BUNDLEINFO" TIMESTAMP '2006-10-12:16:06:25' OID '1F9ABE5204D58"
"5BDE0407D0A3E4F5067' AS OBJECT"
"("
"PURCHASECODE VARCHAR2(20 CHAR),"
"SELLABLEITEMTYPE varchar2(25),"
"SINGLE_PRICE NUMBER(16,2),"
"CONTINUOUS_PRICE NUMBER(16,2),"
"CURRENCY VARCHAR2(3 CHAR),"
"DCOID NUMBER(3),"
"PREVIEWAVAILABLE NUMBER(1),"
"PREVIEWINTERVAL NUMBER(3),"
"--MAXACTIVATIONS NUMBER(3),"
"OPERATIONCODE VARCHAR2(20 CHAR),"
"SIVERSION NUMBER,"
"--CONTENTRIGHTS NUMBER(3)"
"START_DATE DATE,"
"END_DATE DATE"
");"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "BUNDLEINFOLIST" TIMESTAMP '2006-10-12:16:06:25' OID '1F9ABE520"
"4E485BDE0407D0A3E4F5067' AS VARRAY(20000) OF BUNDLEINFO;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "PPVPROGRAMINFO" TIMESTAMP '2006-10-12:16:06:25' OID '1F9ABE520"
"4E885BDE0407D0A3E4F5067' AS OBJECT"
"("
"PURCHASECODE VARCHAR2(20 CHAR),"
"SELLABLEITEMTYPE VARCHAR2(25),"
"SINGLE_PRICE NUMBER(16,2),"
"CONTINUOUS_PRICE NUMBER(16,2),"
"CURRENCY VARCHAR2(3 CHAR),"
"DCOID NUMBER(3),"
"--TIMEZONE VARCHAR2(20),"
"PREVIEWAVAILABLE NUMBER(1),"
"PREVIEWINTERVAL NUMBER(3),"
"--MAXACTIVATIONS NUMBER(3),"
"OPERATIONCODE VARCHAR2(20 CHAR),"
"STARTTIME DATE,"
"ENDTIME DATE,"
"CID VARCHAR2(50 CHAR),"
"ENCRYPTION_KEY VARCHAR2(200 CHAR),"
"SIVERSION NUMBER,"
"--CONTENTRIGHTS NUMBER(3),"
"PERM_CATEGORY NUMBER(3),"
"AUTH_SEED VARCHAR2(200 CHAR),"
"SERVICE_COMPATIBILITY VARCHAR2(16)"
")"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "PPVPROGRAMINFOLIST" TIMESTAMP '2006-10-12:16:06:25' OID '1F9AB"
"E5204FC85BDE0407D0A3E4F5067' AS VARRAY(20000) OF PPVPROGRAMINFO;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "PURCHASE_ADAP" TIMESTAMP '2006-10-12:16:06:25' OID '1F9ABE5205"
"0085BDE0407D0A3E4F5067' AS OBJECT("
" PURCHASE_CODE VARCHAR2(20),"
" DCO_ID NUMBER,"
" TERMINAL_ID VARCHAR2(256),"
" SUBSCRIBER_ID VARCHAR2(25),"
" Price number,"
" Currency Varchar2(10),"
" SUBSCRIPTION_TYPE VARCHAR2("
"25),"
" SUBSCRIPTION_START_DATE DAT"
"E,"
" SUBSCRIPTION_END_DATE DATE,"
" LAST_RO_DELIVERY_DATE DATE,"
" NEXT_CHARGING_DATE DATE,"
" RECKON NUMBER,"
" EVENT_TYPE VARCHAR2(50),"
" RO_ID VARCHAR2(128),"
" CID VARCHAR2(200),"
" CEK VARCHAR2(200),"
" Reason varchar2(10),"
" Status varchar2(200),"
" Can_Charge char(1),"
" Item_Type varchar(25),"
" PURCHASE_CODE_VERSION number,"
" Can_Cancel number,"
" ValidityEndDate DATE"
" );"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "PURCHASE_ADAP_LIST" TIMESTAMP '2006-10-12:16:06:25' OID '1F9AB"
"E52051A85BDE0407D0A3E4F5067' as varray(10000) of PURCHASE_ADAP"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "ROPARAMETERTYPE" TIMESTAMP '2006-10-12:16:06:25' OID '1F9ABE52"
"051E85BDE0407D0A3E4F5067' AS OBJECT"
"("
"RO_ID VARCHAR2(128),"
"CID VARCHAR2(50),"
"START_TIME DATE,"
"END_TIME DATE,"
"Encryption_Key VARCHAR2(200),"
"Auth_seed VARCHAR2(200),"
"--PEK VARCHAR2(50),"
"--PAS VARCHAR2(50),"
"PREVIEW_INTERVAL INTEGER,"
"--CONTENT_RIGHTS INTEGER,"
"PERM_CATEGORY NUMBER,"
"SELLABLE_ITEM_TYPE VARCHAR2(100),"
"SERVICE_COMPATIBILITY VARCHAR2(16)"
");"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "ROPARAMETERLIST" TIMESTAMP '2006-10-12:16:06:25' OID '1F9ABE52"
"052B85BDE0407D0A3E4F5067' as varray(100) of ROPARAMETERTYPE;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SELLABLEITEMDATA" TIMESTAMP '2006-10-12:16:06:25' OID '1F9ABE5"
"2052F85BDE0407D0A3E4F5067' as object("
"purchaseCode VARCHAR2(25),"
"SELLABLEITEMName VARCHAR2(800),"
"SellableItemType varchar2(25),"
"Single_Price NUMBER(16,2),"
"Continuous_Price NUMBER(16,2),"
"Currency VARCHAR2(5),"
"DCOID NUMBER,"
"HASPreview INTEGER,"
"PreviewMAXInterval NUMBER,"
"--PreviewMAXActivations NUMBER,"
"Version NUMBER,"
"--Content_Rights NUMBER"
"ModifDate Date"
");"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SELLABLEITEMDATALIST" TIMESTAMP '2006-10-12:16:06:26' OID '1F9"
"ABE52053D85BDE0407D0A3E4F5067' AS VARRAY(100000) OF SELLABLEITEMDATA;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SELLABLEITEMNAMEINFO" TIMESTAMP '2006-10-12:16:06:26' OID '1F9"
"ABE52054185BDE0407D0A3E4F5067' AS OBJECT"
"("
"PURCHASECODE VARCHAR2(60 CHAR),"
"LANGUAGECODE VARCHAR2(20 CHAR),"
"SELLABLEITEMNAMES VARCHAR2(250 CHAR),"
"DCOID NUMBER(3)"
");"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SELLABLEITEMNAMELIST" TIMESTAMP '2006-10-12:16:06:26' OID '1F9"
"ABE52054885BDE0407D0A3E4F5067' AS VARRAY(20000) OF SELLABLEITEMNAMEINFO;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SELLABLEITEMSTATUSINFO" TIMESTAMP '2006-10-12:16:06:26' OID '1"
"F9ABE52054C85BDE0407D0A3E4F5067' AS OBJECT"
"("
"PURCHASECODE VARCHAR2(20 CHAR),"
"DESCRIPTION VARCHAR2(250 CHAR)"
")"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SELLABLEITEMSTATUSLIST" TIMESTAMP '2006-10-12:16:06:26' OID '1"
"F9ABE52055185BDE0407D0A3E4F5067' AS VARRAY(20000) OF SELLABLEITEMSTATUSIN"
"FO"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SELLITEM_DEL_INFO" TIMESTAMP '2006-10-12:16:06:26' OID '1F9ABE"
"52055585BDE0407D0A3E4F5067' AS OBJECT(PURCHASECODE VARCHAR2(20),DCOID NUM"
"BER(3));"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SELLITEM_DEL_INFO_LIST" TIMESTAMP '2006-10-12:16:06:26' OID '1"
"F9ABE52055A85BDE0407D0A3E4F5067' AS VARRAY(2000) OF SELLITEM_DEL_INFO;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SELLITEM_DEL_STATUS" TIMESTAMP '2006-10-12:16:06:26' OID '1F9A"
"BE52055E85BDE0407D0A3E4F5067' AS OBJECT"
"("
"PURCHASECODE VARCHAR2(20),"
"DESCRIPTION VARCHAR2(250)"
")"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SELLITEM_DEL_STATUS_LIST" TIMESTAMP '2006-10-12:16:06:26' OID "
"'1F9ABE52056385BDE0407D0A3E4F5067' AS VARRAY(20000) OF SELLITEM_DEL_STAT"
"US;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SUBSCRIPTIONDATA" TIMESTAMP '2006-10-12:16:06:26' OID '1F9ABE5"
"2056785BDE0407D0A3E4F5067' as object (no_of_subscriptions number,"
"purchasecode varchar2(25),name varchar2(800),dcoid number);"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SUBSCRIPTIONDATALIST" TIMESTAMP '2006-10-12:16:06:26' OID '1F9"
"ABE52056E85BDE0407D0A3E4F5067' as varray(100000) of subscriptiondata;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SUBSCRIPTIONINFO" TIMESTAMP '2006-10-12:16:06:26' OID '1F9ABE5"
"2057285BDE0407D0A3E4F5067' as object("
" purchase_code varchar2(25),"
" Dcoid number,"
" name varchar2(800),"
" subscriber_id varchar2(25),"
" terminal_id varchar2(32),"
" subscription_type varchar2(25),"
" subscription_start_date date,"
" subscription_end_date date,"
" last_Ro_delivery_date date,"
" next_ro_delivery_date date,"
" is_active number,"
" event_type varchar2(50),"
" reckon number,"
" cancel_key varchar2(100),"
" purchase_date date,"
" is_chargable varchar2(5),"
" is_cancelable varchar2(5),"
" validity_endDate date,"
" price number,"
" chargingIdentity varchar2(50)"
");"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SUBSCRIPTIONINFOLIST" TIMESTAMP '2006-10-12:16:06:26' OID '1F9"
"ABE52058985BDE0407D0A3E4F5067' as varray(100000) of subscriptioninfo;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "TERMINALOBJECT" TIMESTAMP '2006-10-12:16:06:26' OID '1F9ABE520"
"58D85BDE0407D0A3E4F5067' as object("
"Hash_Key Varchar2(256),"
"Terminal_Id varchar2(32),"
"Manufacturer varchar2(50),"
"KEY_TRANSPORT_ALGORITHM varchar2(1000),"
"certificate VARCHAR2(4000 CHAR),"
"model VARCHAR2(50 CHAR),"
"VERSION VARCHAR2(20 CHAR),"
"IS_BARRED NUMBER"
");"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "TERMINALLIST" TIMESTAMP '2006-10-12:16:06:26' OID '1F9ABE52059"
"885BDE0407D0A3E4F5067' as varray(10000) of TerminalObject;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "TRANSACTIONDATA" TIMESTAMP '2006-10-12:16:06:26' OID '1F9ABE52"
"059C85BDE0407D0A3E4F5067' as object ("
"subscriber_id varchar2(25),"
"TERMINAL_ID varchar2(256),"
"purchase_code varchar2(25),"
"price number(16,2),"
"currency varchar2(5),"
"creation_time date,"
"transaction_id varchar2(128),"
"Event_type varchar2(50),"
"Sub_Transaction_Id number,"
"sellable_item_name varchar2(150),"
"--TD#729"
"dco_id number,"
"purchase_code_version number,"
"success_status number,"
"charging_identity varchar2(50),"
"can_charge number,"
"is_charged number,"
"error_text varchar2(500),"
"payment_type varchar2(25),"
"instance_id varchar2(25)"
"--TD#729"
")"
";"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "TRANSACTIONDATALIST" TIMESTAMP '2006-10-12:16:06:26' OID '1F9A"
"BE5205B285BDE0407D0A3E4F5067' as varray(100000) of TRANSACTIONDATA;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "TRANSACTIONINFO" TIMESTAMP '2006-10-12:16:06:26' OID '1F9ABE52"
"05B685BDE0407D0A3E4F5067' AS OBJECT("
"TRANSACTION_ID VARCHAR2(128),"
"PURCHASE_CODE VARCHAR2(200),"
"SUBSCRIBER_ID VARCHAR2(25),"
"Hash_Key Varchar2(256),"
"TERMINAL_ID VARCHAR2(32),"
"REQUEST_CHANNEL VARCHAR2(25),"
"INSTANCE_ID VARCHAR2(20),"
"CREATION_TIME DATE,"
"COMPLETION_TIME DATE,"
"PRICE NUMBER,"
"CURRENCY VARCHAR2(5),"
"DELIVERY_STATUS NUMBER,"
"PREPAID_CHARGING NUMBER,"
"POSTPAID_CHARGING NUMBER,"
"PAYMENT_TYPE VARCHAR2(32),"
"USER_IP VARCHAR2(32),"
"PREPAID_RESERVATION_ID VARCHAR2(50)"
");"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "TRANSACTIONINFOLIST" TIMESTAMP '2006-10-12:16:06:26' OID '1F9A"
"BE5205CA85BDE0407D0A3E4F5067' is varray(10000) of transactioninfo;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "UPDPURCHASE_INFO" TIMESTAMP '2006-10-12:16:06:26' OID '1F9ABE5"
"205CE85BDE0407D0A3E4F5067' "
" as object"
"(PURCHASE_CODE VARCHAR2(20),"
" DCO_ID NUMBER,"
" Terminal_id VARCHAR2(256),"
" SUBSCRIBER_ID VARCHAR2(25),"
" status number,"
" reason_code number,"
" validity_end_date date);"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "UPDPURCHASE_LIST" TIMESTAMP '2006-10-12:16:06:26' OID '1F9ABE5"
"205D885BDE0407D0A3E4F5067' as varray(100000) of UpdPurchase_info;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "PURCHASE_TYPE" TIMESTAMP '2006-10-12:16:06:26' OID '1F9ABE5205"
"DC85BDE0407D0A3E4F5067' is object (DCOID number,"
" PURCHASECODE varchar2(32),"
" TERMINALID varchar2(32),"
" SUBSCRIBERID varchar2(32),"
" SUBSCRIPTIONTYPE varchar2("
"20),"
" SUBSCRIPTIONSTARTDATE date"
","
" SUBSCRIPTIONENDDATE date,"
" LASTRODELIVERYDATE date,"
" NEXTCHARGINGDATE date,"
" LASTTRIGGERDELIVERYDATE da"
"te,"
" ISACTIVE number,"
" EVENTTYPE varchar2(50),"
" ISPROCESSED number,"
" RECKON number,"
" SELLABLEITEMTYPE varchar2("
"50)"
" );"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "PURCHASE_LIST" TIMESTAMP '2006-10-12:16:06:26' OID '1F9ABE5205"
"EE85BDE0407D0A3E4F5067' as varray(10000) of purchase_type;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
. . importing table "ACCOUNT" 5 rows imported
. . importing table "ACCOUNT_TYPE" 3 rows imported
. . importing table "BUNDLE" 11 rows imported
. . importing table "EVENT_TYPE" 9 rows imported
. . importing table "LANGUAGE" 4 rows imported
. . importing table "PAYMENT_TYPE" 2 rows imported
. . importing table "PROGRAM" 2 rows imported
. . importing table "PURCHASE" 12 rows imported
. . importing table "RO_PARAMETERS" 0 rows imported
. . importing table "SCHEDULER_LOCK" 1 rows imported
. . importing table "SELLABLE_ITEM" 6 rows imported
. . importing table "SELLABLE_ITEM_NAME" 6 rows imported
. . importing table "SELLABLE_ITEM_TYPE" 2 rows imported
. . importing table "SUBSCRIBER" 20 rows imported
. . importing table "SUBSCRIPTION_TYPE" 3 rows imported
. . importing table "SYSTEM_PARAMETER" 45 rows imported
. . importing table "TERMINAL" 17 rows imported
. . importing table "TRANSACTION" 33 rows imported
IMP-00017: following statement failed with ORACLE error 1:
"BEGIN DBMS_JOB.ISUBMIT(JOB=>21,WHAT=>'ECS_MISC.CLEAN_UP;',NEXT_DATE=>TO_D"
"ATE('2006-10-13:16:06:29','YYYY-MM-DD:HH24:MI:SS'),INTERVAL=>'SYSDATE + 1',"
"NO_PARSE=>TRUE); END;"
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
ORA-06512: at "SYS.DBMS_JOB", line 97
ORA-06512: at line 1
Import terminated successfully with warnings.




Please guide me.

Report message to a moderator

Re: export and import [message #197911 is a reply to message #197900] Fri, 13 October 2006 04:40 Go to previous messageGo to next message
orausern
Messages: 826
Registered: December 2005
Senior Member
I think this error does not require to create a new user. for the statistics problem, what you can do is to export with
statistics=none and then import (in the same user, if this is a different environment, or in a new user as the case may be). After the import is over , gather the stats by dbms_stats.gather_schema_stats procedure. See if this way you still get the errors..

Report message to a moderator

Re: export and import [message #197929 is a reply to message #197900] Fri, 13 October 2006 05:31 Go to previous messageGo to next message
guru_karnam
Messages: 142
Registered: May 2005
Senior Member
I have A schema in one database .The schema has tables with data.The tables have constraints also.


I have B schema in another databse.tHIS has only metadata with constraints on tables and no data.I want to export from A and import to B .

i SHOULD GET DATA INTO B SCHEMA.iF DATA ALREADY EXISTS ,IT SHOULD ADD NEW ROWS WHICH ARE NOT IN B SCHEMA'S TABLES.

i should not get any errors.

Report message to a moderator

Re: export and import [message #197935 is a reply to message #197929] Fri, 13 October 2006 06:09 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you try to import with IGNORE=Y specified?

Report message to a moderator

Re: export and import [message #197939 is a reply to message #197929] Fri, 13 October 2006 06:21 Go to previous messageGo to next message
orausern
Messages: 826
Registered: December 2005
Senior Member
In this case, as you said that schema B has NO DATA, so try to import with ignore=y as Littlefoot suggested...i think that will do.

Report message to a moderator

Re: export and import [message #197943 is a reply to message #197900] Fri, 13 October 2006 06:37 Go to previous messageGo to next message
guru_karnam
Messages: 142
Registered: May 2005
Senior Member
Eventhough i used ignore=y it is giving errors

Report message to a moderator

Re: export and import [message #197944 is a reply to message #197900] Fri, 13 October 2006 06:39 Go to previous messageGo to next message
guru_karnam
Messages: 142
Registered: May 2005
Senior Member
eventhough no data it is giving constarint errors like parent key and child key errors

Report message to a moderator

Re: export and import [message #197945 is a reply to message #197943] Fri, 13 October 2006 06:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
All you have to do is, SEARCH THE FORUM BEFORE POSTING.
http://www.orafaq.com/forum/m/165975/42800/?srch=IMP-00017%3A+following+statement+failed+with+ORACLE+error+2304#msg_165975

Report message to a moderator

Re: export and import [message #197952 is a reply to message #197900] Fri, 13 October 2006 07:41 Go to previous messageGo to next message
guru_karnam
Messages: 142
Registered: May 2005
Senior Member
there is no solution in the forum

Report message to a moderator

Re: export and import [message #197954 is a reply to message #197952] Fri, 13 October 2006 07:42 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you even cared to read the above said posting?

Report message to a moderator

Previous Topic: Importing into a separted tablespace.didnot find complete solution
Next Topic: SQL*LOADER -941 Error and ORA-04043
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 23:59:47 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.