oracle 错误码907,ora-907错误，如何解决，请高手指点！

From Metalink:

Problem Description

===================

Import fails with an ORA-00907 error.

ORA-00907: "missing right parenthesis"

Cause: A left parenthesis has been entered without a closing right

parenthesis, or extra information was contained in the

parentheses. All parentheses must be entered in paris.

Action: Correct the syntax and retry the statement.

Problem Explanation

===================

If the create table script includes "-- comments", the import of the table will

fail with an ORA-00907 error.

This problem is reproducible in version 7.1, 7.2, 7.3, and pre-8.0.4.

Example:

--------

1. create table TEST ( field1 varchar2(30) default 'TEST'

-- HALLO

-- Comment

,field2 varchar2(30) default 'TEST'

);

2. Export the table.

3. The import of the table will fail with an ORA-00907.

Search Words:

=============

comment comments export import

ORA-907

Solution Description:

=====================

Remove or modify the comments from CREATE TABLE scripts.

Solution Explanation:

=====================

After running the example script from the Problem Explanation, in the columns

data_default of table dbs_tab_columns, the following information is stored:

'TEST'    -- HALLO --COMMENT.

Inserting data doesn't cause any problems. But if you export the table, the

content of this row is exported. The import afterwards cannot create the table,

because the default value and the comment are now on the same line.  This means

characters after "--" are comment and not defined.

The following workarounds for the comments defined in CREATE TABLE will allow

successful export/import:

1. If the script is sligthly modified, moving the "," in front of comment

lines will allow the import to work correctly.  Comments are not stored.

create table TEST ( field1 varchar2(30) default 'TEST',

-- HALLO

-- Comment

field2 varchar2(30) default 'TEST'

);

- OR -

2.  Replace all -- comments with /* */ comments.  For example:

create table TEST ( field1 varchar2(30) default 'TEST'

/* HALLO */

/* Comment */

,field2 varchar2(30) default 'TEST'

);

Solution References:

====================

[BUG:334685]  COMMENTS ARE STORED IN DBA_TAB_COLUMNS.DATA_DEFAULT

Fixed In release 8.0.4.