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.
Action: Correct the syntax. Remove the erroneous option or length specification from the column or storage specification.
解决方案 »
- alter system flush buffer_cache 执行时消耗的时间为什么会越来越长
- 关于BUFFER SORT的问题
- oracle一体机连接问题 oralce11.2.0.3
- oracle存储过程中如何将SQL查询得到的结果集进行处理后返回给c#?
- 在oracle触发器中如何得到“当前”更新的行数据
- 在oracle中能否实现连个不同服务器间的数据交换??
- 看看这个存储过程怎么写?
- 看书看到数据库进程如database writer,LOG writer等,感觉晕晕的~~这个地方是了解就可以,还是属于可人工干预操控部分
- 谁用过oracle的oo4o code wizard?--救命啊
- 散分,从www.Oracle.com上下载的Oracle9i是不是免费的?
- Oracle的实例到底是什么?和DB2及SQL SERVER的实例概念相比呢?
- ORACLE 92 报错,请高手斧正!急急急
Action: Look up the Oracle message and take appropriate action. (To find information on the error number, click the Help Topics button in this window, click the Index tab, then type the error number, including its three-letter prefix with the hyphen.)
Action: Look up the accompanying Oracle message and take appropriate action. (To find information on the error number, click the Help Topics button in this window, click the Index tab, then type the error number, including its three-letter prefix with the hyphen.)
把这两个参数去掉之后就可以插入了。
问题是如何解决呢?我只有dmp文件,怎么才能去掉他们呢?
还有,能不能让dmp文件不创建表,而是直接导入数据呢?我试了自己建表然后imp这个dmp文件,但是不行,还是要建,还是报错。即使加了ignore=y的选项也一样。