Import oracle exp in the document, encountered this error message below:
?
IMP-00017: following statement failed with ORACLE error 907:
? "ALTER TABLE" user_ITEM "MODIFY (" AVAILABILITY "DEFAULT '+'"
IMP-00003: ORACLE error 907 encountered
ORA-00907: missing right parenthesis
?
?
The Internet to find, to see a friend itpub answer, in the time to thank and reproduced here, I would like to thank the author.
?
?
Original Address: http://www.itpub.net/700007, 1.html
?
TOAD is also available in the BUG


This situation also encountered some time ago that the bug is the oracle
Metalink on to find a half-day did not find
Today, finally found that the bug is the toad

alter table XXX add id number default 0
And
alter table XXX add (id number default 0)
The difference


Test:
1. Toad under the Executive
CREATE TABLE test_wx (NAME VARCHAR2 (20))

ALTER TABLE test_wx ADD ID NUMBER DEFAULT 0

2. And then export the table

C: \> exp aimsdev / aimsdevimp @ archivedb tables = (test_wx) file = c: \ test_wx.dmp

Export: Release 9.2.0.8.0 - Production on Thursday, January 4 15:42:11 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export done in ZHT16MSWIN950 character set and AL16UTF16 NCHAR character set
server uses UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
.. Exporting table TEST_WX 0 rows exported
Export terminated successfully without warnings.

3. Import another library
In order to simulate here, the library will drop out of this form
C: \> sqlplus / nolog

SQL * Plus: Release 9.2.0.8.0 - Production on Thursday, January 4 15:51:40 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn aimsdev / aimsdevimp
Connected.
SQL> drop table test_wx
?? 2;

Table dropped.

SQL>

4. Import
C: \> imp aimsdev / aimsdevimp @ archivedb file = c: \ test_wx.dmp full = y ignore = y;

Import: Release 9.2.0.8.0 - Production on Thursday, January 4 15:42:23 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


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

Export file created by EXPORT: V09.02.00 via conventional path
import done in ZHT16MSWIN950 character set and AL16UTF16 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
. Importing AIMSDEV's objects into AIMSDEV

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

Import terminated successfully with warnings.



Change

alter table XXX add (id number default 0)

Below is TOAD
CREATE TABLE test_wx (NAME VARCHAR2 (20))

ALTER TABLE test_wx ADD (ID NUMBER DEFAULT 0)

To the above steps
C: \> exp aimsdev / aimsdevimp @ archivedb tables = (test_wx) file = c: \ test_wx.dmp

Export: Release 9.2.0.8.0 - Production on Thursday, January 4 15:44:40 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export done in ZHT16MSWIN950 character set and AL16UTF16 NCHAR character set
server uses UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
.. Exporting table TEST_WX 0 rows exported
Export terminated successfully without warnings.

------------------------------ Here drop table test_wx

C: \> imp aimsdev / aimsdevimp @ archivedb file = c: \ test_wx.dmp full = y ignore = y;

Import: Release 9.2.0.8.0 - Production on Thursday, January 4 15:44:46 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


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

Export file created by EXPORT: V09.02.00 via conventional path
import done in ZHT16MSWIN950 character set and AL16UTF16 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
. Importing AIMSDEV's objects into AIMSDEV
.. Importing table "TEST_WX" 0 rows imported
Import terminated successfully without warnings.

In sqlplus under
alter table XXX add id number default 0
And
alter table XXX add (id number default 0)
There is no difference between the
Import time there will not be any problem


With UltraEdit-32 will be converted into two dmpfile. Txt will be found
alter table XXX add id number default 0时
The following statements

ALTER TABLE "TEST_WX" MODIFY DEFAULT. ALTER TABLE "TEST_WX" MODIFY ( "ID" DEFAULT 0)


alter table XXX add (id number default 0),
Into the following
ALTER TABLE "TEST_WX" MODIFY DEFAULT-ALTER TABLE "TEST_WX" MODIFY ( "ID" DEFAULT 0)

An inverted
It seems that sql or write norms ah