We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Dropping old DBD schemas — Vertica Forum

Dropping old DBD schemas

Hi
I am trying to drop old V_DBD schemas, this is my exception:

SELECT DESIGNER_DROP_DESIGN ('ctx_EncodingDesign');

Result:
[Code: 4983, SQL State: VD001] [Vertica][VJDBC](4983) ERROR: There is no design tables system table in workspace ctx_EncodingDesign

Any ideas what is the problem?

THX

Comments

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    Hi,

    See if you can drop the work space:

    select dbd_drop_workspace('ctx_EncodingDesign');

    Then try dropping the design again and it should report that it does not exist.

  • it works, thanks!

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file