Advertisement

635 organizations, including eBay, Ericsson and Lockheed Martin, now work smarter with Corporate Accounts. Save up to 42%

 

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

 
Time Tested Oracle Product Info Solutions: 26 - 50 of 341
 
This is a two-part question. I have a partially restored database where I have some new, and some older datafiles.  Together I have them all.  No archivelogs, no anything.  This is the path...
The Problem: When attempting to run dbstart I receive an "Insufficient Privileges" error. The Pertinent Information:   - Database: Oracle 9i, Release 2 (9.2.0.1.0)   - OS: Red Hat Lin...
Hi!      I want to convert a LONG data-type column to char/varchar when i provide a view for my view user. Any comments/suggestions are highly appreciated... Thanks in Advance, Regards, U...
1. Is it possible to have an JSP webpage that show my user last time and date I drop data into a table, and how would I do do the query....I know how to search oracle with a JSP.   2. Then, I...
Where can I download oracle form/reports 6i software from ? I need it for windows 98 and I already have personal oracle 8i on my computer.
My data looks like this sale_fact table customer_key   site_key    week_key 1                     100           375 2                     200           376 2                     100    ...
I am trying to apply a CPU patch on my windows Oracle Database. I keep getting opatch errors related to Java: Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp...
Got this error closing a Statement object - what does this error below mean?? java.sql.SQLException:  Protocol violation    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) ...
This should be an easy question. I know I'm just missing something here. Background: I've got 2 servers.  Each with Oracle 9i on them. One called PROD the other called BCDS. I've made a du...
Greetings, I installed Oracle 10g Grid Control software on a Sun Solaris Sparc Server and everything installed successful but I am getting this error when I attempt to set my side and the o...
I have a text file that is tab delimited that I need to load into an oracle table. The fields are tab delimited. I don't know what the syntax is for indicating in a control file that a field i...
I have a query in oracle: query = "SELECT * FROM REGIONS ORDER BY To_Number(RID) DESC"; will the same querry work in mysql and sql?
Please explain in detail in terms of storage , performance. Thank you!
I have migrated my database from Oracle 8.0.5 to Oracle 10g, version 10.0.1.0.3 through import-export utility. During migration, one difference I made was to change the NLS_LANG to UTF8 from A...
Can someone point that what new included in 10g with developer point of view. Also I want to discuss here that there are three cd's for the oracle 9i while only one for 10g. Is there some copo...
I exported a table in a dump file as DBA from a windows environment. I need to import that dump file into a Unix environment as a user who is not a DBA. How can I enable the user to to import ...
How can resolve the following errors: ORA-04068: existing state of packages has been discarded ORA-04064: package body"mv.sbv"has errors ORA-06508: PL/SQL: could not find program unit bei...
OracleDBConsole Service Does Not Start After starting up without any problems following a recent install of Oracle 10g Standard Edition on Windows 2000, the OracleDBConsole%Oracle_SID% (Or...
We have got a problem on a Dynix system with ORA-01019 started happening The Oracle documentation is not very helpful Is this an appropriate place to look for help?
Hi everyone, I am tryin to do an import in oracle 8.1.7.4 in the management console and I get the following error: IMP-00058: ORACLE error 12638 encountered ORA-12638: Credential retrie...
I am transferring data from an 8.17 databse to a 10g database and get the following error, ORA-30036: Unable to extend segment by 4 in undo tablespace 'UNDOTBS1'  I am using the following stat...
Hi All, I removed the redo01.log, redo02.log and redo03.log files of our Oracle database. And it caused the db to fail. Is there any way I can recover the database? I do not need it to have a...
How do I increase the buffer size so that I will stop getting the following errors during import?: IMP-00032: SQL statement exceeded buffer length IMP-00008: unrecognized statement in the...
I have a series of SQL commands for Oracle 9.i.  I need the corresponding set of commands for Oracle 10.1.0.  I believe that dr0csys corresponds to ctxsys.  I have no idea what dr0inst, oractx...
Hi I have just installed Oracle Database 10g express edition, and the installation seemed to go well. I then select to go to the database home page after the installation which opens a b...