Oracle ebusiness consultants and dbas

Search Site
About Think Forward
Contact Think Forward
Proactive Low Cost Database Support
Reactive Low Cost Database Pay Per Incident Support
Creative Solutions and Independent Advice from our expert consultants
Oracle High Availability Consultancy Services
Fast Forward Training
Professional Oracle Build Services
Revive your poorly database with an Oracle Health Checkup
Low Cost Oracle Development
Think Forward Home Page

Oracle Certified Professional

E-Mail Us and make cost savings on Oracle databases

info@think-forward.com

Oracle DBA Scripts and Tips

It has come to our attention that an Oracle Development company have copied our scripts without our permission and are using them as part of their own products for which they are charging users a license fee.

As a result of this, we have decided to suspend access to our DBA scripts until further notice and we regret the impact that this decision will inevitably have upon genuine users of the scripts repository.

We are continuing to monitor the situation and would encourage you to check back in the future for developments.

Script Home Object Management

Scripts sorted by Title



  1. Adjust Sequences ( Oracle : 7 8 8i 9i 10g )
    SQL Script : This script will drop and re-create sequences based upon the value of a sequence
    Updated: 04-AUG-98

  2. Count Partition Rows ( Oracle : 8i 9i 10g )
    SQL Script : Displays each individual table partition row counts. Also now lists the number
    Updated: 27-SEP-02

  3. Database Link Listing ( Oracle : 7 8 8i 9i 10g )
    SQL Script : This script lists all database link details, including the password of the remot
    Updated: 01-JUN-98

  4. Disable Foreign Keys ( Oracle : 8i 9i 10g )
    SQL Script : Disables all enabled.foreign keys for a given owner.
    Updated: 04-MAR-02

  5. Disable Foreign Keys ( Oracle : 7 8 )
    SQL Script : Disables all enabled foreign keys for a given owner.
    Updated: 03-AUG-98

  6. Dynamic Code Public Synonyms ( Oracle : 8i 9i 10g )
    SQL Script : This script creates public synonyms for all PACKAGES/PROCEDURES/FUNCTIONS owned
    Updated: 02-MAR-02

  7. Dynamic Code Public Synonyms ( Oracle : 7 8 )
    SQL Script : This script creates public synonyms for all PACKAGES/PROCEDURES/FUNCTIONS owned
    Updated: 30-MAR-00

  8. Dynamic Execute Granting ( Oracle : 7 8 )
    SQL Script : This script performs dynamic granting of PROCEDURES/FUNCTIONS/PACKAGES to users/
    Updated: 30-MAR-02

  9. Dynamic Execute Granting ( Oracle : 8i 9i 10g )
    SQL Script : This script performs dynamic granting of PROCEDURES/FUNCTIONS/PACKAGES to users/
    Updated: 03-MAR-02

  10. Dynamic Granting ( Oracle : 7 8 )
    SQL Script : This script performs dynamic granting of tables,views,sequences of the SELECT pr
    Updated: 17-JAN-99

  11. Dynamic Granting ( Oracle : 8i 9i 10g )
    SQL Script : This script performs dynamic granting of tables,views,sequences of the SELECT, I
    Updated: 05-MAR-02

  12. Dynamic Granting ( Oracle : 7 8 )
    SQL Script : This script performs dynamic granting of tables,views,sequences of the SELECT, I
    Updated: 17-JAN-99

  13. Dynamic Granting ( Oracle : 8i 9i 10g )
    SQL Script : This script performs dynamic granting of tables,views,sequences to users/roles/P
    Updated: 05-MAR-02

  14. Dynamic Granting ( Oracle : 7 8 )
    SQL Script : This script performs dynamic granting of tables,views,sequences to users/roles/P
    Updated: 17-JAN-99

  15. Dynamic Granting ( Oracle : 8i 9i 10g )
    SQL Script : This script performs dynamic granting of tables,views,sequences of the SELECT pr
    Updated: 05-MAR-02

  16. Dynamic Public Synonyms ( Oracle : 7 8 )
    SQL Script : This script creates public synonyms for all TABLES/VIEWS/SEQUENCES owned by a us
    Updated: 18-FEB-99

  17. Dynamic Public Synonyms ( Oracle : 8i 9i 10g )
    SQL Script : This script creates public synonyms for all TABLES/VIEWS/SEQUENCES owned by a us
    Updated: 05-MAR-02

  18. Enable Foreign Keys ( Oracle : 7 8 )
    SQL Script : Enables all disabled.foreign keys for a given owner. Check out the partner disab
    Updated: 04-AUG-98

  19. Enable Foreign Keys ( Oracle : 8i 9i 10g )
    SQL Script : Enables all disabled.foreign keys for a given owner. Check out the partner disab
    Updated: 01-MAR-02

  20. Indexes belonging to a table ( Oracle : 8i 9i 10g )
    SQL Script : This script lists index details for a given table and index owner. Everyone shou
    Updated: 04-MAR-02

  21. Indexes belonging to a table ( Oracle : 7 8 )
    SQL Script : This script lists index details for a given table and index owner. Everyone shou
    Updated: 01-JUN-98

  22. Object Dependencies ( Oracle : 8i 9i 10g )
    SQL Script : This script lists all dependent objects.
    Updated: 24-NOV-04

  23. Partition Details ( Oracle : 8 8i 9i 10g )
    SQL Script : This script lists details of table and index partitions.
    Updated: 28-FEB-01

  24. Rebuild Unusable Indexes ( Oracle : 8i 9i 10g )
    SQL Script : This script rebuilds unusable indexes.
    Updated: 24-NOV-04

  25. Table/System Privileges ( Oracle : 7 8 8i 9i 10g )
    SQL Script : This script all table and system privileges granted to a user. The scripts also
    Updated: 10-JUN-98

  26. Unindexed Foreign Key Listing ( Oracle : 7 8 8i 9i 10g )
    SQL Script : This script lists tables with foreign keys which are not indexed. Unindexed fore
    Updated: 11-FEB-04

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links