Drop system tables

From: Duncan Reed <der1004_at_cus.cam.ac.uk>
Date: 25 Aug 1998 16:30:41 GMT
Message-ID: <6ruorh$mun$1@pegasus.csx.cam.ac.uk>

I want to resize the system objauth$ table. The only way I can see of doing it is:

create a simialar table
insert data into it (part of the create table statement) rename objauth$ to objauth$_old (can't drop it yet, not allowed) rename new_table to objauth$
drop objauth$_old

This seems to work on a test system I knocked up. But this system only has me as a user, so I haven't done a huge amount of testing.

Is it safe to use this method?

Thanks,

Duncan

--

---

Database Administrator| Admin Computing Unit | University of Cambridge

Duncan Reed 	      |                      |       der1004_at_cam.ac.uk


----------------------------------------------------------------------

Received on Tue Aug 25 1998 - 11:30:41 CDT