Items in Pending Transactions of Inventory Module
Hi, We have items in Pending transactions of Inventory Module, they cannot be progressed because The Sales order is already cancelled. The problem is our item reservable is decreased because some of the items were stuck in pending transactions.I tried to use this but it did not work : i2471362.sql
Answer Question
| Aug 27 2008 2:07 AM GMT
| asked by
Execute
Oracle installation, Oracle import/export, Oracle administration
Oracle to SQL Server Migration - CURSOR type conversion
When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000)**SSMA Warning**O2SS0259:CURSOR type was converted to varchar(8000)**Do we just leave this as is or does it require attention.Thanks.
View Answer
| Aug 22 2008 1:42 AM GMT
| asked by
Kumar9378
SSMA for Oracle, SQL Server import/export, Oracle import/export
Oracle to SQL Server Migration - User Defined data types
Oracle database has two user defined types as the following:CREATE OR REPLACE type arrayType1 is table of intCREATE OR REPLACE type arrayType2 is table of varchar2(255)How do we represent these in SQL Server 2005?!!(Note: Microsoft SSMA fails to migrate these)Thanks
View Answer
| Aug 22 2008 1:38 AM GMT
| asked by
Kumar9378
SSMA for Oracle, Oracle migration, Oracle import/export
convert Oracle query into xml file
Is there any software to convertautomatically oracle table(query)into xml file like JSP in java.
Answer Question
| Jul 30 2008 6:14 AM GMT
| asked by
Dnlkc
Oracle import/export, XML
export data based on date
Hi i'm new to oracle how can i use the export command to export data based on date and subsequenly purge the data exported from the database?Thanks for any info
View Answer
| Jul 16 2008 3:55 AM GMT
| asked by
Fartman
Oracle import/export, Oracle export
How to switch to IMP/EXP Utility of multiple installs of Oracle on same client?
I have installed Oracle 9i and Oracle 10g on one Windows XP machine and two Oracle homes were successfully created - as i can switch between them using the Home Selector.I then tried the same install on another box with Windows XP, but when I use the Home Selector I get a message telling me only...
Answer Question
| Jul 15 2008 5:17 PM GMT
| asked by
OracleATE
Oracle import/export, Oracle 10g, Oracle 9i
Oracle export causes DBMS_EXPORT_EXTENSION error
I am facing a problem with the EXP command. The execution starts normally, but during the execution about midway, the command gives the error: dbms_export_Extension must be declared. After that, only the structure of the tables goes to backup and no data!This issue never happened in my 3-4 years...
View Answer
| Jul 15 2008 5:04 PM GMT
| asked by
OracleATE
Oracle import/export, DBMS_EXPORT_EXTENSION
Export parameters TABLESPACES, TRANSPORT_TABLESPACE in Oracle 9i
Do we need to set the parameters TABLESPACES, TRANSPORT_TABLESPACE to export table spaces and transportable table spaces meta data even when the parameter FULL = y. Please suggest me what to do for this case.
View Answer
| Jun 24 2008 5:53 AM GMT
| asked by
Vini Chandamama
Oracle 9i export parameters, Oracle import/export, Oracle 9i
Microsoft Access and Oracle
Can tables created in Access or Excel be imported into Oracle?
View Answer
| Jun 23 2008 8:49 PM GMT
| asked by
Micheline foxxe
Oracle, Access, Oracle import/export
How do I import 10.2 dmp file into 9.2 database
I have an Oracle 10.2.0.2 dmp file from another site. I need to import the data into a 9.2.0.6 database on hp-ux 11.11. I cannot modify the xport file nor do I have a 10.2 database to import into, but I do have the 10.2 software. Is there any way to import the 10.2 dmp file into a 9.2 database? ...
View Answer
| Jun 10 2008 3:29 PM GMT
| asked by
Jcmdba
Oracle, Oracle Database Versions, Oracle import/export
oracle form:export to excel
I have an oracle form,i need the code of a function that exports a given SQL query into Excel sheet on a button click action.
Answer Question
| May 21 2008 10:06 AM GMT
| asked by
Itbassem
Oracle, Oracle import/export, Oracle Forms
How to export all Oracle users from EBS?
I want to print all the Oracle users in our EBS. How to do it?Thx.
View Answer
| May 8 2008 6:23 PM GMT
| asked by
QAQA
EBS, Oracle import/export, Oracle E-Business Suite
Oracel import question
what happens if i import a particular table into a user schema which already contains the same table?
View Answer
| May 6 2008 6:11 AM GMT
| asked by
Fartman
Oracle, Oracle import/export
What’s the best way to import an Oracle database?
I have two databases in two different computers, but my databases are the same name, service and password. I recently updated the structure of one and backed it up using exp full=n file=*** and log=*** etc. I now want to imp this backup to the second machine so as to avoid repetitive work. Each...
View Answer
| Apr 28 2008 2:16 PM GMT
| asked by
OracleATE
Oracle import/export, Oracle replication, Oracle migration
Oracle 8i to Oracle 10g Export /Import
Hi,Presently iam Exporting the Oracle Database of 8i version 8.1.6.0 on HP-UX to import on Oracle 10g 10.2.0.3 So my question is there is any need to apply 8i Patch before taking export i.e; from 8.1.6.0 to 8.1.7.4 this is the last & latest patch of 8i to support 10g so i want to ask you that it is...
View Answer
| Mar 19 2008 4:43 AM GMT
| asked by
1349
Oracle import/export, Oracle 10g, Oracle 8i
Export Oracle 10g and Import to Oracle 9i
I have a data warehouse server that's running Redhat AS 2.1 and Oracle 9.2.0.4, and a production database that's running Redhat AS 4.0 and Oracle 10.2.0.3. I need to export tables from the Oracle 10g database and import them into the Oracle 9i database. The Oracle 10g server/database is new. I...
View Answer
| Mar 17 2008 7:36 PM GMT
| asked by
Llewis
Oracle import/export, Oracle 10, Oracle 9
