Re: [Info-ingres] Replicator and E_US0845
- From: Paul Mason <latepaul@xxxxxxxxx>
- Date: Tue, 15 Nov 2005 14:46:40 +0000
On 11/15/05, martin.bowes@xxxxxxxxxxxxx <martin.bowes@xxxxxxxxxxxxx> wrote:
> Hi Everyone,
>
> In between gene-splicing a Sheep and an Octupus....
>
> Here's a cute new feature...
>
> Having added the replicator catalogs and support objects to a database
> my routine maintenance scripts have gone belly up. It seems that the
> dba for the owner of the database (for whom the repcat was run)
> doesn't own the tables...
>
> An attempt to modify or optimize an archive table fails with:
> E_US0845 Table 'change_rea00001arc' does not exist or is not owned
> by you.
> Note that I am connecting as the owner of this table.
>
> While its probably not a good idea to modify or optimize these tables,
> nonetheless, I cant see for the life of me why its having problems doing
> this.
>
> I've run the optimize with II_EMBED_SET to print the trace file and it
> appears to barf on:
> execute immediate set lockmode on "change_rea00001arc" where
> readlock = nolock
>
> I can connect to the database and do a help\g and see that the table
> does exist and is owned by the database owner.
>
> However, an attempt to do a help table change_rea00001arc\g fails
> with the E_US0845.
>
> ditto a select or set lockmode on the table.
>
> Yet if I connect with a copydb I can generate the copy out command.
> But it fails to execute, generating the E_US0845 error.
>
> Anyone seen this before?
Sounds similar to bug 114330, INGSRV 3260 where the modify fails with
E_US0845 even though the table exists. Does it work if you try the
modify a second time?
--
Paul Mason
.
- Prev by Date: Re: [Info-ingres] Replicator and E_US0845
- Next by Date: Re: [Info-ingres] Replicator and E_US0845
- Previous by thread: Re: [Info-ingres] Replicator and E_US0845
- Next by thread: Re: [Info-ingres] Replicator and E_US0845
- Index(es):
Relevant Pages
|
