Experts Exchange Search Results

Hi, I need to design an error handling framework for an ETL engine which uses SQL Loader to load data to staging tables, and uses PL/SQL procedures to load data into the warehouse, and java int...

http://www.experts-exchange.com/Database/OLAP/Q_23116771.html

Zones: OLAP, Oracle 10.xDate Answered: 03/25/2008 Grade: A Views: 118

Oracle Sql Developer - view number data type as a character

Tags: Oracle, 10.2

I am creating a sql script and have found the the account number data type is not consistent across all tables. Number(17) in one table, Varchar2(18) in another. I need to join on the right 15 ch...

http://www.experts-exchange.com/Database/Oracle/10.x/Q_23231719.html

Zones: Oracle 10.xDate Answered: 03/11/2008 Grade: A Views: 0

insufficent privileges creating a view on top of a view

Tags: oracle, 10.2

i have an error creating a view on top of other view....consider this following example... i have two schemas S1 & S2 S1 has 2 objects ...table T1 and View T1_V....(select * from T1) Now i...

http://www.experts-exchange.com/Database/Oracle/Q_23271004.html

Zones: Oracle, DatabasesDate Answered: 03/26/2008 Grade: B Views: 8

exception handling in sql loader

Tags: oracle, 10.2

Hi, I am loading a transaction file into a staging table using SQL loader, so in the process if there are any data type errors, some records or transactions are going to bad file. Here i have...

http://www.experts-exchange.com/Database/Oracle/10.x/Q_23277521.html

Zones: Oracle 10.x, Databases, OracleDate Answered: 03/28/2008 Grade: A Views: 31

Oracle Locator, Creating a table of centroids not working...

Tags: Oracle, 10.2

Hi there, Note: Oracle 10.2.0.3, Win XP / 2003 Server I am attempting to create a table of centroids from another table of polygons. There should be one centroid for each polygon. My source...

http://www.experts-exchange.com/Database/Oracle/10.x/Q_23385768.html

Zones: Oracle 10.x, OracleDate Answered: 05/08/2008 Grade: B Views: 15

Need to convert data source on a datawindow from SQL select ...

Tags: Powerbuilder 10.2

Hi. I have a fairly complex datawindow (lots of computes, totals, grouping, etc.). I need to change the data source from the current SQL select to a stored procedure. Is it possible to do this w...

http://www.experts-exchange.com/Programming/Editors_IDEs/PowerBuilder/Q_23496210.html

Zones: PowerBuilderDate Answered: 06/19/2008 Grade: A Views: 0

Trigger or procedure

Tags: oracle, 10.2

Hi All, Can we have some trigger or stored procedure in database which capture all locks including row locks when we doing load testing. Thanks Sudhakar

http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23747599.html

Zones: PL / SQL, Oracle, Oracle 10.xDate Answered: 10/01/2008 Grade: A Views: 5

Auditing DataBase

Tags: Oracle, 10.2

I need to set up Audit on the database.e.g if someone drops or alter a table I should get an email. How do I set this up? I am running 10g(10.2.0.4). Thanks.

http://www.experts-exchange.com/Database/Oracle/Q_23824125.html

Zones: OracleDate Answered: 10/20/2008 Grade: A Views: 8

ntpq: read: Connection refused

Tags: openSuse 10.2

When i run the command ntpq -p I get this error message. ntpq: read: Connection refused does anybody know what it means in relation to ntp my ntp.conf : driftfile /var/lib/ntp/drift/ntp.dri...

http://www.experts-exchange.com/OS/Linux/Q_23891486.html

Zones: Linux, Linux Net, Linux AdminDate Answered: 11/10/2008 Grade: A Views: 17

Can't Port forwarding with OpenSuSE 10.2

Tags: Novell, OpenSuSE , 10.2

I am trying to set up a Open SuSE 10.2 server to port forward smtp from an external mail server to my internal exchange box. The external ip range: 203.97.94.144/28 IP of external interface(of...

http://www.experts-exchange.com/OS/Linux/Distributions/SuSE/Q_22802904.html

Zones: SuSE Linux, Linux Net, So...Date Answered: 03/24/2008 Grade: A Views: 78