| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> ORA-00922 on create table...
Pat Gorden-Ozgul BNL-ISD Systems gorden_at_bnl.gov 631-344-5159
-----Original Message-----
[mailto:MAILER-DAEMON_at_ginger.caribdata.co.uk]
Sent: Thursday, March 08, 2001 11:42 AM
To: gorden_at_bnl.gov
Experts,
Solaris 2.6
RDBMS EE 8.1.5.0.0
I'll bet I'm doing something really stupid here.
Can anyone find my error?
I'm getting the following error on execution: create table catrec (
*
ERROR at line 1:
ORA-00922: missing or invalid option
huh?
create table catrec (
abstract VARCHAR2(3000),
add_dt VARCHAR2(32),
altti VARCHAR2(200),
au VARCHAR2(1504),
auth VARCHAR2(504),
au_sx VARCHAR2(32),
call VARCHAR2(56),
call_lc_sort VARCHAR2(56),
catno VARCHAR2(32),
check_in_note VARCHAR2(3000),
claim_mode VARCHAR2(32),
claim_mode_nm VARCHAR2(32),
claim_period_days VARCHAR2(32),
coden VARCHAR2(32),
coll VARCHAR2(504),
contents VARCHAR2(3000),
corp VARCHAR2(1504),
cpv VARCHAR2(32),
dauth VARCHAR2(232),
day_month VARCHAR2(32),
day_week VARCHAR2(32),
display_ti VARCHAR2(504),
disp_isbn_order VARCHAR2(56),
doc VARCHAR2(32),
dse3 VARCHAR2(32),
dse4 VARCHAR2(32),
dse5 VARCHAR2(32),
edtn VARCHAR2(232),
enum_type3 VARCHAR2(32),
enum_type4 VARCHAR2(32),
enum_type5 VARCHAR2(32),
exclude_dates VARCHAR2(32),
holdings VARCHAR2(1000),
include_dates VARCHAR2(32),
isbn VARCHAR2(56),
issn VARCHAR2(32),
issue_enum_type VARCHAR2(32),
key_numbers VARCHAR2(56),
kw VARCHAR2(56),
leader VARCHAR2(56),
level_ VARCHAR2(32),
m008 VARCHAR2(40),
m010 VARCHAR2(32),
m011 VARCHAR2(32),
m017 VARCHAR2(56),
m018 VARCHAR2(56),
m019 VARCHAR2(32),
m027 VARCHAR2(32),
m035 VARCHAR2(56),
m037 VARCHAR2(56),
m040 VARCHAR2(32),
m041 VARCHAR2(32),
m042 VARCHAR2(32),
m049 VARCHAR2(200),
m060 VARCHAR2(56),
m069 VARCHAR2(56),
m070 VARCHAR2(56),
m080 VARCHAR2(56),
m082 VARCHAR2(56),
m086 VARCHAR2(32),
m088 VARCHAR2(56),
m090 VARCHAR2(56),
m091 VARCHAR2(56),
m092 VARCHAR2(56),
m096 VARCHAR2(56),
m098 VARCHAR2(56),
m099 VARCHAR2(104)
m100_exp VARCHAR2(1504),
m110_exp VARCHAR2(1504),
m111 VARCHAR2(1504),
m111_exp VARCHAR2(1504),
m130 VARCHAR2(200),
m130_exp VARCHAR2(200),
m210 VARCHAR2(56),
m211 VARCHAR2(200),
m212 VARCHAR2(200),
m222 VARCHAR2(200),
m240 VARCHAR2(200),
m243 VARCHAR2(200),
m247 VARCHAR2(200),
m265 VARCHAR2(200),
m310 VARCHAR2(200),
m321 VARCHAR2(56),
m330 VARCHAR2(56),
m331 VARCHAR2(56),
m351 VARCHAR2(56),
m362 VARCHAR2(56),
m410 VARCHAR2(200),
m411 VARCHAR2(200),
m440 VARCHAR2(200),
m490 VARCHAR2(200),
m501 VARCHAR2(504),
m502 VARCHAR2(504),
m503 VARCHAR2(504),
m504 VARCHAR2(504),
m505 VARCHAR2(2000),
m506 VARCHAR2(504),
m512 VARCHAR2(504),
m513 VARCHAR2(504),
m515 VARCHAR2(504),
m520 VARCHAR2(504),
m521 VARCHAR2(504),
m522 VARCHAR2(504),
m523 VARCHAR2(504),
m524 VARCHAR2(504),
m525 VARCHAR2(504),
m527 VARCHAR2(504),
m530 VARCHAR2(504),
m533 VARCHAR2(504),
m534 VARCHAR2(504),
m536 VARCHAR2(504),
m537 VARCHAR2(504),
m538 VARCHAR2(504),
m540 VARCHAR2(504),
m541 VARCHAR2(504),
m544 VARCHAR2(504),
m545 VARCHAR2(504),
m546 VARCHAR2(504),
m547 VARCHAR2(504),
m550 VARCHAR2(504),
m555 VARCHAR2(504),
m556 VARCHAR2(504),
m561 VARCHAR2(504),
m562 VARCHAR2(504),
m565 VARCHAR2(504),
m567 VARCHAR2(504),
m570 VARCHAR2(504),
m580 VARCHAR2(504),
m590 VARCHAR2(504),
m599 VARCHAR2(504),
m600_exp VARCHAR2(1504),
m610 VARCHAR2(56),
m611 VARCHAR2(56),
m630 VARCHAR2(56),
m650 VARCHAR2(504),
m651 VARCHAR2(56),
m651_exp VARCHAR2(56),
m653 VARCHAR2(56),
m655 VARCHAR2(56),
m690 VARCHAR2(104),
m691 VARCHAR2(56),
m692 VARCHAR2(56),
m693 VARCHAR2(56),
m694 VARCHAR2(56),
m695 VARCHAR2(56),
m700 VARCHAR2(1504),
m710 VARCHAR2(1504),
m711 VARCHAR2(1504),
m730 VARCHAR2(104),
m740 VARCHAR2(104),
m752 VARCHAR2(200),
m760 VARCHAR2(104),
m762 VARCHAR2(104),
m765 VARCHAR2(104),
m767 VARCHAR2(104),
m770 VARCHAR2(104),
m772 VARCHAR2(504),
m775 VARCHAR2(200),
m776 VARCHAR2(200),
m777 VARCHAR2(104),
m780 VARCHAR2(104),
m785 VARCHAR2(104),
m787 VARCHAR2(504),
m800 VARCHAR2(504),
m810 VARCHAR2(104),
m811 VARCHAR2(104),
m830 VARCHAR2(104),
m840 VARCHAR2(104),
m856 VARCHAR2(1504),
m870 VARCHAR2(104),
m871 VARCHAR2(104),
m872 VARCHAR2(104),
m873 VARCHAR2(104),
m936 VARCHAR2(104),
medium VARCHAR2(32),
mtype VARCHAR2(32),
ne3 VARCHAR2(32),
ne4 VARCHAR2(32),
ne5 VARCHAR2(32),
niss VARCHAR2(32),
notes VARCHAR2(2000),
oclc VARCHAR2(32),
pred_cycle VARCHAR2(32),
pred_cycle_nm VARCHAR2(32),
pub VARCHAR2(1504),
ref VARCHAR2(504),
rev_dt VARCHAR2(32),
rev_uid VARCHAR2(32),
sec_cd VARCHAR2(32),
series VARCHAR2(1504),
ser_type VARCHAR2(32),
subj VARCHAR2(1504),
ti VARCHAR2(1504),
titles VARCHAR2(504),
vol_enum_type VARCHAR2(32),
week_month VARCHAR2(32),
week_year VARCHAR2(56),
year VARCHAR2(32)
Where's my error?
Pat Gorden-Ozgul BNL-ISD Systems gorden_at_bnl.gov 631-344-5159
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gorden-Ozgul, Patricia E
INET: gorden_at_bnl.gov
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Mar 08 2001 - 11:18:25 CST
 |
 |