Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: user defined default tablespace

    Is there anyway so we can create a tablesspace so all objects ( i.e. table/index ) by default created in that tablespace instead of IBM defined tablespace ?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    If you are creating objects as instance owner or a user with dbadm, then,afaik, you'll have to explicitly specify the tablespace name or else drop the userspace1 ...

    If it is any other user, then reovke use of tablespace userspace1 from that user and grant use of tablespace to the new tablespace you have created ...

    HTH

    Sathyaram
    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
  •