Dont Panic!

TimeHole.com

Oracle utilities

PreviousPage NextPage

Updated: 01 Sep 09

Main

What I do

Background

Customers

Contact Me

About Software

Personal

Some pages on Software
Databases & Linux

Operating Systems

Security

Databases

Database software

Some Oracle utils

Nice software


Some Old pages

SQL guide

PL/SQL guide

Jersey and Open Source

Linux File server

Linux Firewalls

Thin clients

Create Public synonym Script.

Everybody writes their own version of this script now and then. It reads the Oracle data dictionary to create synonyms for all objects for the current user. The script contains some comments and definitions to let you adopt it for different situations. This should be a trivial thing for anyone with basic knowledge about sqlplus and SQL.
To use it: Start and login to an Oracle database with SQLPlus,
Start the script with:
@@CreSyn

Create Grant to user Script.

This is another script that everybody writes. It reads the Oracle data dictionary to create grants to a user for all objects for the current user. This script also contains some comments and definitions to make it possible to change it for different purposes. It should be a trivial thing to change for anyone with some knowledge about sqlplus/SQL.
To use it: Start and login to an Oracle database with SQLPlus,
Start the script with:
@@CreGrant

Drop and Create Sequences Script.

Another script that creates two files. One to drop sequences and one to recreate them as they are right now. Edit the create file for specific values and you can use it for test purposes.
To use it: Start and login to an Oracle database with SQLPlus,
Start the script with:
@@DrpCreSeq

>> Page 1

Copyright(@)2003 www.Timehole.com.
You may use and redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or later.

I work with databases

images/ora_logo.gif
images/postgresql.jpg


And OpenSource Sw

images/gnu-head-sm.png images/sf_head.gif


I use fedora linux

For non-techies try:

Ubuntu or PcLinuxOs


Share information and knowledge!

images/180px-Green_and_white_machine.jpg

I'm based in Jersey, Available for assignments in all of Europe, On-Site or Remote. Call or mail me!

Jersey Information

Page: th_orautl Date:Sun Sep 5 9:26:51 EDT 2010

Copyright©2003-2009 Timehole.com All Rights Reserved.

Updated: Tue, 01 Sep 2009 06:11:55 -0400 Load time:0.02s