lukestipsandtricks.blogspot.com

Luke's Tips and Tricks

Luke's Tips and Tricks. Wednesday, November 2, 2011. Here is an easy shell script wrapper to easily run an SQL script. D $BaseDir ] then print -u2 "ERROR - Unable to find directory $BaseDir" exit 1 fi if [! D $LogDir ] then $MKDIR $LogDir if [ $? Ne 0 ] then print -u2 "ERROR - Unable to create directory $LogDir" exit 1 fi fi if [! F $SQLFile ] then print -u2 "ERROR - Unable to find file $SQLFile" exit 1 fi cd $LogDir if [ $PWD! You name the script with the same name as the SQL script you wish to run.

http://lukestipsandtricks.blogspot.com/

OVERVIEW OF lukestipsandtricks.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR LUKESTIPSANDTRICKS.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

September

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Monday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.7 out of 5 with 11 reviews

5 star

4

4 star

4

3 star

1

2 star

0

1 star

2

Hey there! Start your review of lukestipsandtricks.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.5 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT LUKESTIPSANDTRICKS.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

0

SITE IP

172.217.12.193

LOAD TIME

0.545 sec

SCORE

6.2

PAGE TITLE

Luke's Tips and Tricks | lukestipsandtricks.blogspot.com Reviews

<META> DESCRIPTION

Luke's Tips and Tricks. Wednesday, November 2, 2011. Here is an easy shell script wrapper to easily run an SQL script. D $BaseDir ] then print -u2 ERROR - Unable to find directory $BaseDir exit 1 fi if [! D $LogDir ] then $MKDIR $LogDir if [ $? Ne 0 ] then print -u2 ERROR - Unable to create directory $LogDir exit 1 fi fi if [! F $SQLFile ] then print -u2 ERROR - Unable to find file $SQLFile exit 1 fi cd $LogDir if [ $PWD! You name the script with the same name as the SQL script you wish to run.

<META> KEYWORDS

1 shell script wrapper

2 purge stats sql

3 purge stats sh

4 some usage notes

5 oracle sid env

6 posted by luke

7 0 comments

8 email this

9 blogthis

10 share to twitter

CONTENT

Page content here

KEYWORDS ON PAGE

shell script wrapper,purge stats sql,purge stats sh,some usage notes,oracle sid env,posted by luke,0 comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,labels ksh,oracle,shell,unix,bind variable capture,1 comments,get obj

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Luke's Tips and Tricks | lukestipsandtricks.blogspot.com Reviews

https://lukestipsandtricks.blogspot.com

Luke's Tips and Tricks. Wednesday, November 2, 2011. Here is an easy shell script wrapper to easily run an SQL script. D $BaseDir ] then print -u2 "ERROR - Unable to find directory $BaseDir" exit 1 fi if [! D $LogDir ] then $MKDIR $LogDir if [ $? Ne 0 ] then print -u2 "ERROR - Unable to create directory $LogDir" exit 1 fi fi if [! F $SQLFile ] then print -u2 "ERROR - Unable to find file $SQLFile" exit 1 fi cd $LogDir if [ $PWD! You name the script with the same name as the SQL script you wish to run.

INTERNAL PAGES

lukestipsandtricks.blogspot.com

1

Luke's Tips and Tricks: March 2010

http://lukestipsandtricks.blogspot.com/2010_03_01_archive.html

Luke's Tips and Tricks. Wednesday, March 31, 2010. To find out which events you have set in your 10g oracle database use the following from SQL*Plus when connected as sysdba. Oradebug setmypid oradebug dump events 4. Find the trace file in the user dump destination and it will contain something like this. Here we have set event 10298 at level 32 like so. Alter system set events '10298 trace name context forever, level 32';. To do the same in 11g use the following. Subscribe to: Posts (Atom).

2

Luke's Tips and Tricks: April 2010

http://lukestipsandtricks.blogspot.com/2010_04_01_archive.html

Luke's Tips and Tricks. Wednesday, April 28, 2010. Detect Unindexed Foreign Keys. Unindexed foreign keys continue to be a prime performance bottleneck. Here is a script that will run through the foreign keys in a schema and display them all and the index that is associated with them (or not) and indicate whether the foreign key requires an index. You will need quite a wide screen to incorporate all the data. I use 140 character width. How to disable the DBMS SCHEDULER. To turn the scheduler off use.

3

Luke's Tips and Tricks: Shell script wrapper

http://lukestipsandtricks.blogspot.com/2011/11/shell-script-wrapper.html

Luke's Tips and Tricks. Wednesday, November 2, 2011. Here is an easy shell script wrapper to easily run an SQL script. D $BaseDir ] then print -u2 "ERROR - Unable to find directory $BaseDir" exit 1 fi if [! D $LogDir ] then $MKDIR $LogDir if [ $? Ne 0 ] then print -u2 "ERROR - Unable to create directory $LogDir" exit 1 fi fi if [! F $SQLFile ] then print -u2 "ERROR - Unable to find file $SQLFile" exit 1 fi cd $LogDir if [ $PWD! You name the script with the same name as the SQL script you wish to run.

4

Luke's Tips and Tricks: November 2011

http://lukestipsandtricks.blogspot.com/2011_11_01_archive.html

Luke's Tips and Tricks. Wednesday, November 2, 2011. Here is an easy shell script wrapper to easily run an SQL script. D $BaseDir ] then print -u2 "ERROR - Unable to find directory $BaseDir" exit 1 fi if [! D $LogDir ] then $MKDIR $LogDir if [ $? Ne 0 ] then print -u2 "ERROR - Unable to create directory $LogDir" exit 1 fi fi if [! F $SQLFile ] then print -u2 "ERROR - Unable to find file $SQLFile" exit 1 fi cd $LogDir if [ $PWD! You name the script with the same name as the SQL script you wish to run.

5

Luke's Tips and Tricks: Creating Object DDL

http://lukestipsandtricks.blogspot.com/2010/04/creating-object-ddl.html

Luke's Tips and Tricks. Wednesday, April 28, 2010. Here is some handy code to create object DDL using DBMS METADATA. There are 2 scripts, I shall call them the calling script and the running script. The calling script (which I called get obj.sql) is as follows. This script as you can see on line 72 calls the running script called get ddl.sql. Here is get ddl.sql. Set lines 32767 set pages 0 set head off set feed off set trims on set verify off set term off set long 5000000 col text for a32767!

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

OTHER SITES

lukesthebest.blogspot.com

lukes the best and fr2 tracks, maps, codes

Friday, May 15, 2009. Tuesday, February 17, 2009. Sunday, February 1, 2009. Wednesday, January 28, 2009. 100 lots of tracks. Tuesday, December 23, 2008. Not done yet but good at the end. Thursday, December 18, 2008. Thursday, December 4, 2008. Emu creek really really good.

lukesthoughtdump.blogspot.com

Luke's Thought Dump

Computer programming. Strength training. Food. Friday, March 9, 2018. NES Emulator, Part 1: I have no idea what I'm doing. For a very long time I've wanted to have a go at writing an emulator, and for one reason or another I never did it, but a few weeks ago I decided to pull the trigger and start writing a NES emulator. And I've chosen to write it in Rust, as I have a goal this year to achieve a moderate-to-high level of competency in the language. At this point in time, I'm still implementing instructi...

lukesthoughts.wordpress.com

Random Trails Of Thought | What Should I Be Thinking?

Random Trails Of Thought. It’s Almost Time…. Some of you may be aware that I am running the Lincoln 10k. Race on Sunday, those of you who do know me will think this idea is ludicrous. I am 19 years old and I both smoke and drink, thus not being your ideal choice for what is essentially an endurance race. Nonetheless I am giving it a go. Living in Lincoln for my entire life (oh dear) it’s always been something I felt I should be involved with…and now I am! March 24, 2009 at 11:45 pm. Starring the Brit cul...

lukestiller.com

Luke Stiller

Stick This In Your Ear. In Season with Phipps Conservatory. Welcome to my Portfolio! I am a Multimedia Designer who shines when I'm behind a camera (Videography). Or a computer screen (Video/Audio Editing). I specialize in Adobe After Effects, Premiere, and Photoshop. In my spare time, I like to go shoot Photography. Feel free to check out my work or my Resume. Stick This In Your Ear (Kinetic Typography). Motion Graphics, Typography, Design. Motion Graphics, Videography, 3D Animation. Shifted the balance...

lukestipsandtricks.blogspot.com

Luke's Tips and Tricks

Luke's Tips and Tricks. Wednesday, November 2, 2011. Here is an easy shell script wrapper to easily run an SQL script. D $BaseDir ] then print -u2 "ERROR - Unable to find directory $BaseDir" exit 1 fi if [! D $LogDir ] then $MKDIR $LogDir if [ $? Ne 0 ] then print -u2 "ERROR - Unable to create directory $LogDir" exit 1 fi fi if [! F $SQLFile ] then print -u2 "ERROR - Unable to find file $SQLFile" exit 1 fi cd $LogDir if [ $PWD! You name the script with the same name as the SQL script you wish to run.

lukestirk.com

Home | South Bradford Golf Club

Skip to main content. Dress Code and Etiquette. WELCOME TO SOUTH BRADFORD GOLF CLUB. Memberships Available for 2017. View our family membership offers. Even the all-powerful Pointing has no control about the blind texts it is an almost unorthographic life One day however a small line of blind text by the name. Even the all-powerful Pointing has no control about the blind texts it is an almost unorthographic life One day however a small line of blind text by the name. Stay the Night with.

lukestock.com

Coming Soon - Future home of something quite cool

Future home of something quite cool. If you're the site owner. To launch this site. If you are a visitor. Please check back soon.

lukestockdale.com

LUKE STOCKDALE | Website of Luke Stockdale

lukestockley.com

Luke Stockley

Our most popular rings, these delicate diamond floral leafbands are available in 18 carat rose, white and yellow gold. FRESH WATER PEARL and MARCASITE. Featuring classic pearls to create a sophisticated and feminine range. A selection of fabulous cocktail rings inspired by vintage design and featuring rose and yellow gold, as was predominant in bygone times. Introducing our new collection of opals. The pretty pieces in this collection are exquisitely crafted combining two of the most feminine gems. If a ...

lukestoker.com

luke-stoker---bass