building a tree
how do you build a tree in oracle application express
Answer Question
| June 17, 2008 8:13 PM
Oracle, Oracle Apex, Oracle Application Express, Oracle development
how do you build a tree in oracle application express
Answer Question
| June 17, 2008 8:13 PM
Oracle, Oracle Apex, Oracle Application Express, Oracle development
Oracle Developer 2000 Certification
I have an experience of 8 years on Oracle & Developer 2000, but i have no certificate related it. Now i want to do certification. But what kind of track i should take ? I am cofused about it. Some body will help me for that?
Answer Question
| June 16, 2008 5:26 AM
Certifications, Developer certifications, Oracle certifications, Oracle Certified Professional
I have an experience of 8 years on Oracle & Developer 2000, but i have no certificate related it. Now i want to do certification. But what kind of track i should take ? I am cofused about it. Some body will help me for that?
Answer Question
| June 16, 2008 5:26 AM
Certifications, Developer certifications, Oracle certifications, Oracle Certified Professional
Restoring offline backup
How to apply offline redo log files to an off line backup which earlier to the offline redo log backup and recover system at less loss of data
Answer Question
| June 16, 2008 10:01 AM
Backup, Backup & recovery, Oracle backup, Redo logs
How to apply offline redo log files to an off line backup which earlier to the offline redo log backup and recover system at less loss of data
Answer Question
| June 16, 2008 10:01 AM
Backup, Backup & recovery, Oracle backup, Redo logs
Migration from Oracle 8 to Oracle 10g
I have a database of 80MB in Oracle 8 and want to migate to 10g. OS is Solaris. Pl guide ?
Answer Question
| June 13, 2008 2:48 PM
Oracle 10g, Oracle 8, Oracle migration, Solaris
I have a database of 80MB in Oracle 8 and want to migate to 10g. OS is Solaris. Pl guide ?
Answer Question
| June 13, 2008 2:48 PM
Oracle 10g, Oracle 8, Oracle migration, Solaris
upgrading oracle 8i to 10gR2 with 3.5TB database size
sirs, what is the best way to migrate a 3.5TB database from oracle 8i to 10gR2 on the same machine? the OS is AIX L5, with 10TB storage size
Answer Question
| June 16, 2008 3:36 AM
AIX 5L, Oracle 10g, Oracle 8i, Oracle migration
sirs, what is the best way to migrate a 3.5TB database from oracle 8i to 10gR2 on the same machine? the OS is AIX L5, with 10TB storage size
Answer Question
| June 16, 2008 3:36 AM
AIX 5L, Oracle 10g, Oracle 8i, Oracle migration
What causes ora-00904 error on valid fields when querying across dblink in a cursor
I have a procedure that contains a cursor that runs in a cursor for loop. The select query runs fine over the dblink all by itself, but when I try to compile the procedure, I get the PL/SQL: ORA-00904: invalid identifier on the column names. I can do a describe on the table over the [...]
Answer Question
| June 20, 2008 11:18 PM
Cursor, DBLink, ORA-00904, PL/SQL
I have a procedure that contains a cursor that runs in a cursor for loop. The select query runs fine over the dblink all by itself, but when I try to compile the procedure, I get the PL/SQL: ORA-00904: invalid identifier on the column names. I can do a describe on the table over the [...]
Answer Question
| June 20, 2008 11:18 PM
Cursor, DBLink, ORA-00904, PL/SQL
Help with new installation of SAP CRM and supporting software
We are going to Install SAP CRM 5.0 with Microsoft SQL Server 2005 and ECC 6.0 with Oracle 10g and integrate these with each other and also with QAS (Third Party tool). My question are: 1. Can we install all three applications on one single server as database is different or will there be issues [...]
Answer Question
| June 13, 2008 12:54 PM
CRM, ECC6, Oracle 10g, SAP CRM, SQL Server 2005
We are going to Install SAP CRM 5.0 with Microsoft SQL Server 2005 and ECC 6.0 with Oracle 10g and integrate these with each other and also with QAS (Third Party tool). My question are: 1. Can we install all three applications on one single server as database is different or will there be issues [...]
Answer Question
| June 13, 2008 12:54 PM
CRM, ECC6, Oracle 10g, SAP CRM, SQL Server 2005
How to exclude certain hours and certain days in a date range in oracle sql
hello, This is the table schema that i have: CREATE TABLE TEST ( COL1 NUMBER NOT NULL, START_TIME DATE NOT NULL, DURATION NUMBER, COL2 NUMBER, CONSTRAINT PK_TEST PRIMARY KEY ( COL1, START_TIME ) This is the query i have to select all the rows within a time range: SELECT f.col2, TRUNC(f.START_TIME,’DD’), FROM test f WHERE [...]
Answer Question
| June 17, 2008 4:41 AM
Oracle development, Oracle SQL
hello, This is the table schema that i have: CREATE TABLE TEST ( COL1 NUMBER NOT NULL, START_TIME DATE NOT NULL, DURATION NUMBER, COL2 NUMBER, CONSTRAINT PK_TEST PRIMARY KEY ( COL1, START_TIME ) This is the query i have to select all the rows within a time range: SELECT f.col2, TRUNC(f.START_TIME,’DD’), FROM test f WHERE [...]
Answer Question
| June 17, 2008 4:41 AM
Oracle development, Oracle SQL
Is it possible convert a mainframe COBOL program to read DB2 data on the mainframe and Oracle data on a server?
I have a mainframe batch COBOL program that reads DB2 data. One of the tables is accessed via a singleton SELECT. The table is being moved to an Oracle database on a Unix server. How do I change the program to be able to access the data in Oracle? Are there different ways to it? [...]
Answer Question
| September 23, 2009 6:37 PM
COBOL, DB2, Mainframe, Oracle, SQL, Unix
I have a mainframe batch COBOL program that reads DB2 data. One of the tables is accessed via a singleton SELECT. The table is being moved to an Oracle database on a Unix server. How do I change the program to be able to access the data in Oracle? Are there different ways to it? [...]
Answer Question
| September 23, 2009 6:37 PM
COBOL, DB2, Mainframe, Oracle, SQL, Unix
Can I use filler to skip a column in a csv file on SQL*LOADER rel 8.0.6.3.0
We are running Oracle E-business suite 11.5.10.2 on db 9i but when I execute sql*loader it gives me version 8.0.6.3.0. Is the key word FILLER available for me to use to skip unwanted columns in a comma delimited input file? I know FILLER became a key work in 9i – is that the db 9i? [...]
Answer Question
| October 18, 2010 4:47 PM
CSV, CSV input file, Oracle E-Business Suite, SQL
We are running Oracle E-business suite 11.5.10.2 on db 9i but when I execute sql*loader it gives me version 8.0.6.3.0. Is the key word FILLER available for me to use to skip unwanted columns in a comma delimited input file? I know FILLER became a key work in 9i – is that the db 9i? [...]
Answer Question
| October 18, 2010 4:47 PM
CSV, CSV input file, Oracle E-Business Suite, SQL
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 [...]
Answer Question
| June 10, 2008 3:29 PM
Oracle, Oracle Database Versions, Oracle import/export
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 [...]
Answer Question
| June 10, 2008 3:29 PM
Oracle, Oracle Database Versions, Oracle import/export
What is the significance of incarnation and DBID in the RMAN backups
What is the significance of incarnation and DBID in the RMAN backups
Answer Question
| June 11, 2008 11:08 AM
Database Identifier, Database incarnation, DBA, DBID, Oracle Recovery Manager, Recovery Manager, RMAN
What is the significance of incarnation and DBID in the RMAN backups
Answer Question
| June 11, 2008 11:08 AM
Database Identifier, Database incarnation, DBA, DBID, Oracle Recovery Manager, Recovery Manager, RMAN
What are the steps which need to be performed in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software ?
What are the steps which needs to be performed in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software ?
Answer Question
| June 11, 2008 11:02 AM
DBA, NetBackup, Oracle Recovery Manager, ORACLE_HOME, RMAN, TSM Tape Library
What are the steps which needs to be performed in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software ?
Answer Question
| June 11, 2008 11:02 AM
DBA, NetBackup, Oracle Recovery Manager, ORACLE_HOME, RMAN, TSM Tape Library
10g App Srvr vs. SOA
If I have Oracle 10g App Srvr why would I really need SOA? Doesn’t the App Srvr provide some of the same features SOA does?
Answer Question
| June 9, 2008 7:54 PM
Oracle 10g, SOA
If I have Oracle 10g App Srvr why would I really need SOA? Doesn’t the App Srvr provide some of the same features SOA does?
Answer Question
| June 9, 2008 7:54 PM
Oracle 10g, SOA
Should we use system tables or information schema views to retrieve metadata if both give the same results? Please explain why.
Should we use System tables or Information schema views to retrieve Metadata, since both give the same results, and why?
Answer Question
| June 9, 2008 3:10 PM
Meta data, SQL Server, SQL Server 2005, SYSTEM TABLESPACE
Should we use System tables or Information schema views to retrieve Metadata, since both give the same results, and why?
Answer Question
| June 9, 2008 3:10 PM
Meta data, SQL Server, SQL Server 2005, SYSTEM TABLESPACE
data from oracle 10g to oracle 8i
Im using oracle 10g and thru trigger i want to move data to oracle 8i for one particular table. when i try the trigger between two oracle 10g using database link its working fine. but from 10g to 8i giving error like ORA-04052: error occurred when looking up remote object
Answer Question
| June 10, 2008 11:26 AM
Oracle 10g, Oracle 8i, Oracle error messages
Im using oracle 10g and thru trigger i want to move data to oracle 8i for one particular table. when i try the trigger between two oracle 10g using database link its working fine. but from 10g to 8i giving error like ORA-04052: error occurred when looking up remote object
Answer Question
| June 10, 2008 11:26 AM
Oracle 10g, Oracle 8i, Oracle error messages
Linked Servers????
Hi everybody, I’m an IT student and i’m doing professional practices. A simple project was assigned to me. This company uses SMS to collect information of all his PC’s and stores this information in a MSSQL database. A manager checks this information and fills another database located in another server. For example, in the SMS [...]
Answer Question
| July 4, 2008 3:51 PM
Database, Enterprise Manager, Linked servers, SQL, Windows Server, Windows Server 2003
Hi everybody, I’m an IT student and i’m doing professional practices. A simple project was assigned to me. This company uses SMS to collect information of all his PC’s and stores this information in a MSSQL database. A manager checks this information and fills another database located in another server. For example, in the SMS [...]
Answer Question
| July 4, 2008 3:51 PM
Database, Enterprise Manager, Linked servers, SQL, Windows Server, Windows Server 2003
error with Jasper Server
java.sql.SQLException: ORA-00923: FROM keyword not found where expected when performing a drill through operation
Answer Question
| July 1, 2009 8:32 PM
JasperServer, ORA-00923, Oracle
java.sql.SQLException: ORA-00923: FROM keyword not found where expected when performing a drill through operation
Answer Question
| July 1, 2009 8:32 PM
JasperServer, ORA-00923, Oracle
PLSQL based method to capture emails from POP server
I am using UTL_TCP package of PLSQL. I am able to connect to the POP server but I am unable to retrieve any email content. Using the UTL_TCP.available() method, I am getting the returned number of bytes as Zero inspite of their being an email. I tested the telnet commands againt the POP server & [...]
Answer Question
| September 22, 2008 7:21 PM
PL/SQL, POP3, TCP, UTL-TCP
I am using UTL_TCP package of PLSQL. I am able to connect to the POP server but I am unable to retrieve any email content. Using the UTL_TCP.available() method, I am getting the returned number of bytes as Zero inspite of their being an email. I tested the telnet commands againt the POP server & [...]
Answer Question
| September 22, 2008 7:21 PM
PL/SQL, POP3, TCP, UTL-TCP
table storing in oracle 10g
where does create table get stored in oracle 10g
Answer Question
| June 10, 2008 4:47 PM
CREATE TABLE statement, Oracle, Oracle 10g
where does create table get stored in oracle 10g
Answer Question
| June 10, 2008 4:47 PM
CREATE TABLE statement, Oracle, Oracle 10g
