Oracle impdp (import data pump)
1). Create a directory: 2). Copy your database to the directory C:\ 3). Issue the impdp command 1impdp user/secret@ORACLE11G schemas=USERSCHEMA directory=export_dir dumpfile=export.dmp logfile=output.log
Oracle data pump export not including 0 row tables
Oracle 11gr2 Enterprise data pump export does not include 0 row tables 1C:\> expdp user/secret@SID DUMPFILE=out.dmp SCHEMAS=user LOG=out.txt To correct, extend 0 row tables: 1SELECT ‘ALTER TABLE ‘ || TABLE_NAME …
Install 11g (11.1.0.6) Oracle Client on Windows 7
http://msutic.blogspot.com/2009/08/how-to-instal-oracle-client-11g-on.html Shortly after initiating installation of Oracle Client 11g (11.1.0.6.0) installation stopped on prerequisite checks with error: Checking operating system requirements … Expected result: One of 5.0,5.1,5.2,6.0 Actual Result: 6.1 …
Oracle determine what tables have rows
To determine what tables contain row data 12345SELECT table_name, num_rows FROM all_tables WHERE owner IN (‘USER’) AND num_rows > 0 ORDER BY table_name;
Rebuild INVALID Oracle Objects
1234567891011SELECT ( case when object_type = ‘VIEW’ THEN ‘ALTER VIEW ‘ || object_name || ‘ COMPILE;’ when object_type = ‘PROCEDURE’ THEN ‘ALTER PROCEDURE ‘ || object_name || ‘ COMPILE;’ when …
.Net special characters within strings cause Oracle problems
Without the string replaces, running this string against an Oracle database will result in the procedure getting created, but with a compile error. 1234567891011121314string s = @" create or replace …
Determine Available Java Packages in Oracle
12select dbms_java.longname(object_name), status, object_type from all_objects where object_name like ‘%javax%’ and object_type = ‘JAVA CLASS’;
Call Java from PLSQL
1). Create a Java class 12345public class EDCTest1 { public static String getsometext() { return "this is test text"; } } 2). Load the class …
PL/SQL Exceptions
http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/07_errs.htm