Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-00922 on create table... (private)

RE: ORA-00922 on create table... (private)

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Thu, 08 Mar 2001 11:11:48 -0800
Message-ID: <F001.002C77C4.20010308110852@fatcity.com>

oopss... that one wasn't supposed to go to the list. Caffeine levels below optimum threshold.....

my apologies to the list

>From: "Rachel Carmichael" <carmichr_at_hotmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: ORA-00922 on create table... (private)
>Date: Thu, 08 Mar 2001 10:37:39 -0800
>
>He POSTS! <giggling>
>
>I take it you weren't on the installation trip.
>
>How was Nobu? Worth adding to my "some day for a special occasion" list?
>
>Rachel
>
>>From: Scott Crabtree <scott_at_psscorp.com>
>>Reply-To: ORACLE-L_at_fatcity.com
>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>Subject: RE: ORA-00922 on create table...
>>Date: Thu, 08 Mar 2001 09:05:37 -0800
>>
>>Missing a , at m099 VARCHAR2(104)
>>
>>HTH,
>> Scott Crabtree
>>
>>-----Original Message-----
>>Sent: Thursday, March 08, 2001 11:48 AM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>
>>
>>__________________________________________________
>>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)
>>)
>>/
>>commit;
>>
>>
>>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).
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Scott Crabtree
>> INET: scott_at_psscorp.com
>>
>>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).
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
>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).



Get your FREE download of MSN Explorer at http://explorer.msn.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: carmichr_at_hotmail.com

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 - 13:11:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US