035179593513 [email protected]

Oracle Delete all Objects in a schema

von | Apr 25, 2015 | Oracle

DECLARE BEGIN FOR eachObject IN ( SELECT ‘DROP ‘ || object_type || ‘ ‘ || object_name || DECODE ( object_type, ‘TABLE’, ‘ CASCADE CONSTRAINTS PURGE’ ) AS statement_sql FROM user_objects WHERE object_type IN (...

Oracle Database Export and Import compressed

von | Mrz 25, 2015 | Oracle

Export #!/bin/bash $username=<username> $password=<password> $exportfile=<importfile> $exportlog=<importlog> $DBNAME=<dbname> mknod pipe p cat pipe |gzip -c >$exportfile & exp $username/$password@$DBNAME file=pipe DIRECT=Y...

Oracle Fat Client Konfiguration

von | Jul 25, 2012 | Oracle

  Windows System ODBC:   Schritte: 1: Start>>Alle Programme >> Zubehör >> Ausführen Um an die 32 Bit Treiber im System zu kommen:   Windows 64 Bit%windir%SysWoW64Odbcad32.exeWindows 32 Bit %windir%system32odbcad32.exe   2: 3:...