1
  • How do I concatonate the data from the same field from multiple rows

    I need to concatonate data from the same field with multiple rows with a one to many relationship. For example: oder_id product 503 corn 503 beans 503 Apples the end result wanted would be a single row order._id products 503 corn, beans, apples

    Linus665 pointsBadges:
  • How can i keep sys_guid() unique in multiple table insert

    I want to use unique sys_guid() for insert multiple table but out put are difference sys_guid() drop table T1; drop table T2; drop table T3; create table T1 (ROW_ID varchar2(50)); create table T2 (ROW_ID varchar2(50)); create table T3 (ROW_ID varchar2(50)); insert all into T1 values (NEW_ROW_ID)...

    arnuwan15 pointsBadges:
  • migrate from oracle 9 to oracle 11

    Can one migrate from oracle9 to oracle11 without migrating to oracle 10? If yes, what premigration settings are required?

    Anasoul5 pointsBadges:
  • 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...

    OracleATE190 pointsBadges:
  • Oracle data missing, over 500GB worth.

    Instance of Oracle on HP-UX 11.11, Oracle version 9.2.0.8, has lost hundreds of GB of data. Manual/accidental deletion is not possible as the process would take a long time to execute. Error logs do not show much, AUD$ log doesn't show any user activity during the window of time (roughly 24 hours)....

    Spamtrap15 pointsBadges:
  • 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 know...

    Llewis5 pointsBadges:
  • 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)

    ITKE56,585 pointsBadges:
  • SAP ECC and DB Oracle version compatibility

    Is SAP ECC 6 compatible with SGDB Oracle 9?

    LucianoBrazil5 pointsBadges:
  • 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 and...

    Jwwolff10 pointsBadges:
  • 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...

    Xxxxxxxxxxxxxx5 pointsBadges:
  • 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 . Question:...

    Said5 pointsBadges:
  • 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...

    OracleATE190 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following