Options

Dropping old DBD schemas

ohadmataohadmata
in General Discussion

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

  • Options
    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.

  • Options
    ohadmataohadmata

    it works, thanks!

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...