There is a utility in the Developer Community to do this called archgid. A couple of things to remember is that just changing T34 to T1 will not change how ARS works with it as it will still be referenced in the ARSCHEMA table as T34 (as well as Fields, Active Links, Filters, ...). If you want to change the ID you should use the Remedy utility. The only thing it does not do (on Oracle systems) is to correct the Index names which you can do using the following SQL code.
SQL> Alter Index IT34 Rename to IT1;
SQL> Alter Index IH34 Rename to IH1;
SQL> Alter Index IB34 Rename to IB1;
If you change the Table ID you do want to correct the index names because if you go to create another table that is ID 34 you will get errors since the index names Remedy wants to use will already be in use.
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Jarl Groneng
Sent: Sunday, December 28, 2003 12:07 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: T1-T34..
Lars,
Having T34 as the User form table name should not have any impact. I know there was some earlier utility that assume that the table name sould be T1.
However, renaming a table in Oracle is not a big task(v8 and greater);
SQL> ALTER TABLE T34 RENAME TO T1;
Indexes and grants should not be affected, as Oracle automatically transfers these objects. Views can be corrupted, I have seen that several times. But this command fix that;
SQL> ALTER VIEW User COMPILE;
Regards,
Jarl
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@ARSLIST.ORG]On Behalf Of
> lars.j.pettersson@VATTENFALL.COM
> Sent: 28. desember 2003 18:37
> To: ARSLIST@ARSLIST.ORG
> Subject: T1-T34..
>
>
> Hi, after deleting/importing deffile for the Userform (to get some
> layoutchanges and so without having to remake the changes), I see that
> I now have T34 for User..everything is working fine (have not changed
> the formname..), is there any reason to worry about the change
> from ordinary
> T1...Maybee there is a way to change the Tnr as the tablename..??
> /5.1.2/Oracle 9i-2
>
> L ars
>
>
>
> UNSUBSCRIBE or access ARSList Archives at
> http://www.ARSLIST.org (Support: mailto:support@arslist.org )
> ARSList is hosted by QMX SUPPORT SERVICES at www.QMXS.com
>
Previous Topic
Index