Just ran across something interesting, when looking for workflow sql
 
Solution Details - TPI
Number 133528
Type TPI
Created Date 13-Jul-2006
Last Updated 13-Jul-2006
Title Converting Oracle Dictionary-Managed Tablespaces To Locally Managed Tablespaces For Improved Performance.
 
Details Description
Windchill 8 uses locally managed extents for better performance.
In previous releases, tablespaces were dictionary managed. When migrating from an older version
of Windchill to 8.0, you may wish to convert your tablespaces to use locally managed extents
for better performance.
 
Resolution
Check extent management of the tablespaces with following command (use the Oracle sys or system user):
 
SQL> SELECT tablespace_name,extent_management FROM dba_tablespaces;
 
Additional Information
Change dictionary managed tablespaces, except the SYSTEM tablespace, to locally managed with the following procedure:
 
SQL> execute DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL ('USERS');
 
The tablespace must be kept online and read/write during migration.
Note that temporary tablespaces cannot be migrated.
 
our query on hermione:
 
TABLESPACE_NAME|EXTENT_MANAGEMENT
SYSTEM|DICTIONARY
UNDOTBS|LOCAL
USERS|DICTIONARY
TEMP|DICTIONARY
TOOLS|DICTIONARY
INDX|DICTIONARY
BLOBS|DICTIONARY
 
Neutron is:
 
TABLESPACE_NAME|EXTENT_MANAGEMENT
SYSTEM|DICTIONARY
UNDOTBS|LOCAL
TEMP|LOCAL
BLOBS|LOCAL
INDX|LOCAL
TOOLS|LOCAL
USERS|LOCAL
WCAUDIT|LOCAL
 
You guys must have seen the TPI between hermione & neutron/ultralord
 
looks good
 
larry
 
 
-----Original Message-----
From: Darin Sensabaugh
Sent: Thursday, April 12, 2007 12:59 PM
To: Larry Jett; 'DATAJETT@aol.com'
Cc: Mike Ibosh
Subject: RE: Code looks good

Mike,
 
Will the .D suffix be ok when we strip extensions from file names?  If a cad doc is named 12345.d.drw, will it only drop the .drw?
 
Darin
-----Original Message-----
From: Larry Jett
Sent: Thursday, April 12, 2007 11:44 AM
To: Larry Jett; 'DATAJETT@aol.com'
Cc: Darin Sensabaugh; Mike Ibosh
Subject: RE: Code looks good

I just updated the code & it will now cover %.DRW files (epmdoc or wtpart).
 
It will rename with extension .D
 
After I check the models from the 13%.ASM, I can do 13%.PRT & try 13%.DRW
 
Then check models. Then maybe try DRW, ASM & .PRT for larger quantities.
 
I hope to have the whole hermione db done before you guys leave.
 
Here is the output of the test code output:
I ran 13%.DRW
====================
 
java lj_cust.ObjMan_03_tst04 -qb 13%.DRW>drw_rename_test_02.txt
 
Introspection Runtime Mode = true
EPMDoc - Number: 13001481.DRW - Name: BIPOD ASSEMBLY
Found %.DRW number: 13%.DRW & will be renamed to: 13001481.D
EPMDoc - Number: 13001482.DRW - Name: LEG, LEFT ASSEMBLY
Found %.DRW number: 13%.DRW & will be renamed to: 13001482.D
EPMDoc - Number: 13001483.DRW - Name: LEG, LOWER LEFT ASSEMBLY
Found %.DRW number: 13%.DRW & will be renamed to: 13001483.D
EPMDoc - Number: 13001484.DRW - Name: LEG, UPPER
Found %.DRW number: 13%.DRW & will be renamed to: 13001484.D
EPMDoc - Number: 13001485.DRW - Name: LEG, RIGHT ASSEMBLY
Found %.DRW number: 13%.DRW & will be renamed to: 13001485.D
EPMDoc - Number: 13001486.DRW - Name: LEG, LOWER RIGHT ASSEMBLY
Found %.DRW number: 13%.DRW & will be renamed to: 13001486.D
EPMDoc - Number: 13001487.DRW - Name: LEG, UPPER RIGHT ASSEMBLY
Found %.DRW number: 13%.DRW & will be renamed to: 13001487.D
EPMDoc - Number: 13001488.DRW - Name: LATCH
Found %.DRW number: 13%.DRW & will be renamed to: 13001488.D
EPMDoc - Number: 13001489.DRW - Name: SPRING, COMPRESSION
Found %.DRW number: 13%.DRW & will be renamed to: 13001489.D
EPMDoc - Number: 13001490.DRW - Name: HEAD, LEG
Found %.DRW number: 13%.DRW & will be renamed to: 13001490.D
EPMDoc - Number: 13001491.DRW - Name: LEG, UPPER LEFT ASSEMBLY
Found %.DRW number: 13%.DRW & will be renamed to: 13001491.D
EPMDoc - Number: 13001492.DRW - Name: DOWEL
Found %.DRW number: 13%.DRW & will be renamed to: 13001492.D
EPMDoc - Number: 13001493.DRW - Name: SPIKE
Found %.DRW number: 13%.DRW & will be renamed to: 13001493.D
EPMDoc - Number: 13001494.DRW - Name: DETENT
Found %.DRW number: 13%.DRW & will be renamed to: 13001494.D
EPMDoc - Number: 13001495.DRW - Name: CAP, DETENT
Found %.DRW number: 13%.DRW & will be renamed to: 13001495.D
EPMDoc - Number: 13001496.DRW - Name: SPRING, COMPRESSION
Found %.DRW number: 13%.DRW & will be renamed to: 13001496.D
EPMDoc - Number: 13001497.DRW - Name: TUBE, LOWER
Found %.DRW number: 13%.DRW & will be renamed to: 13001497.D
EPMDoc - Number: 13001498.DRW - Name: FOOT, RIGHT
Found %.DRW number: 13%.DRW & will be renamed to: 13001498.D
EPMDoc - Number: 13001499.DRW - Name: GUSSET
Found %.DRW number: 13%.DRW & will be renamed to: 13001499.D
EPMDoc - Number: 13001500.DRW - Name: HOUSING, LATCH
Found %.DRW number: 13%.DRW & will be renamed to: 13001500.D
EPMDoc - Number: 13001501.DRW - Name: FOOT, LEFT
Found %.DRW number: 13%.DRW & will be renamed to: 13001501.D
EPMDoc - Number: 13001502.DRW - Name: YOKE
Found %.DRW number: 13%.DRW & will be renamed to: 13001502.D
EPMDoc - Number: 13001504.DRW - Name: SCREW, SHOULDER
Found %.DRW number: 13%.DRW & will be renamed to: 13001504.D
EPMDoc - Number: 13001601AV.DRW - Name: 11826003.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13001601AV.D
EPMDoc - Number: 13002190.DRW - Name: 13002190.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002190.D
EPMDoc - Number: 13002191.DRW - Name: 13002191.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002191.D
EPMDoc - Number: 13002192.DRW - Name: 13002192.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002192.D
EPMDoc - Number: 13002193.DRW - Name: 13002193.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002193.D
EPMDoc - Number: 13002194.DRW - Name: 13002194.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002194.D
EPMDoc - Number: 13002195.DRW - Name: 13002195.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002195.D
EPMDoc - Number: 13002196.DRW - Name: 13002196.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002196.D
EPMDoc - Number: 13002197.DRW - Name: 13002197.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002197.D
EPMDoc - Number: 13002198.DRW - Name: 13002198.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002198.D
EPMDoc - Number: 13002199.DRW - Name: 13002199.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002199.D
EPMDoc - Number: 13002200.DRW - Name: 13002200.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002200.D
EPMDoc - Number: 13002201.DRW - Name: 13002201.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002201.D
EPMDoc - Number: 13002202.DRW - Name: 13002202.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002202.D
EPMDoc - Number: 13002203.DRW - Name: 13002203.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002203.D
EPMDoc - Number: 13002204.DRW - Name: 13002204.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002204.D
EPMDoc - Number: 13002205.DRW - Name: 13002205.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002205.D
EPMDoc - Number: 13002206.DRW - Name: 13002206.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002206.D
EPMDoc - Number: 13002207.DRW - Name: 13002207.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002207.D
EPMDoc - Number: 13002208.DRW - Name: 13002208.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002208.D
EPMDoc - Number: 13002209.DRW - Name: 13002209.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002209.D
EPMDoc - Number: 13002210.DRW - Name: 13002210.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002210.D
EPMDoc - Number: 13002211.DRW - Name: 13002211.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002211.D
EPMDoc - Number: 13002212.DRW - Name: 13002212.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13002212.D
EPMDoc - Number: 13010659.DRW - Name: SUPPORT, CRADLE, SOLID MOUNT
Found %.DRW number: 13%.DRW & will be renamed to: 13010659.D
EPMDoc - Number: 13010660.DRW - Name: SUPPORT, ARM, SOLID MOUNT
Found %.DRW number: 13%.DRW & will be renamed to: 13010660.D
EPMDoc - Number: 13010661.DRW - Name: BLOCK, SOLID MOUNT
Found %.DRW number: 13%.DRW & will be renamed to: 13010661.D
EPMDoc - Number: 13010662.DRW - Name: SUPPORT, CRADLE, SOLID MOUNT ASSEMBLY
Found %.DRW number: 13%.DRW & will be renamed to: 13010662.D
EPMDoc - Number: 13010663.DRW - Name: SOLID MOUNT ASSEMBLY, RH VERTICAL STOWAGE
Found %.DRW number: 13%.DRW & will be renamed to: 13010663.D
EPMDoc - Number: 13010664.DRW - Name: BRACKET, TRAVEL LOCK
Found %.DRW number: 13%.DRW & will be renamed to: 13010664.D
EPMDoc - Number: 13010665.DRW - Name: PIN, QUICK RELEASE, SOLID MOUNT
Found %.DRW number: 13%.DRW & will be renamed to: 13010665.D
EPMDoc - Number: 13010666.DRW - Name: BRASS/LINKS COLLECTOR ASSEMBLY
Found %.DRW number: 13%.DRW & will be renamed to: 13010666.D
EPMDoc - Number: 13010667.DRW - Name: CHUTE ASSEMBLY
Found %.DRW number: 13%.DRW & will be renamed to: 13010667.D
EPMDoc - Number: 13010668.DRW - Name: PLATE, BOTTOM, CHUTE
Found %.DRW number: 13%.DRW & will be renamed to: 13010668.D
EPMDoc - Number: 13010669.DRW - Name: PLATE, RIGHT SIDE, CHUTE
Found %.DRW number: 13%.DRW & will be renamed to: 13010669.D
EPMDoc - Number: 13010670.DRW - Name: PLATE, LEFT SIDE, CHUTE
Found %.DRW number: 13%.DRW & will be renamed to: 13010670.D
EPMDoc - Number: 13010671.DRW - Name: PLATE, COLLECTOR, SIDE
Found %.DRW number: 13%.DRW & will be renamed to: 13010671.D
EPMDoc - Number: 13010672.DRW - Name: BAG, AMMO CASE AND LINK CATCH
Found %.DRW number: 13%.DRW & will be renamed to: 13010672.D
EPMDoc - Number: 13010672MOD.DRW - Name: 13010672.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13010672MOD.D
EPMDoc - Number: 13010672MOD_1.DRW - Name: 13010672.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13010672MOD_1.D
EPMDoc - Number: 13010672NOFLAP.DRW - Name: 13010672.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13010672NOFLAP.D
EPMDoc - Number: 13010672NOFLAP_1.DRW - Name: 13010672.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13010672NOFLAP_1.D
EPMDoc - Number: 13010673.DRW - Name: PINTLE, RAMP
Found %.DRW number: 13%.DRW & will be renamed to: 13010673.D
EPMDoc - Number: 13010674.DRW - Name: PINTLE, LEFT WINDOW
Found %.DRW number: 13%.DRW & will be renamed to: 13010674.D
EPMDoc - Number: 13010675.DRW - Name: PINTLE, RIGHT DOOR
Found %.DRW number: 13%.DRW & will be renamed to: 13010675.D
EPMDoc - Number: 13010676.DRW - Name: PLATE, DEFLECTOR
Found %.DRW number: 13%.DRW & will be renamed to: 13010676.D
EPMDoc - Number: 13010677.DRW - Name: FOLLOWER, CAM, WINDOW/DOOR
Found %.DRW number: 13%.DRW & will be renamed to: 13010677.D
EPMDoc - Number: 13010678.DRW - Name: FOLLOWER, CAM, RAMP
Found %.DRW number: 13%.DRW & will be renamed to: 13010678.D
EPMDoc - Number: 13010679.DRW - Name: SOLID MOUNT ASSEMBLY, TAIL RAMP
Found %.DRW number: 13%.DRW & will be renamed to: 13010679.D
EPMDoc - Number: 13010680.DRW - Name: SOLID MOUNT ASSEMBLY, LEFT WINDOW
Found %.DRW number: 13%.DRW & will be renamed to: 13010680.D
EPMDoc - Number: 13010681.DRW - Name: SOLID MOUNT ASSEMBLY, RIGHT DOOR
Found %.DRW number: 13%.DRW & will be renamed to: 13010681.D
EPMDoc - Number: 13010682.DRW - Name: PLATE, FRONT
Found %.DRW number: 13%.DRW & will be renamed to: 13010682.D
EPMDoc - Number: 13010683.DRW - Name: PLATE, TOP, CHUTE
Found %.DRW number: 13%.DRW & will be renamed to: 13010683.D
EPMDoc - Number: 13010684.DRW - Name: PLATE, SUPPORT, CHUTE
Found %.DRW number: 13%.DRW & will be renamed to: 13010684.D
EPMDoc - Number: 13010685.DRW - Name: COVER, COLLECTOR, FRONT
Found %.DRW number: 13%.DRW & will be renamed to: 13010685.D
EPMDoc - Number: 13010686.DRW - Name: COVER, COLLECTOR, REAR
Found %.DRW number: 13%.DRW & will be renamed to: 13010686.D
EPMDoc - Number: 13011319.DRW - Name: 13011319.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13011319.D
EPMDoc - Number: 13011320.DRW - Name: 13011320.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13011320.D
EPMDoc - Number: 13011321.DRW - Name: 13011321.drw
Found %.DRW number: 13%.DRW & will be renamed to: 13011321.D
EPMDoc - Number: 13011476.DRW - Name: SOLID MOUNT ASSEMBLY, LH VERTICAL STOWAGE
Found %.DRW number: 13%.DRW & will be renamed to: 13011476.D
EPMDoc - Number: 13011477.DRW - Name: PIN, RETAINING
Found %.DRW number: 13%.DRW & will be renamed to: 13011477.D
EPMDoc - Number: 13011478.DRW - Name: REAR RETAINING PIN ASSEMBLY
Found %.DRW number: 13%.DRW & will be renamed to: 13011478.D
EPMDoc - Number: 13011479.DRW - Name: PLUNGER
Found %.DRW number: 13%.DRW & will be renamed to: 13011479.D
EPMDoc - Number: 13011480.DRW - Name: SPRING
Found %.DRW number: 13%.DRW & will be renamed to: 13011480.D
EPMDoc - Number: 13011481.DRW - Name: RING, SPLIT
Found %.DRW number: 13%.DRW & will be renamed to: 13011481.D
EPMDoc - Number: 13011482.DRW - Name: PIN, PIVOT, PINTLE
Found %.DRW number: 13%.DRW & will be renamed to: 13011482.D
EPMDoc - Number: 13011483.DRW - Name: UPPER MOUNT SUB-ASSEMBLY
Found %.DRW number: 13%.DRW & will be renamed to: 13011483.D
EPMDoc - Number: 13013732.DRW - Name: COCKING HANDLE ASSEMBLY, LT WT
Found %.DRW number: 13%.DRW & will be renamed to: 13013732.D
EPMDoc - Number: 13013733.DRW - Name: BODY, COCKING HANDLE, LT WT
Found %.DRW number: 13%.DRW & will be renamed to: 13013733.D
EPMDoc - Number: 13013734.DRW - Name: COVER FRAME W/ROLLERS, LT WT
Found %.DRW number: 13%.DRW & will be renamed to: 13013734.D
EPMDoc - Number: 13013735.DRW - Name: COVER, LIGHTWEIGHT
Found %.DRW number: 13%.DRW & will be renamed to: 13013735.D
EPMDoc - Number: 13013736.DRW - Name: FEED TRAY ASSEMBLY
Found %.DRW number: 13%.DRW & will be renamed to: 13013736.D
EPMDoc - Number: 13013737.DRW - Name: FEED TRAY
Found %.DRW number: 13%.DRW & will be renamed to: 13013737.D
EPMDoc - Number: 13013738.DRW - Name: BLOCK, PAWL
Found %.DRW number: 13%.DRW & will be renamed to: 13013738.D
EPMDoc - Number: 13013739.DRW - Name: PIN, PAWL
Found %.DRW number: 13%.DRW & will be renamed to: 13013739.D
EPMDoc - Number: 13013740.DRW - Name: SPRING, PAWL
Found %.DRW number: 13%.DRW & will be renamed to: 13013740.D
EPMDoc - Number: 13013741.DRW - Name: PAWL, FEED
Found %.DRW number: 13%.DRW & will be renamed to: 13013741.D
EPMDoc - Number: 13013742.DRW - Name: E-CLIP, PAWL
Found %.DRW number: 13%.DRW & will be renamed to: 13013742.D
EPMDoc - Number: 13013743.DRW - Name: FEED TRAY, WELDMENT ASSEMBLY
Found %.DRW number: 13%.DRW & will be renamed to: 13013743.D
EPMDoc - Number: 13013744.DRW - Name: SUPPORT, GAS CYLINDER, LIGHT WEIGHT
Found %.DRW number: 13%.DRW & will be renamed to: 13013744.D
EPMDoc - Number: 13015462.DRW - Name: LEVER, FEED, LMG
Found %.DRW number: 13%.DRW & will be renamed to: 13015462.D
-----Original Message-----
From: Larry Jett
Sent: Wednesday, April 11, 2007 9:02 AM
To: 'DATAJETT@aol.com'; Larry Jett
Cc: Darin Sensabaugh; Mike Ibosh
Subject: RE: Code looks good

I added a lot of code to the program last night.
 
Mainly to set up argument entry & checking.
 
Its working for wtparts, but not for epmdocs.
 
So I have to look over the code & recompile & test.
 
It will query & rename right, but its not finding the epmdocs to change.
 
Right now, its only doing queries or rename tests on my text files (ren_10_ljett*).
 
I guess thats what I get for trying to make it user friendly & robust (query & rename of pemdocs & wtparts,
all in one. But thats the way it should be writtien. dont want 4 programs to have to update constantly &/or run
when its live.
 
It should be ready shortly. I will email you when it works.
 
Thanks
Larry
-----Original Message-----
From: DATAJETT@aol.com [mailto:DATAJETT@aol.com]
Sent: Wednesday, April 11, 2007 12:49 AM
To: Larry Jett
Cc: Darin Sensabaugh; Mike Ibosh
Subject: Code looks good

Code is complete & runs good at home.
 
I named it ObjMan = Object Manipulate. wanted ObjUtil (utility), but there are already wt folders
with that name.
 
I even tested it for errors. I purposely made a .ASM & .PRT with same wtpart number (diff before rename).
 
Here is the error (very descriptive):
 
D:\wt\Windchill_8.0\codebase\lj_cust>java lj_cust.ObjMan_01 -rb %.ASM
Introspection Runtime Mode = true
WtPart - Number: LJETT_LIST_INFO2.ASM & WtPart - Name: ljett_list_info2.asm
wt.pom.UniquenessException: Cannot change identity of object
"Part.LJETT_LIST_INFO2.ASM - ljett_list_info2.asm" to "LJETT_LIST_INFO2"
because new identity is not unique.
        at wt.method.RemoteMethodServer.invoke(RemoteMethodServer.java:766)
        at wt.fc.IdentityServiceFwd.changeIdentity(IdentityServiceFwd.java:96)
        at lj_cust.ObjMan_01.FindWtpNumbered(ObjMan_01.java:60)
        at lj_cust.ObjMan_01.main(ObjMan_01.java:126)
 
Here is the Usage print out for args explanation:
 
===============
 
D:\wt\Windchill_8.0\codebase\lj_cust>java lj_cust.ObjMan_01
Usage: java/windchill lj_cust.ObjMan -<query/rename> %.<query/rename string>
1st Argument = <query/rename>:
 
-qw = query wtparts only
-qe = query epmdocs only
-qb = query both (wtparts & epmdocs)
 
-rw = rename wtparts only (query 1st)
-re = rename epmdocs only (query 1st)
-rb = rename both (wtparts & epmdocs) (query 1st)
 
2nd Argument = %.<query/rename string>
 
Should include % & . where % = * = wild card.
Typical = %.PRT or %.ASM
 
================
 
Let me know if it could print something more descriptive.
 
Otherwise, I will test a few queries as soon as I get in, then we can all watch while we try live.
 
We can do wtpart query, then live wtpart rename for %.ASM 1st, since there are 7000 prt's & only
1300 asm's.
 
Fingers crossed.
 
Larry



See what's free at AOL.com.