Windows :: Import Ms Project Data Into Oracle Database?

Sep 5, 2012

Is there any method to import Ms Project data into Oracle Database.

View 1 Replies


ADVERTISEMENT

SQL & PL/SQL :: Database Migration Project To Oracle

Nov 8, 2010

I am working on database migration project SQL server to oracle, convert this query sql server to oracle basic thing i change but i still getting following error: ORA-01799: A column may not be outer joined to a subquery.


SELECT
h.unique_id,
h.customer_id, h.sequence_id, h.name_first, h.name_last, h.email,
h.tn_work, h.tn_home, h.tn_cell, h.tn_work_do, h.tn_home_do, h.tn_cell_do, h.primary_contact_id,h.ssn, h.created, h.customer_status_id, h.doi, h.dod,
NVL(CASE WHEN h.primary_contact_id = 1 THEN tn_home WHEN h.primary_contact_id = 2 THEN tn_cell
WHEN h.primary_contact_id = 3 THEN tn_work END, '') AS ext_primary_contact, ext_customer_status_desc FROM customer c
INNER JOIN customer_history h
[code]...

View 4 Replies View Related

How To Import Data From Informix To Oracle 10g Database

Dec 12, 2012

I am working on informix 7.25SE version I need to import data from informix to oracle 10g data base .

View 5 Replies View Related

Export/Import/SQL Loader :: Copy Data From Oracle Database To Another?

Jun 6, 2013

I want to Copy a data from One oracle database to another.

I have checked Import/Export Utility but the problem is import utility doesn't support conflicts resolution techniques between rows.

For Example if there's a table in the source database have the same row key in the destination database. if i use 'Ignore' parameter with value = y, the destination table will have a duplicate rows.

I want to ask if there's another way to import data from oracle database to another with some mechanism of detecting the conflicts and resolve them?

View 11 Replies View Related

Windows / .NET :: Excel VBA Macro To Fetch Data From Oracle Database

Aug 1, 2012

we are using ERP System based on Oracle DB. I have an oracle client 10.2.0 installed on my machine (Win 7/64-Bit) and trying to create Excel(2010) VBA-Macro to get datas out of the Oracle DB using a SQL query:

On my old machine (Win XP/Excel 2007) following worked fine:

strConOracle = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=" & strHost & ")(PORT=1521))" & _
"(CONNECT_DATA=(SERVICE_NAME=" & strDatabase & "))); uid=" & strUser & " ;pwd=" & strPassword & ";"
Set oConOracle = CreateObject("ADODB.Connection")
Set oRsOracle = CreateObject("ADODB.Recordset")
oConOracle.Open strConOracle
Set oRsOracle = oConOracle.Execute(strSQL)

All the datas in the variables coming from cells or userforms - I am 100% sure all this is correct, as as said, it works on any Win XP Machine with Excel 2007

But trying same with Win 7/64-Bit/Excel 2010 gives me following error: MS ODBC Driver for Oracle: ora-01019: unable to allocate memory in the user side.

View 0 Replies View Related

Export/Import/SQL Loader :: Migrating Data From Solid Database To Oracle - Flat Files

Aug 14, 2012

I am migrating data from a Solid Database to Oracle, I am using Flat Files to do that.

1.- I download the data to flat files from Solid
2.- I move the files to Oracle server
3.- I upload the data to Oracle

Now, I have done the 90% of the data base, but I have found some tables that has description columns and in this description the users writes enters, so when I try to upload the data to Oracle SQL loader cannot recognize this characters.

Example:

'25','0.','5.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'26','0.','2.','0.','0.','0.','0.','3.','0.','0.','0.','0.','0.','',''
'27','0.','1.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'28','0.','1.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'29','0.','38.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'30','0.','13.','0.','0.','0.','0.','0.','6.','0.','6.','0.','0.','|SE RECHAZA B20CS50SNW ^M
^M
SE RECHAZAN CINCO PZAS ^M
DOS MOD. HSC15I41EH,DOS MOD. HSK15I41EH |Agregó: 06/06/2009 12:22:50
|','DEV. A PROV.'
'31','0.','50.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'32','0.','9.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''
'33','0.','2.','0.','0.','0.','0.','0.','0.','0.','0.','0.','0.','',''

How can I solve this ?

View 3 Replies View Related

PL/SQL :: Legacy Data Migration Project - Cyclic Dependency Records

Mar 1, 2013

It's been a while since I worked with SQL Plus . I am using Oracle 11g. We are working on a legacy data migration project. I have a table of records with circular dependency records. i am trying to identify the records. I have the foll. columns- Product,Source,target. I want o identify the records which form a loop. For e.g.

Source Target
A B
B C
C D
D A

Last record forms a loop-I need to identify these records. My query is below-

SELECT DISTINCT SOURCE,TARGET FROM RULESELIB WHERE CONNECT_BY_ISCYCLE=1 CONNECT BY NOCYCLE SOURCE=PRIOR TARGET;

I ran this query on 2 tables- one with 75000 records and the other with 25000 records. It works fine on the table with 75000 records completes within a minute but it does not complete on the other table. I can't seem to be able to figure out the issue with the query or is there something about the data that is causing this query to loop infinitely?

View 11 Replies View Related

Export/Import/SQL Loader :: Using Datapump On Windows Client When Database Is On Linux

Jun 13, 2013

the database (11gR2) is located on Linux server. A business application is installed on a Windows server with an Oracle client 11g.The application is able to start a datapump export, but as matter of fact the dumpfiles are always written to the Linux-server. The directoryobject is defined as DATA_PUMP_DIR (which is the default directory).

Now we are supposed to change the datapump export in a matterthat the dumpfiles get written to the Windows server. Creating a new directory (e.g. c:datapump) and starting than the datapump from theclient always raises the errors 

ORA-39002: ...ORA-39070: ...ORA-29283: ...ORA-06512: in "SYS.UTL_FILE", Zeile 536ORA-29283: ... 

Is it possible at all to start a datapump export from a Windows client and writing the dumpfiles to the Windows server itself? Or do the dumpfiles  always written to the database-server?

View 9 Replies View Related

Forms :: How To Create Trial Version In Oracle Project

Jan 2, 2013

how to create trial version in oracle project.i want to anyone use my oracle (forms) project for some limited time..and then expire after some time..

View 3 Replies View Related

SQL & PL/SQL :: Structure Schemas Within Single Oracle Instance To Support Multiple Project Development

Jan 24, 2013

The best way to structure my schemas within a single Oracle instance to support multiple project development. At the moment, within an Oracle instance I have Area_Dev and Area1_Test schemas, with the intention that Project Xv1.0 would use Dev schema for development and Test schema for testing.

Lets say I want to start on Project Xv2.0 development while I am still finalizing Project Xv.10 development what is the best way of accommodating that, without creating individual schemas for each project?

View 3 Replies View Related

Windows :: Does Oracle Database 10.1.0.2 (64-bit) Compatible With Windows 2003 R2

Jan 9, 2011

Does Oracle Database 10.1.0.2 (64-bit) compatible with windows 2003 R2 standard X64 edition with Service pack 2.

View 1 Replies View Related

Import Data Into A 10g Database On RHEL5?

Sep 2, 2010

I am trying to import data into a 10g Database on RHEL5.

Fol are the type of TABLE_NAME's of the TABLEs on the export dump:

1.ABCD
2.A_BCD
3.XYZ_AM
4. XYZAM

My requirement is:

I need to import only tables 1 & 4. I would like to exclude tables 2 & 3.

This is what I have only par file:

EXCLUDE=TABLE:" LIKE '%!_AM' escape '!' "
EXCLUDE=TABLE:" LIKE 'A!_%' escape '!' "

When I run a query to check it works fine:

$>select TABLE_NAME from dba_tables where TABLE_NAME like 'A!_%' escape '!';

TABLE_NAME
------------------------------
A_...........
A_..............
A_...............

3 rows selected.

But when I run the import using the par file, i keep getting

ORA-39001: invalid argument value
ORA-39071: Value for EXCLUDE is badly formed.
ORA-01740: missing double quote in identifier

View 4 Replies View Related

Server Administration :: Cyrillic Character Set - Import A Table Of Data To Another Database

Aug 31, 2011

I'm try to import a table of data (character set: CL8ISO8859P5) to another database (character set: AL32UTF8) using exp/imp utility.After the import, all Cyrillic text was corrupted!

View 5 Replies View Related

Server Administration :: Import Data To Production Database - Details Are Not In Tnsnames.ora

May 3, 2011

I need to import data to production database. The database details are not in tnsnames.ora.

I am using easy connect method to connect to the database, since I am not able to edit tnsnames.ora.

Is there any way by which I can do the import ?

Can I do it like this

imp system/pwd@imp system/pwd@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx)(PORT=1521)))(C
ONNECT_DATA=(SID=xx))' ......................

View 4 Replies View Related

PL/SQL :: How To Import And Export Database In Oracle

Jun 27, 2013

How to import and export database in oracle? what is difference between backup and restore?

View 0 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

Forms :: Import Access Data To Oracle?

Jun 2, 2010

when i create db link then it show below:

SQL> conn sys as sysdba
Enter password: ********
Connected.
SQL> show user
USER is "SYS"
SQL> create database LINK orafaccess using 'ORAFACCESS';
Database link created.
SQL> desc emp@orafaccess
ERROR:
ORA-02085: database link ORAFACCESS.APEX.COM connects to HO.WORLD
SQL>

View 10 Replies View Related

Forms :: Import Data From Excel To Oracle?

Jun 21, 2013

I have designed a form to import data from an excel worksheet into an Oracle Form and It works pretty fine.

I use either Ole2.get_char_property or Ole2.get_num_property depending to the property of the column to read data but there are some columns used by both property which means that database is designed as VARCHAR2. The user can maintain either a numeric or characteristic data there. So I am looking for a solution to be able to make the program more flexible that he can read the property of the cell in excel file and decide what to use between Ole2.get_char_property and Ole2.get_num_property to read from excel file properly.

solve the problem regarding reading from Varchar2 columns.

View 1 Replies View Related

SQL & PL/SQL :: Table Creation - Import Data In Oracle?

Sep 20, 2012

i have 1 xcel sheet in formatted data i want to import data in oracle table .. how do i do dat??

View 5 Replies View Related

Import Oracle 10g Database Table Into 8i On Linux Platform?

Apr 13, 2013

can we import oracle 10g database table into oracle 8i database on linux platform?

View 7 Replies View Related

Copy And Rename An Oracle Database - (without Export / Import)

Oct 21, 2011

I inherit a backup procedure described in

[URL]......

I ask if this procedure works on Oracle Database 10g R2. I have a Oracle DB 10g r2 on Linux machine and I want to copy it to a windows Oracle DB 10g r2, or if it not works to another Linux machine.

View 2 Replies View Related

Server Utilities :: Import Oracle 10g Dump Into 9i Database

Mar 31, 2010

If I want to import 10g export dump file in to the 9i database, I am connecting to 10g database from 9i database using
exp user/password@10gdb ....

However is there any option like executing 9i catexp.dat on 10g database and do the export from 10g database itself to be imported into 9i?

View 6 Replies View Related

Server Utilities :: Import 1 DMP File Into Oracle Database?

Sep 16, 2008

I want to import 1 .dmp file into oracle database. I dont know what exactly what that .dmp file contains e.g i dont know the Users inside the dump.While importing it gives me the error.

1. Do i need to create those users first and then import if yes then how would i know how many users are inside that dump.

2. Currently the objects are created in SYSTEM user by default. I want to import those objects in the MACL user which i created. How can i do it?

IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MALCCOMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:

[Code]....

View 2 Replies View Related

Server Utilities :: Import And Export Database In Oracle?

Oct 11, 2011

import and export database in oracle with proper example and procedure?

View 3 Replies View Related

Import Data From Excel To Oracle Table Using Toad

Dec 26, 2012

how to import data from Excel sheet (inside server) to oracle DB.

Explanation : I need to automate this work, whenever i get an excel sheets with table values, i need to import the table values in to oracle DB automatically.I need an immediate solution for this.

View 4 Replies View Related

Import Data To Multiple Tables In Oracle DB From SQL Server?

Jun 30, 2012

What is the Best way to import data to multiple tables in Oracle Data base from sql server?

1)linked server?

2)ssis ?

If possible share me the query to done this task using Linked server?

View 2 Replies View Related

Best Way To Import Data To Multiple Tables In Oracle DB From SQL Server

Mar 7, 2013

What is the Best way to import data to multiple tables in Oracle Data base from sql server?

1)linked server?
2)ssis ?

If possible share me the query to done this task using Linked server?

View 1 Replies View Related

Windows :: Install Oracle Database 11g.2?

Aug 6, 2011

I am trying to install oracle database 11g.2 on windows 7. bu I received error in configuration database step.error is attached to this topic. installed database on windows so far.the emca text is below .....

-----
@echo off
setlocal
set OH=E:appproduct11.2.0dbhome
set JRE_JAVA=%OH%jdkjreinjava

[code]...

View 10 Replies View Related

Windows :: Installation Of Oracle Database 10g Or More

Nov 15, 2010

I want to install any version of Oracle database in my laptop IBM Lenovo Y450 64 bit, but i have win 7 home, how to install it in win 7 home edition, one main thing i don't have money to upgrade it to windows 7 ultimate,

View 3 Replies View Related

Export/Import/SQL Loader :: Copying Oracle Database Users From 9i To 11g?

Aug 19, 2012

I need to copy more than 1000 database users(without objects) from orcle 9i to oracle 11g. They don't allow to use any graphical tools.which is the best way to complete this task? does conventional export /import works for only users only ?

View 2 Replies View Related







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