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


http://pretoria.sourceforge.net





Separate each tag with a space.

Release Date:

2008-04-28

Topics:

License:

Ratings and Reviews

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.

Project Feed

  • pretoria Pretoria 3c file released: Pretoria3c.zip

    posted 561 days ago

  • File released: /pretoria/Pretoria 3c/Pretoria3c.zip

    posted 561 days ago

  • pretoria Pretoria 3b file released: Pretoria3b.zip

    /* 21 04-06-06 KVMB Bug in generating primary key constraint */ /* 'using index' (thanks to Ronald Rood) */

    posted 1224 days ago

  • File released: /pretoria/Pretoria 3b/Pretoria3b.zip

    posted 1224 days ago

  • Pretoria 3c released

    - implemented a pre-parser - added new features : default storage parameters are now possible (see manual)

    posted by kurtvm 1969 days ago

  • File released: /pretoria/Pretoria 3a/Pretoria3a.zip

    posted 1969 days ago

  • pretoria Pretoria 3a file released: Pretoria3a.zip

    /*********************************************************************/ /* */ /* 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 */ /* */ /*********************************************************************/

    posted 1969 days ago

  • Pretoria 2c

    Pretoria 2c released : - bugfixes - new features : -nc no connect -ss strip storage -nv no validate

    posted by kurtvm 2035 days ago

  • File released: /pretoria/Pretoria 2c/Pretoria.java

    posted 2035 days ago

  • pretoria Pretoria 2c file released: Pretoria.java

    posted 2035 days ago

Rate and Review

Be the first person to add a text review.

Would you recommend this project?






<

Related Projects

Pretoria Actions

Thanks for your rating!

Would you also like to write a review?





Skip Review