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

Home -> Community -> Usenet -> c.d.o.server -> Re: catrep.sql syntax error ???

Re: catrep.sql syntax error ???

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/03/30
Message-ID: <38E35891.EB8@yahoo.com>#1/1

Igor V. Podolsky wrote:
>
> Hi all !
>
> I'm trying to create all objects needed fro replication. Documentation says
> 'run CATREP.SQL'. Fine, no problem. But I've got a couple of errors. One of
> them was occured while executing following statement (from CATREPC.SQL):
>
> /
> -- create a table that names the replicated objects
> CREATE TABLE system.repcat$_repobject
> (
> sname VARCHAR2(30), -- owner of replicated object
> oname VARCHAR2(30), -- replicated object name,
> type INTEGER
> CONSTRAINT repcat$_repobject_type
> CHECK (type IN (-1, 1, 2, 4, 5, 7, 8, 9, 11, 12, -3,
> -4)),
> --- type -4 (internal package) only exists in
> --- updatable snapshot sites
> CONSTRAINT repcat$_repobject_primary
> PRIMARY KEY(sname, oname, type),
> id NUMBER,
> object_comment VARCHAR2(80),
> status INTEGER
> -- this col is maintained independently at each replica
> CONSTRAINT repcat$_repobject_status
> CHECK (status IN (0, 1, 2, 3, 4, 5)),
> genpackage INTEGER
> -- this col is set and used at the master def site only
> CONSTRAINT repcat$_repobject_genpackage
> CHECK (genpackage IN (0, 1, 2)),
> genplogid INTEGER,
> gentrigger INTEGER
> -- this col is set and used at the master def site only
> CONSTRAINT repcat$_repobject_gentrigger
> CHECK (gentrigger IN (0, 1, 2)),
> gentlogid INTEGER,
> --- For generated objects objects (include $RP/$RL/
> --- repobject_type_internal_pkg) for snapshots at snapshot sites,
> --- the value of (gowner, gname) pairs will be NULL. This is because
> multiple
> --- snapshot may use the same generated object.
> --- Generated objects for procedural replications at snapshot sites
> --- will have the (gowner, gname) pair as its base objects.
> ---
> --- Note that repobject_type_internal_pkg only appears in
> repcat$_repobject
> --- in snapshot site, it is not recorded in repcat$_generated table.
> ---
> --- Generated objects can only be dropped when the last object using the
> --- generated object is dropped. The new relationship between REPOBJECT
> --- and GENERATED is many-to-many.
> gowner VARCHAR2(30), --- owner of object group
> gname VARCHAR2(30), --- replicated object group name
> CONSTRAINT repcat$_repobject_prnt
> FOREIGN KEY(gname, gowner)
> REFERENCES system.repcat$_repcat(sname, gowner)
> ON DELETE CASCADE,
> -- usage of flag:
> -- first bit in least significant byte for min_commmunication;
> -- second bit in least significant byte is used to remember whether
> -- generate_replication_support has been invoked;
> -- third bit in least significant byte to indicate the existence of
> -- internal pkgs;
> -- Note: if you ever change size of flag, please
> -- make corresponding changes in KNIPFLEN
> flag raw(4) default '00000000'
> )
> /
>
> The place of error is comment lines ending with ';' (unexpected end of SQL
> command, etc). Seems like SQL*Plus uses ';' as command separator (and it
> does). Sure, I could edit the file and remove all ';' , but what I'm doing
> wrong now ? I've perfomed all steps of procedure described in documentation.
> Oracle 8.1.5 EE for NT, if it's essential.
>
> BTW, SQL*Plus asks me "enter value for otype:" during script execution. What
> does it mean and what should I type ? There is silence in documentation
> again...
>
> --
> Is There A God Or Any Kind Of Justice Under The Sky... (Queen'91)
>
> Igor V. Podolsky (igoryok_at_i.am)
>
> P.S. Duplicate answers to igoryok_at_i.am please.

Run them in Server Manager not Sql Plus.

Otherwise, issue 'show all' and ensure that ';' and '&' are not used as special characters in SQL Plus.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse
Received on Thu Mar 30 2000 - 00:00:00 CST

Original text of this message

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