Re: possible to initialise raw device ???

Alan Chen (sgs@technet.sg) wrote: : Hi guys, : I would like to re-organise my dbspaces, currently I have 10 dbspaces, : but some dbspaces have many chunks allocated after many data insertion : done. I would like to do dbexport, re-calculate the required chunk size, : and dbimport again. : I have no problem with dbexport & dbimport. : But, I would like to know is there any way to initialize my raw device : (means without dropping the tables, dropping dbspaces, dropping chunks, : all these steps), so that I will get back the brand new blank raw device : for me to re-allocate the chunks for my dbspaces. : Anyone know the quick way for this ??? If you want to restore EVERYTHING, you can reinitialize your rootdbs and start over from scratch. If not, why not just use DROP DATABASE and remove your dbspaces? Unless you have 100's of databases, it can't be that hard. (Heck, dropping is the *easy* part!) Also, why not use tbload/tbunload instead of dbimport/dbexport? It's more efficient and retains more information (e.g. lock mode, extent size, etc.)? -Jeff