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...
