Oracle Data Integrator 11g

Apr 15, 2013

i had a problem with ODI 11g while i was loading some ";" delimited file.

The record is this one:
Header
PIATTAFORMA; FUNZIONE; OPERAZIONE; SUB_OPERAZIONE; DESC_FUNZIONE; SYSTEM; SUBSYSTEM; DES_OPERAZIONE; PROGRESSIVO; TIPOLOGIA; COMMIT; LOGGATA; MOTIVO_ESCLUSIONE
Data
UCAMP-PWS;CDBXF001;;;Inquiry su GEBA;CD;BX;;;Lettura;NO;NO;Funzione senza dati cliente

The field DES_OPERAZIONE is empty for that set of records, but is not a problem cause is a description, my target table is created with all VARCHAR2 except for one field that is Number (PROGRESSIVO in the example) and in this case is empty too, still not a problem cause is not some key or other.

What's happens to me is that if i have the field DES_OPERAZIONE empty, the record will be not loaded but without any message of error or warning. I used the NVL on the field to say if empty then 'ND' but doesn't work. The strange thing is that if i leave empty the field before for example for him doesn't matter, if i use NVL on the field before it works. On teh field DES_OPERAZIONE not !

View 1 Replies


ADVERTISEMENT

Migration From Data Integrator To Java

May 6, 2013

how to migration from ODI to java.. How to work on this type of migration.

View 1 Replies View Related

SQL & PL/SQL :: Handling Circular Data In Oracle / Get Disjoint Sets Of Data Connected By 2 Values

Sep 29, 2011

I have this table :

column1 column2
--------- ---------
value1 value2
value1 value3
value2 value4
value3 value7
value7 value1
value8 value9

What I was trying to retrieve is something like that:

Quote:
output_column
---------------
value1, value2, value3, value4, value7
value8, value9

I don´t care about the order of the values in the row. In other words, I want to get disjoint sets of data connected by any of both values.Every pair in the input table is unique.

I have seen in the web that it is possible to do using connect by and hierarchical retrieving but I've been trying to make a lot of combinationts and I can reproduce the output.

View 2 Replies View Related

ODP.NET :: Cannot Find Oracle Data Source In Entity Data Model Wizard

Dec 19, 2012

I'm trying to add edmx file in my project for first time. I want to choose the oracle provider ODP.net but cannot find Oracle in the data source list. I have oracle 11g installed , odp and odt installed and can access it from the solution as well. I saw the Oracle listed under data source when I tried to connect the solution to the database through server explorer. The solution is connected to Oracle database through ODP.

View 8 Replies View Related

Oracle Data Pump - Export Data From Schemas Or Tables

Oct 11, 2012

I need to export only the data from schemas or tables, how to do that with Oracle Data Pump? when we use schemas parameter this export all schema, not only the data right?

View 7 Replies View Related

Data Guard :: Data Files Locations On Oracle 11gR2

Jun 15, 2012

I have set up a cross platform (Microsoft Windows IA (32-bit) -> Linux x86 64-bit) data guard and it worked fine.Then I did a switch over (which again worked) and found out the data is not getting replicated at all.. checked the data files available from the new primary database and found out they are in the windows format as below..

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
D:ORACLEAPPADMINISTRATORORADATAMFSSYSTEM01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSSYSAUX01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSUNDOTBS01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSUSERS01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSRMANRMAN_TS01.DBF

and physically they were created at '/home/app/oracle/product/11.2.0/db_1/dbs/' and as

D:ORACLEAPPADMINISTRATORORADATAMFSREDO02.LOG
D:ORACLEAPPADMINISTRATORORADATAMFSREDO03.LOG
D:ORACLEAPPADMINISTRATORORADATAMFSRMANRMAN_TS01.DBF

View 5 Replies View Related

PL/SQL :: Get Data From Oracle To CSV?

Aug 14, 2012

I have oracle 10g r2 on windows.

I know the way to get data from Oracle to csv. But how can we read the data from csv and insert into Oracle table using UTL_FILE package.

View 6 Replies View Related

Oracle Data Guard?

Feb 16, 2012

Log shipping stopped logging/shipping into the Standby Database in one of our Oracle Data Guard Servers about two month ago and there was no change carried out as at that time. The Data Guard has only one Standby database. I have been managing the log shipping and recovery manually.

View 1 Replies View Related

Oracle And HP Data Protector

Sep 19, 2011

I would like to know if it is possible to create an automated standby database disaster recovery and high-availability solution (like dataguard) using hp data protector on oracle?

View 5 Replies View Related

PL/SQL :: Oracle Data Migration

Nov 9, 2013

Send me sample data migration scripts to get knowledge on Data migration. 

View 10 Replies View Related

Data Migration From WORD To ORACLE?

Sep 20, 2011

I have a long file in WORD as I try to load it in ORACLE quotes become periods, ex:

insert into mytab values ('myname, 26);

when i copy this and paste it in oRACLE (UNIX environment), it translates as insert into mytab values (.myname.,26)..does not recognize the quotes.

I tried copying from word to notepad to ORACLE same problem..

View 5 Replies View Related

Load Excel Data To Oracle?

Jul 3, 2008

How can i convert my ms excel record into oracle records??

View 3 Replies View Related

SQL & PL/SQL :: How To Mask Data In Oracle Table

Aug 4, 2011

In my project I am getting production dump for performance testing and I need to mask few columns with sensitive information.

How can I mask the data in Oracle?

View 5 Replies View Related

SQL & PL/SQL :: Can Modify Oracle Data Dictionary

Feb 6, 2011

can i modify oracle data dictionary

View 6 Replies View Related

Replication :: Data Transfer From Oracle 10g To 9i

Feb 16, 2011

We need to transfer data from oracle 10g to Oracle 9i in the following condition.

There will be two database server , one is online server where online user fill the form which is generated by java, spring , hibernate and using database 10 g. at day end i need to execute a process that transferring data from online server to offline server that is in oracle database 9i. This process is scheduled. Some security reason client do not kept this two database on same network. My challenge is that transfer data from online server to offline server with applying client security norms.I have option like:

1) Using Oracle replication method, creating materialized view on remote server , refreshing it at regular interval. but database connectivity is not contineous, should i go for that ?

2) Write java application on intermediate server where we write process to get the connection of this two database servers. From java application we call the procedure for selecting data from Oracle 10g and insert into oracle 9i database and using flag on both data to identified how many rows are transfered and how many remaining for trasfer.

View 7 Replies View Related

SQL & PL/SQL :: Loading Data From Oracle Into Excel

Jul 18, 2012

We have requirement such that whenever stored procedure is executed, their resultant records has to be stored in excel file ( Just like an reports ).No third party tool or reporting tools are used.

is there any option in oracle (Stored procedure or built in packages ) which can create excel file with the resultant records.

View 5 Replies View Related

SQL & PL/SQL :: Excel Data Import Into Oracle?

Jun 25, 2012

how excel data import into oracle

View 1 Replies View Related

SQL & PL/SQL :: How To Load Excel Data Into Oracle

Dec 28, 2010

how to load a XL sheet data into oracleDB.

View 7 Replies View Related

SQL & PL/SQL :: Inserting Excel Data Into Oracle?

Sep 24, 2011

I want to insert excel data into Oracle.

Excel File Name : Product 01
Excel columns
File Send on 13/02/2011

Arrival Date Product Code Gate Pass Quantity Inpection
01/02/2011 00002 Y 2 Y
03/02/2011 00001 Y 10 Y
04/02/2011 00005 Y 14 Y 03/02/2011 00006 Y 74 Y

File Send on 14/02/2011

Arrival Date Product Code Gate Pass Quantity Inpection
01/02/2011 00002 Y 2 Y
03/02/2011 00001 Y 10 Y
04/02/2011 00005 Y 14 Y 03/02/2011 00006 Y 74 Y
---New Updated Data
05/02/2011 00002 Y 2 Y
06/02/2011 00001 Y 10 Y
05/02/2011 00005 Y 14 Y 05/02/2011 00006 Y 74 Y

I just want to insert data according to my structure But if again the same file send with updated data it will only update the new data because previous data is imported.

Oracle Structure
Arrival Date Date,
Product Code char(5),
Quantity Number

View 9 Replies View Related

SQL & PL/SQL :: Reg Data Exporting To Excel From Oracle?

Dec 8, 2010

Now we are having 100+ sql queries and we making all those queries as procedures.after that we want to schedule those procedures and get data to export into excel file.

so we are planning to use utl_file to get data export excel. we may have rows of 30000 above.is it utl_file will be able upload all these rows into excel.any performance issue will come.

View 4 Replies View Related

SQL & PL/SQL :: XML Data Stored In Oracle Table

Nov 8, 2010

I have a XML data that needs to be stored in oracle table and it is read from a java application. what datatype will suit for XML storage varchar2 or CLOB. The length of XML will be less than 4000.

View 4 Replies View Related

PL/SQL :: Table Data Size In Oracle 11g?

Jul 12, 2013

how to find the data size in particular Table?Ex:I need find out the sh.sales table how much data size is loaded

View 3 Replies View Related

SQL & PL/SQL :: Remove Duplicate Data In Oracle-SQL

Mar 8, 2011

remove duplicate data in oracle-sql. can u post me the sql query to remove duplicate data with example.

View 1 Replies View Related

PL/SQL :: Oracle Sql To Find Missing Data?

Aug 10, 2012

Database version

Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for HPUX: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

I have this query

select dept_id,qc_subtype_id,equip_code,drive_id
from
(select distinct dept_id,
decode(qc_subtype_id,

[code]...

View 3 Replies View Related

Data Structures Used In Oracle Database

Oct 29, 2012

Which Data Structures are used in oracle database management system for sorting,searching,inserting? Means in SQL.

View 7 Replies View Related

How Does Oracle Insert Data Into The Columns

May 10, 2013

when we have a primary key on 4 columns and we have, say 20 million rows and we want to add one extra row. How does oracle check whether the data on the primary key is unique to the record being added compared to the 20 million rows. Does it actually compare the record being added to all the rows present in the table?

View 2 Replies View Related

PL/SQL :: Oracle Sql Get Data After First Occurrence Of Hyphen

May 29, 2013

I need oracle sql get data after first occurrence of hyphen.

source string:
abcd - efgh

I want everything after the "-"

View 17 Replies View Related

Oracle 9i - Delete Data One By One From Particular Table

Oct 28, 2008

I need to create a stored procedure in Oracle 9i which will automatically delete data one by one from a particular table and then by means of same procedure insert record one by one in same table.

View 6 Replies View Related

Security :: Oracle Encryption Data?

Apr 6, 2013

Can i get some documents on oracle RAC database encryption.?what are the pros and cons of encryption?Does this comes with oracle Database or something we need to buy from oracle sales persons?

View 2 Replies View Related

Extract Data From Oracle To Text Files?

May 13, 2004

I would like to extract some data value from oracle to a text file...and i m not sure how to set the delimiter between the columns data value

SET echo off
SET space 0
SET pagesize 0

SPOOL a.txt

SELECT emp_id, name, add
FROM table1
/
SPOOL OFF

Where do i set the delimiter?

Can i do something like in SQL*Loader?

fields terminated by ',' enclosed by '"'

I would like the text file to be display as
"123","ABCD","123 abc road"
"234","XYZ","234 xyz road"

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved