It is clear that the database prevents dropping (or replacing) a table which is already participating in a publication.

I don't know why the table name in the message is very odd. Example:

create or replace table mytest (sn int, des varchar(10));--OK
create publication mypub (table mytest);--OK

and then:

drop table mytest
-> Error Table mytest is participating in a publication --OK

create or replace table mytest (sn int, des varchar(10));

-> Error Table TESEYLEFJEYSOVB is participating in a publication --NOK, and every time I get a different table name

asked 09 Nov '22, 06:13

Baron's gravatar image

Baron
2.0k125138165
accept rate: 48%


Can't comment on the wrong table name in the error message...

But you usually will want to use ALTER TABLE here - take care that certain modifications are forbidden/discouraged within a SQL Remote setup, such as dropping/renaming columns or changing from NULL to NOT NULL when nulls might "be around" from outstanding messages.

permanent link

answered 09 Nov '22, 06:39

Volker%20Barth's gravatar image

Volker Barth
39.8k358546815
accept rate: 34%

converted 09 Nov '22, 06:42

both create table statements are identical, I dont want/need to change/alter the table structure.

I just wanted to drop the table and create it within the same statement.

(09 Nov '22, 06:45) Baron
Replies hidden
1

I just wanted to drop the table and create it within the same statement.

But why would you do that if the statements are identical? Certainly not in a running SQL Remote setup...

If this is meant to re-start a test setup, you might just drop the article from the publication before you re-create the table or drop and re-create the publication altogether.

Or start from scratch again - in my experience, a SQL Remote or MobiLink setup "has its history", so if you want to re-start, say after changing the publication design, it might be easier and less error-prone to start with a fresh publication and fresh remotes.

(09 Nov '22, 09:50) Volker Barth
1

Yes, it is meant to re-start a test setup, and Yes I do actually dropping the publication.

Just wanted to report the error.

(09 Nov '22, 10:07) Baron
2

Thank you for reporting this. I am working on a fix.

(09 Nov '22, 11:25) Chris Keating
3

This is fixed in Engineering Case# 827368 and will be in a future patch.

(30 Nov '22, 10:29) Chris Keating
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×4

question asked: 09 Nov '22, 06:13

question was seen: 268 times

last updated: 30 Nov '22, 10:29