Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Unanswered: Changing the Schema name

    We currently have database 1 setup with schema name aa, when we copy it back to database 2, it still has the same schema name, How can we change it, so database 2 would have a schema bb.


    This is on DB2 v8 Fixpak 3, Aix 5.2

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Changing the Schema name

    Not possible, AFAIK ...

    You will have to drop and re-create the objects ...

    Workaround is to define aliases for the objects ...

    Cheers
    Sathyaram

    Originally posted by quigleyd
    We currently have database 1 setup with schema name aa, when we copy it back to database 2, it still has the same schema name, How can we change it, so database 2 would have a schema bb.


    This is on DB2 v8 Fixpak 3, Aix 5.2
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •