|
|
| Re: ORA-00922 Error While Importing a dump File [message #118419 is a reply to message #118412] |
Thu, 05 May 2005 02:01   |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Are you importing in an already existent table?
If yes, do check out the complete description of table to which data has to be imported. IS it in some way different from the descritpion of table from which the data was exported? If yes, then do rectify this first before importing.
Source:http://ora-00922.ora-code.com/
ORA-00922: missing or invalid option
Cause: An invalid option was specified in defining a column or storage clause. The valid option in specifying a column is NOT NULL to specify that the column cannot contain any NULL values. Only constraints may follow the datatype. Specifying a maximum length on a DATE or LONG datatype also causes this error.
Action: Correct the syntax. Remove the erroneous option or length specification from the column or storage specification
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
