Database Software

Uses: Oracle 9i;

I regurlarly (via a schedule program) do import of dump created by production server to my test server, and have being doing it for some time.

Pls. note that both production server and test server all in all similar version.

Recently I'd amended few Table by adding Constraint Check and Default Value at the production and ever since I'm getting the error in the log file as:

IMP-00017: following statement failed with ORACLE error 907:
" ALTER TABLE "AGENT" MODIFY ("ALLOCATION" DEFAULT 0"
IMP-00003: ORACLE error 907 encountered
ORA-00907: missing right parenthesis
IMP-00017: following statement failed with ORACLE error 907:
" ALTER TABLE "AGENTEMAIL" MODIFY ("ISACTIVE" DEFAULT 0"
IMP-00003: ORACLE error 907 encountered
ORA-00907: missing right parenthesis

The result of this causes the Table and its associated objects not getting created at test server.

I would like to seek help from anybody to avoid this?

Line: -----

Below is the glimpse of the log file:


Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and UTF8 NCHAR character set
. importing JKSBSCHEMA's objects into JKSBSCHEMA
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "SA8I" TIMESTAMP '2011-10-13:21:55:27' OID '785BDF02EDADF23FE00"
"14BE92EAC00AE' "
" "
" as varray(10) of varchar2(10)"
""
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
. . importing table "ACCOUNT" 45501 rows imported
. . importing table "ACCOUNTLEDGER" 9422839 rows imported
. . importing table "ACCOUNTMANAGER" 129 rows imported
. . importing table "ACCOUNTMANAGERGROUP" 0 rows imported
. . importing table "ACCOUNTMANAGER_TEMP" 152 rows imported
. . importing table "ACCOUNTXSACTTYPE" 9 rows imported
IMP-00017: following statement failed with ORACLE error 907:
" ALTER TABLE "AGENT" MODIFY ("ALLOCATION" DEFAULT 0"
IMP-00003: ORACLE error 907 encountered
ORA-00907: missing right parenthesis
IMP-00017: following statement failed with ORACLE error 907:
" ALTER TABLE "AGENTEMAIL" MODIFY ("ISACTIVE" DEFAULT 0"
IMP-00003: ORACLE error 907 encountered
ORA-00907: missing right parenthesis
. . importing table "AMENDMENT" 27 rows imported
. . importing table "ANNOUNCEMENTS" 2951 rows imported
. . importing table "APP_BU" 7 rows imported
. . importing table "APP_MODULE" 273 rows imported
. . importing table "APP_MODULE_X" 31 rows imported
. . importing table "APP_PROFILE" 14 rows imported
. . importing table "APP_PROFILE_MODULE" 2860 rows imported
. . importing table "APP_PROFILE_MODULE_X" 66 rows imported
. . importing table "APP_USER" 43 rows imported
. . importing table "ATS_BROKER_ORDERS" 0 rows imported
. . importing table "AUTOPAYMENT" 24 rows imported
. . importing table "AUTOPAYMENT_X" 0 rows imported
. . importing table "AUTO_BANKREC" 31 rows imported
. . importing table "BANKACCOUNT" 12 rows imported
. . importing table "BENEFICIARY" 3 rows imported
. . importing table "BOUGHTNOTE" 171 rows imported
. . importing table "BO_RIGHTSISSUEPAYMENT" 145 rows imported
. . importing table "BO_RTGSPAYMENT" 1 rows imported
. . importing table "BO_RTGSPAYMENTACCOUNT" 1 rows imported
. . importing table "BROKERACCOUNT" 29 rows imported
. . importing table "BU" 0 rows imported
. . importing table "Bonus" 224 rows imported
. . importing table "CATEGORY1" 9 rows imported
. . importing table "CATEGORY2" 8 rows imported
. . importing table "CATE_1" 6 rows imported
. . importing table "CATE_2" 4 rows imported
. . importing table "CHEQUERETURN" 3566 rows imported
. . importing table "CHQRTREF" 19 rows imported
. . importing table "CLIENTACCOUNT" 45164 rows imported
. . importing table "CLIENTACCOUNTAGENT" 45186 rows imported
. . importing table "CLIENTACCOUNTAMENDMENT_TBL" 3654 rows imported
. . importing table "CLIENTACCOUNTCHANGELOG" 172507 rows imported
. . importing table "CLIENTACCOUNTEMAIL" 7944 rows imported
. . importing table "CLIENTACCOUNTEQUITY" 179371 rows imported
. . importing table "CLIENTACCOUNTEQUITYLEDGER" 1945467 rows imported
. . importing table "CLIENTACCOUNTEQUITY_X" 58287 rows imported
. . importing table "CLIENTACCOUNTOPENING" 6776 rows imported
. . importing table "CLIENTACCOUNTOPENING_ARCHIVE" 0 rows imported
. . importing table "CLIENTACCOUNTPAYINSTRUCT" 17 rows imported
. . importing table "CLIENTACCOUNT_TEMP" 43470 rows imported
. . importing table "CLIENTAMENDMENTS" 19751 rows imported
. . importing table "CLIENTBANK" 1572 rows imported
. . importing table "CLIENTBUYINGPOWER" 19318 rows imported
. . importing table "CLIENTGRADE" 7 rows imported
. . importing table "CLIENTLODGEMENT" 27239 rows imported
. . importing table "CLIENTLODGEMENT_TEMP" 20489 rows imported
. . importing table "CONTRACT" 1306352 rows imported
. . importing table "COUNTRY_ISO" 249 rows imported
. . importing table "COURIERCONTROL" 5 rows imported
. . importing table "COURIERTOWN" 30 rows imported
. . importing table "CUSTODIANACCOUNT" 31 rows imported
. . importing table "DIRECTFN_ALLOCATION_LIST" 1464 rows imported
. . importing table "DIRECTFN_TBL" 1349 rows imported
. . importing table "EMAIL" 0 rows imported
. . importing table "EMAIL9" 0 rows imported
. . importing table "EMAILCONFIG" 1 rows imported
. . importing table "EQUITY" 680 rows imported
. . importing table "EQUITYANNOUNCEMENTS" 4791 rows imported
. . importing table "EQUITYEARNINGS" 29 rows imported
. . importing table "EQUITYPRICE" 314 rows imported
. . importing table "EQUITYPRICES" 612345 rows imported
. . importing table "EQUITYTYPE" 8 rows imported
. . importing table "EQUITYXSACTTYPE" 4 rows imported
. . importing table "EVT_CARRIER_CONFIGURATION" 0 rows imported
. . importing table "EVT_DEST_PROFILE" 0 rows imported
. . importing table "EVT_HISTORY" 0 rows imported
. . importing table "EVT_INSTANCE" 0 rows imported
. . importing table "EVT_MAIL_CONFIGURATION" 0 rows imported
. . importing table "EVT_MONITOR_NODE" 0 rows imported
. . importing table "EVT_NOTIFY_STATUS" 0 rows imported
. . importing table "EVT_OPERATORS" 0 rows imported
. . importing table "EVT_OPERATORS_ADDITIONAL" 0 rows imported
. . importing table "EVT_OPERATORS_SYSTEMS" 0 rows imported
. . importing table "EVT_OUTSTANDING" 0 rows imported
. . importing table "EVT_PROFILE" 4 rows imported
. . importing table "EVT_PROFILE_EVENTS" 4 rows imported
. . importing table "EVT_REGISTRY" 2 rows imported
. . importing table "EVT_REGISTRY_BACKLOG" 0 rows imported
. . importing table "EW_USER" 0 rows imported
. . importing table "EXCEPTIONALACCOUNTS" 2 rows imported
. . importing table "FOREIGNBROKER" 5 rows imported
. . importing table "FOREIGNBROKEREMAIL" 9 rows imported
. . importing table "GENERALACCOUNT" 298 rows imported
. . importing table "HSBC" 607 rows imported
. . importing table "INTEREST" 125284 rows imported
. . importing table "INTRAACCOUNT" 3317 rows imported
. . importing table "INTRAACCOUNTEQUITY" 9922 rows imported
. . importing table "IPO" 24 rows imported
. . importing table "IPOACCOUNT" 5037 rows imported
. . importing table "IPOSEQ" 17 rows imported
. . importing table "JOURNAL" 25177 rows imported
. . importing table "JOURNALACCOUNT" 143892 rows imported
. . importing table "JOURNALACCOUNT_X" 0 rows imported
. . importing table "MODIFICATIONS" 0 rows imported
. . importing table "M_USER_MODULE" 3612 rows imported
. . importing table "M_USER_MODULE_METHOD" 0 rows imported
. . importing table "M_USER_ROLE" 0 rows imported
. . importing table "NOMINEE" 249 rows imported
. . importing table "ORDERLIST" 1059 rows imported
. . importing table "OTHER_CLIENTS"
Note: table contains ROWID column, values may be obsolete 1383 rows imported
. . importing table "OTS_USER" 1588 rows imported
. . importing table "OTS_USER_CDS_ACC" 1620 rows imported