Re: Drop db spaces in 7.13

Klaus Schnurr wrote: > > Recently, we have upgraded our application from Informix 5.0 to 7.13. In > 5.0 we were able to drop db spaces without dropping the database; > however this does not work under 7.13. > > <SNIP> > instance. May be anyone knows a different solution for this instead of > unloading the db spaces seperately. I may be missing the point here, but how do you unload a dbspace? Have you used dbexport and dbimport? These will export ans import an entire database regardless of the dbspaces involved. Use the -ss option to retain the dbspace names, though it sounds as though these differ on your two systems. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+