Syntax for dropping a dbspace with contents in it ?
Posted in 2004
Topics: Storage & Space Management
--0-86539278-1082136050=:19969 Content-Type: text/plain; charset=us-ascii Could someone provide me the syntax to drop a dbspace with contents in it ? Thanks for the help. --------------------------------- Do you Yahoo!? Yahoo! Tax Center - File online by April 15th --0-86539278-1082136050=:19969 Content-Type: text/html; charset=us-ascii <DIV>Could someone provide me the syntax to drop a dbspace with contents in it ?</DIV> <DIV> </DIV> <DIV>Thanks for the help.</DIV><p> <hr size=1><font face=arial size=-1>Do you Yahoo!?<br> Yahoo! Tax Center - <a href="http://taxes.yahoo.com/filing.html">File online by April 15th</a> --0-86539278-1082136050=:19969-- sending to informix-list
use oncheck to check what the contents of the dbspace are
delete the contents
remove the dbspace
anything esle will leave you instance in a horrendous mess as the
database will believe there is data in the dbspace that has been
removed
Mike Smith <idsquiz@yahoo.com> wrote in message news:<c5p5os$m1a$1@terabinaries.xmission.com>...
> --0-86539278-1082136050=:19969
> Content-Type: text/plain; charset=us-ascii
>
> Could someone provide me the syntax to drop a dbspace with contents in it ?
>
> Thanks for the help.
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Tax Center - File online by April 15th
> --0-86539278-1082136050=:19969
> Content-Type: text/html; charset=us-ascii
>
> <DIV>Could someone provide me the syntax to drop a dbspace with contents in it ?</DIV>
> <DIV> </DIV>
> <DIV>Thanks for the help.</DIV><p>
> <hr size=1><font face=arial size=-1>Do you Yahoo!?<br>
> Yahoo! Tax Center - <a href="http://taxes.yahoo.com/filing.html">File online by April 15th</a>
> --0-86539278-1082136050=:19969--
> sending to informix-list