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 | März 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 | Juli 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:...
de_DEDeutsch
en_USEnglish de_DEDeutsch