convert Oracle query into xml file
Is there any software to convertautomatically oracle table(query)into xml file like JSP in java.
Is there any software to convertautomatically oracle table(query)into xml file like JSP in java.
5 pts.
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
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
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...
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...
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...
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...
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.
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.
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? ...
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? ...
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.
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.
How to export all Oracle users from EBS?
I want to print all the Oracle users in our EBS. How to do it? Thx.
I want to print all the Oracle users in our EBS. How to do it? Thx.
Oracel import question
what happens if i import a particular table into a user schema which already contains the same table?
what happens if i import a particular table into a user schema which already contains the same table?
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...
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...
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...
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...
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...
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...
