Hi,
I have just inherited a number of Oracle packages that I need to maintain.
All the packages make reference to DBMS_REPCAT_INTERNAL_PACKAGE
I could not find any reference to this in t...
I have written an Oracle 8.1.5 application with an MS Access front end. The oracle database, through constraints and triggers, provides all of the data validation. I would like to try to cap...
i want to run a report. for this i create a report object (named report42) pointing towards the "academic_calendar.rdf" report
Now when i use the Run_report_object command in the code
...
I created a new database and I am trying to log in to the database. However when I enter connect /as sysdba
it reads that I am connect to an idle instance. When I type startup I get the follo...
I have a field that currently does not accept null values when inserting a record. I need to modify that field to accept null values. It is not the primary key in the table. What is the syntax...
I have many UNIX servers with many Oracle instances. When a certain application is run on the database server, it creates a deadlock, which in turn hits a nasty Oracle 9.2.3 bug which corrupts...
We have 9i database which is US7ASCII database character set.
We have created new 10g database with AL32UTF8 character set , and imported the data from 9i to 10g.
When we started que...
We have an Oracle 9.0.1.4 database on hpux 11i. What is the simplest or best way to restrict having regular clients accessing the database via tools such as TOAD, Excel, MS Access, ODBC etc. ...
Oracle 9i using AUM
Can anyone tell me the average size of an UNDO tablespace?
Greetings,
When I execute this procedure, it use to return normal values but now it returns a 0 or -1. What would have cause this procedure to behave in this manner now? It there a database...
hi,
is there any way to optimize this oracle update statement.
i needed to include the where exists clause so that it wouldn't update the non-matching rows to null. this kind of update happe...
I have a computer with Oracle 9i and 10g which works fine.
Now I have installed Oracle HTML DB with Oracle HTTP Server, and after installing these work fine.
However, when trying to acce...
How to fetch last 3 records from table in oracle without using rownum.rowid in a query?
Similar scenario to previous post: Oracle client on Citrix terminal server, but did not see information there to resolve the issue.
Sunblade platform, solaris 8, oracle 10g r 2
I am seei...
i have my source database oracle 9i on hp -unix amd have oracle 10g database on linux suse in replication enviornment.now i have migrate whole data from hp=unix to linux suse. i have decided ...
Hello,
I am OCP... that was enough introduction for me...
now going directly to question....
First look at the part of the script that i m using for creating a sample database...
P...
Hi,
I need to import data from an Excel file/ access db into an Oracle db. I have TOAD installed but trying to use the SQL Loader, gives me an error "Location of SQL Loader required" and I ...
I am looking for a free sample medical datebase for a 10 man offices that I can use and download
any one out there?
I'd need to know the Mac Address of the client to keep a record of changes in some tables I chose, since the IP addresses are dynamic and the terminal name can be modified, it seems to me this...
I am trying to optimise a query that is running very slow ever since the amount of information in db has increased.
Here's the query. Any suggestions on other way of creating query so that it...
Hi,
I have a Oracle 9.2.0.4 db server.
I am trying to make a full backup.I run into the below mentioned error.
Any help is appreciated.
Thanks
Error at the bottom:
About to export ...
Hi,
I run Opatch from the patch directory and get the following output and eventual error:
Location of Oracle Universal Installer components = C:\Program Files\Oracle\oui
Location of Or...
Need to copy a schema users roles, system privs and object privs to another user in database on different server
Highly critical time issue
Mike
I inherited support of an Oracle 9i dataguard backup system on Redhat Linux AS2 . However the standby database does not start up automatically on reboot. If the standby DB is down longer than ...
I tried to install forms and reports services - 10g on a laptop with xp. Since it failed on java configuration, I would like to uninstall them, but leave oracle software that was previously i...
