1 - 9 of 9
PREVIOUS 1 NEXT
How do I concatonate the data from the same field from multiple rows
I need to concatonate data from the same field with multiplre rows witha one to many relationship. As and example: oder_id product 503 corn 503 beans 503 apples the end result wanted would be ...
I need to concatonate data from the same field with multiplre rows witha one to many relationship. As and example: oder_id product 503 corn 503 beans 503 apples the end result wanted would be ...
5 pts.
Oracle Migration 9 to 11g grants missing
a user get the 'table or view does not exist' error after migration from Oracle 9 to 11g - even though in the DD I can see owner grants select on the tables to role -> role is granted to the user (only grants direct to user are working fine) Software/Hardware used: Oracle 11g
a user get the 'table or view does not exist' error after migration from Oracle 9 to 11g - even though in the DD I can see owner grants select on the tables to role -> role is granted to the user (only grants direct to user are working fine) Software/Hardware used: Oracle 11g
Oracle Statspack
I recently started running statspack on my Oracle 9.2.0.7 database so I can get concrete evidence of what is going on in my database, besides viewing it through the grid. I started up statspack on Monday at 5pm and told my director that I'd turn is off at 5pm the next day. I did not turn it off...
I recently started running statspack on my Oracle 9.2.0.7 database so I can get concrete evidence of what is going on in my database, besides viewing it through the grid. I started up statspack on Monday at 5pm and told my director that I'd turn is off at 5pm the next day. I did not turn it off...
Moving Oracle from one windows domain to another
We are using Oracle 9 running on Windows 2003 R2. We moved the server into a different domain which is also within an AD environment. We then received the following error codes. RdConnection: Error # -2147467259 OpenConnection Description ORA-01034 ORACLE not available ORA-27101 When we...
We are using Oracle 9 running on Windows 2003 R2. We moved the server into a different domain which is also within an AD environment. We then received the following error codes. RdConnection: Error # -2147467259 OpenConnection Description ORA-01034 ORACLE not available ORA-27101 When we...
Two Applications sharing the same database
Hi , We have ORACLE RDBMS 9.2.0.6 ,and E-business suit 11.5.10.2 . Platform is Solaris 10. The applicatioin and the database are on the same server. We have users accessing this application from another Geographical location .Those users are facing performance problems due to the link ....
Hi , We have ORACLE RDBMS 9.2.0.6 ,and E-business suit 11.5.10.2 . Platform is Solaris 10. The applicatioin and the database are on the same server. We have users accessing this application from another Geographical location .Those users are facing performance problems due to the link ....
Running RMAN (Oracle 9.2.0.8 Enterprise Edition) over network fails with ORA-12560
Running RMAN (Oracle 9.2.0.8 Enterprise Edition) over network fails with ORA-12560 - TNS Protocol Adapter error. In RMAN cmd file I've tried re-directing to OraHome with \dev-oraclec$oracleora92 as well as directly to the mapped drive: Z:oracleora92. Both fail with same error. I also set...
Running RMAN (Oracle 9.2.0.8 Enterprise Edition) over network fails with ORA-12560 - TNS Protocol Adapter error. In RMAN cmd file I've tried re-directing to OraHome with \dev-oraclec$oracleora92 as well as directly to the mapped drive: Z:oracleora92. Both fail with same error. I also set...
Scheduled job for Oracle 9 returning ORA-01858
We have an Oracle 9.2.0.1.0 database and get the ORA-01858: a non-numeric character was found where a numeric was expected error. Our production jobs are a series of stored procedures which are set up to run automatically by being called through another stored procedure, the Scheduler. While the...
We have an Oracle 9.2.0.1.0 database and get the ORA-01858: a non-numeric character was found where a numeric was expected error. Our production jobs are a series of stored procedures which are set up to run automatically by being called through another stored procedure, the Scheduler. While the...
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...
1 - 9 of 9
PREVIOUS 1 NEXT
