Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. These files can then be u
Be the first to post a text review of Pretoria. Rate and review a project by clicking thumbs up or thumbs down in the right column.
/* 21 04-06-06 KVMB Bug in generating primary key constraint */ /* 'using index' (thanks to Ronald Rood) */
- implemented a pre-parser - added new features : default storage parameters are now possible (see manual)
/*********************************************************************/ /* */ /* MODIFICATION HISTORY : */ /* */ /* Issue Date Author Reason */ /* ===== ======== ====== ======================================== */ /* 1 24-01-01 KVMB I had the flu and nothing to do */ /* 2 19-05-01 KVMB put CONSTRAINT create statement in */ /* index create script (the constraint */ /* should use an existing index if possible)*/ /* 3 04-02-02 KVMB problem closing brace in storage clause */ /* when using LMT (thanks to Bob Blizard) */ /* 4 29-09-02 KVMB add a line-mode - all statements can be */ /* be printed on one line. This way you can */ /* use grep on the output files */ /* 5 11-09-02 KVMB problem with whitespaces in line-mode */ /* 6 28-05-03 KVMB 9iR2 - FOREIGN KEY & UNIQUE constraint */ /* in index create script */ /* 7 20-03-04 KVMB added extra output possibilities (-o1) */ /* new commandline parser */ /* 8 22-03-04 KVMB fixed bug with partition clause (issue3) */ /* remove extra line after partition key */ /* word */ /* 9 23-03-04 KVMB fixed bug in thread cancelation */ /* 10 23-03-04 KVMB bug fixed related to storage clause */ /* without INITIAL defined */ /* ex. STORAGE( NEXT ... ) */ /* (bug 9/10 thanks to Claudio Andenmatten) */ /* 11 23-03-04 KVMB added extra output possibilities (-o2) */ /* 12 08-04-04 KVMB bugfix - after solving issue 3 I intro- */ /* a new bug in formatting the columns */ /* 14 10-04-04 KVMB new switch : -ss strip storage clause as */ /* suggested by Ronald Rood */ /* 15 10-04-04 KVMB new switch : -nc no connect, does not */ /* generate CONNECT commands in output */ /* 16 14-04-04 KVMB Pretoria 2c adds owner to tablename in */ /* index ddl script : */ /* create index owner.index on table -> */ /* create index owner.index on owner.table */ /* 17 14-04-04 KVMB when CREATE TABLE contains inline CON- */ /* STRAINT definitions the ddl was created */ /* index or constraint ddl scripts */ /* (16/17 thanks to Ronald Rood) */ /* 18 14-04-04 KVMB add NOVALIDATE (-nv) switch */ /* 19 21-04-04 SDU Contemplando casos (INITIAL ... */ /* Implementacin DEFAULT_INDEX_STORAGE */ /* para casos de SYSTEM NAMED INDEXES */ /* ( ALTER TABLE ... USING INDEX ... */ /* 20 03-06-04 KVMB Add owner to referenced table in foreign */ /* key constraints */ /* */ /*********************************************************************/
Pretoria 2c released : - bugfixes - new features : -nc no connect -ss strip storage -nv no validate
Be the first person to add a text review.
Copyright © 2009 Geeknet, Inc. All rights reserved. Terms of Use
Thanks for your rating!
Would you also like to write a review?