Re: What happens when ?

Anjan Chakraborty wrote: > > Hello, Hello. > Suppose I have created a database "abc" on dbspace "def". Yes. > Later I created several dbspaces and created tables/indexes on those. Ok. > Now, somebody by mistake dropped dbspace "def", but all the other dbspaces > are fine. Oh boy! But this means they dropped the database 'abc' first because you can't drop a dbspace unless it is empty! > So, I can not open "abc". True. > At this situation, if I want to use "abc", > What should be done ? > Is any/all of the possibilities possible ? > 1. Restore from tape by "ontape -r -D abc" . > 2. Recreate the "abc" database on newly created dbspace "def". If you are using version 7.xx then 1. will do the trick. If you can re-create the database 'abc' then 2. will also work. > Thanks. > Sincerely, > Anjan That's ok. -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |Email: 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! | +------------------------+------------------------------------------------+