Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    37

    Unanswered: CREATE DB ... and TABLESPACE-Names

    hi all,

    is there any way to set the names of Tablesspaces (USER, CATALOG, TEMPORARY) when creating with "CREATE DATABASE ... " command?

    hmmmmmm ...


    or ist the "RENAME TABLESPACE xxx TO yyy" the only way?


    thank a lot

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

    Re: CREATE DB ... and TABLESPACE-Names

    AFAIK, RENAME is the only option ...

    Remember, you can be able to rename SYSCATSPACE

    HTH

    sathyaram

    Originally posted by bab
    hi all,

    is there any way to set the names of Tablesspaces (USER, CATALOG, TEMPORARY) when creating with "CREATE DATABASE ... " command?

    hmmmmmm ...


    or ist the "RENAME TABLESPACE xxx TO yyy" the only way?


    thank a lot
    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
  •