Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    hyderabad
    Posts
    10

    Post Unanswered: make a tablespace offline

    hi all,

    Is there a way to make tablespace offline as like in oracle.
    then what is the syntax. I know u can do change from offline to online
    but how to place it offline is the question.


    thanx
    ramakrishna

  2. #2
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: make a tablespace offline

    Not sure of a commnad, but you could create a dummy table then do a dummy load into that would put the tablespace in an offline mode after its finished
    David Quigley

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: make a tablespace offline

    Originally posted by ramakrishna


    Is there a way to make tablespace offline as like in oracle.
    then what is the syntax. I know u can do change from offline to online
    but how to place it offline is the question.

    It depends on what you plan to do with that tablespace.

    Look at QUIESCE TABLESPACES FOR TABLE ... command.

  4. #4
    Join Date
    Mar 2004
    Location
    Germany
    Posts
    15
    what does offline mean ? That nobody can access or what do you mean ????

    Which Version and which OS do you use ?

Posting Permissions

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