• Why can’t I export and import in Oracle 10g database?

    Export and Import are not supported on 10g databases for users logged in with the SYSDBA role. Logout and login using a different role before trying again.

  • How can I connect my application server to my Oracle 10g database?

    How can I connect my application server to Oracle database 10g. The application server have a form that can be accessible through browser (client). Please tell me the configuration that I have to do.

    Henlock5 pointsBadges:
  • Why do I not see Oracle database block gets and consistent gets

    hi, i have two test scenarios where i'm trying to understand to actual concept of db block gets and consistent gets. SQL> set autotrace on SQL>select * from scott.emp; i get 14 rows then Execution Plan ----------------------------------------------------------    0      SELECT...

    SAPORACLE10 pointsBadges:
  • Oracle 10g Database transfer

    How can I transfer Oracle 10g Database under Windows to Oracle 10g under Linux? What precautions need to be taken?

    ITKE345,300 pointsBadges:
  • Rename the Oracle 10g database user

    Hi. I want to rename the database user(username)without deleting the user and again creating in ORACLE 10g database??? plz, help me

    S1989082060 pointsBadges:
  • Unable to establish connection to Oracle database 10g XE

    Hi All, I have successfully Installed Oracle 10 g XE. When I Click 'Go to Database Homepage' to access the database the webpage shows an Error message "unable to establish a connection."  What could be the possible reasons for this error? and How can I fix it? Appreciate your HELP ! Thanks in...

    Chandan65115 pointsBadges:
  • Oracle 10g to SQL Server 2008

    Our DB is Oracle 10g. Our Clients Test DB is SQL Server. Now sometimes, we do incremental loads, full loads or historic load. The present system what we have is we send the insert statements and the DDL to them and they create and load. I did not write it. It takes 40 hours. Under 1 scheme we have...

    Cholan5 pointsBadges:
  • Recovering Oracle 10g Express data

    Hello My oracle 10g express eddition is curroped in my system and i install new oracle 10g express edition then how to recover my old data from a folder oraclexe.Plz Hepl me i am in big poblem

    Asdfzxcv10 pointsBadges:
  • Select/Insert Statements causing out of memory error run under VB Script

    I'm using VB Script on a Windows 2003 Server against an Oracle 10g database to both query against a table and insert new rows of data against that same table but as it runs it starts eating up RAM and when it gets to about 1.5gb it causes the out of memory error.  As far as the Select...

    TheBandit15 pointsBadges:
  • Replicating Oracle 10g database in Oracle 9i

    I have an oracle 10g database and would like to create a replica of it in oracle 9i. Could you please explaim if this is possible. I'm sure there would be backward compatibility issues to contend with.   Regards,

    Yomex5 pointsBadges:
  • hiding the username/password@db from the url while running 10g report

    iam running reports from developer 10 g release 1 using web.show_document command ,my application serves multi users that means each user has his own database user and password , so adding the key method in the cgicmd.dat will not help like : userlogin : destype = cache desformat=HTMLCSS...

    K197070 pointsBadges:
  • Rename username in Oracle 10g database

    Rename username in oracle 10g database without droping it

    S1989082060 pointsBadges:
  • Oracle 10g database creation errors in windows 7

    hello friends this is avishek behera.. recently i installed oracle 10g database software only in windows 7. after that i tried to create a database.. but i got an error like oermission denied.. i have installed in d drive which is not my system drive and also installed with administrator previlage...

    Avioracle15 pointsBadges:
  • Oracle 10g database issue

    how to increase the space of mount point dev/sdc1 scsi

    Chiya12335 pointsBadges:
  • Windows go blank while running reports in 10g

    I have oracle 10g as the database and front-end. When I run my application in 2 different windows and run a report in one of the windows, the other goes blank until the report is finished running. Any ideas why? Appreciate your help.

    Freestyler10985 pointsBadges:
  • Large number rounding in Oracle 10g

    Oracle 10g database table with a column having data type Number(20) stores 18 digits organization code.  When this data is retrieved in SQL*Plus or Toad it is displayed in scientific notation format. The display format can be changed from scientific notation format to number format. But, for some...

    Techguys90 pointsBadges:
  • Need to save dates in Oracle Forms 10g without modifying data values

    I am trying to save date and time as entered by the users example: In the insert and update triggers of my block my statement is: :MAIN_BLOCK.USER_DATE := TO_DATE(TO_CHAR(:MAIN_BLOCK.USER_DATE,'DD-MON-YYYY')||' '||:MAIN_BLOCK.HOUR||':'||:MAIN_BLOCK.MIN||':00 '||:MAIN_BLOCK.MERIDIAN,'DD-MON-YYYY...

    Starletmyra15 pointsBadges:
  • Buffer error on Crystal Reports 11.5 Parameter

    When I refresh the data on this report I'm building the report fails to get values. It list the cause of the error as "Buffer too small for string or missing null byte. UNKNOWN.RPT]" Isays that the errors source=prompt.dll and the error code is 0x8004380D. The field in the prompt is a date/time...

    Bgcsocal5 pointsBadges:
  • Analyze Oracle 10g

    I've been a little out of the loop on Oracle since Oracle 7. When we upgraded to 10g, we were led to believe that oracle would automatically handle regular analyzing of the database. This past week we discovered that not all tables are being analyzed regularly. What are we missing?  Is there a...

    Slcoit20 pointsBadges:
  • Oracle 10G Issues

    The problem I'm having is that MDAC 2.5 is no supported by 10G...I installed MDAC 2.8...When I went into the ODBC DSN drivers (Admin ODBC console) MS for Oracle was still there...the new driver for 2.8 was not visable. We used Oracle 10G client to connect...but it could not return a "ADO Recordset"...

    Thomcat10 pointsBadges:

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