Dont Panic!

Some utilities

PreviousPage NextPage

Updated: 19 Feb 16

Main

Contact Me

Software

Free Script and utilities

Table API generator

Data Unload

Grants,Synonyms,Sequences

PHP Utils

Old SQL guide

Old PL/SQL guide

A Jersey Linux User Group?

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.
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.
To use it: Start and login to an Oracle database with SQLPlus,
Start the script with:
@@CreGrant

Drop and Create Sequences Script.

A 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

Code is released under the terms of the GNU General Public License as published by the Free Software Foundation.

Nice things

images/ora_logo.gif
images/mysql_100x52.gif


And OpenSource Sw

images/opensource-110x95.png images/linuxorg.gif


I use fedora linux

try it or 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