I work on sql server and have come across a database built by a company that has Oracle expertise. They have the same database implemented for an Oracle client.
The record import routines a...
I am trying to load Oracle 8i and am getting the following message while going through the Database Configuration Assistant.
The DB config Assistant is not being run from the ORACLE_HOME se...
I have an image on C:\ which is Read-Only........
Is there anyway I can change the attribute of this file to make it not read-only through forms.....
I have looked at WIN_API_FILE.file_a...
I am generating reports with the Repository Report Utility in Designer 6i.
When I want to generate file(html,pdf,htm) from the Previewer, an error message is raised:
REP-0999:Unimplemented...
I was using MS SQL Server. It has a stroed procedure, by using that you can create a full functional web page (HTML) if you pass table name to it. This stored procedure accepts table name and ...
Hi,
I have a really really tricky problem with an Oracle 8.1.6 database running on a Solaris machine. The
database is accessed by a cluster of ColdFusion 4.5.1 servers.
The database ch...
When I try to Export or import from The Enterprise Manager, I start op a wizard and I walk all the way true the wizard and in the end the wizard tell me the import succeed successfully.
But...
Using OCI 8.1.7 on Solaris, I'm getting this error when calling OCITransStart() . Several queries have been run successfully, prior to making this call. From the messages reference:
"ORA...
A database intensive operation failed during execution and then after a reboot of the system
when I try to log on to oracle it gives me these error messages
it is on Win NT and Oracle 8...
I realize that the Oracle SQL parser can only handle string literals up to 4000 characters in length when inserting or updating and that by using PL\SQL, it can be increased to 32k. I was won...
Hello,
i have a big problem with the DBMS_SQL-package. I'm using 8.0.5.2.2 on HP-UX.
I have a partitioned table. Each month i create a new tablespace for the next partition. This i done with...
Can anybody tell me how to find out Database Uptime in Oracle Database.Also is there any formula about calculating the same.
Is there any way to get the table name,number of rows in the table, for all the tables in the database with a single query
What are the new features in forms 6i?
what are the main differences between forms 6i and forms 5?
I´m trying to compile the examples in this directory because I want to connect to a database, I´m trying to use an OCI program to acomplish this.
Is there another form to connect from a prog...
I have a couple of tables with 1000+ rows in each and I want to give them, the ownership, to another user. I don't want to do a export/import. Is that possible or not?
can oracle read the crystal report .dc5 dictionary files?
Is it possible to pass a cursor into a stored procedure or function? I have 4 PL/SQL files that create a temporary table. All of the files are exactly the same except for the select statemen...
I have got Oracle (version 8.0.3) Running under Windows - NT 4.0
Under non - archivelog mode
128 MB RAM, 2 Redo log Groups with 2 Redo log members each of 201kb.
I am using TCP/ip protoco...
Hello all!
I need an urgent help
Im using Oracle Application Server 4.0.7.
I deleted one of my application (as I have done many times before!)
When I was trying to reload the OAS it didnt ...
How do i tune an oracle database(7.3.4) for optimal performance?
Hello.
Im working with Oracle Application Server 4.0.8 on Sun Solaris 2.6 , with Oracle database 8.0.5.
Im using the Oracle Call Interface.
While trying to execute one of my SQL's I got thi...
how can i make a SELECT return all records from a table even if the joined table's column is null and i have multiple joins from the same table.
I am self-studying oracle server8. I created a new instance ORC0, then I used instance manager to login, I used:
Username: internal
Password: oracle
Service: OracleServiceORC0
Connect As...
How can I select records from a table where year and month of a field (data type is DATE) are 1999 and December respectively ?
Andrew
