Space Station Threshold

When you use one database platform long enough you start to think everything you do is ANSI SQL-92 compliant. Until you switch database platforms that is! Then you find the simple things no longer work. Take for example the TOP clause used so often in...(read more)

This is a slick little trick to get around the need for a complete TNSNAMES.ORA file: Have you ever tried to access an oracle instance in VBScript? This is not to complicated, but normally you need an additional file called tnsnames.ora in the oracle...(read more)

Found it. Buried in a forum posting somewhere... @echo off FOR %%f IN (.\sql\tab1\*.sql) DO exit | sqlplus [uid]/[pwd]@[db] @ '' %%f '' FOR %%f IN (.\sql\tab2\*.sql) DO exit | sqlplus [uid]/[pwd]@[db] @ '' %%f '' Add '' exit | '' to the beginning of the command...(read more)

This is more for my own notes but you are welcome to glean from it what you can. There are a couple main steps involved in pumping a DMP file back into a blank Oracle database. Round up the user, schema and tablespace info Create the tablespaces Create...(read more)