How to take autobackup in oracle database ?
So far i am taking autobackup for x.dat file (which i created using tablespace).
Autobackup file is stored in some other server.
How can i resto...
Is Oracle the best DBMS (in case of technology) to develop an enterprise application?
If there is any document about the comparison among DBMSs, please show me.
Thanks.
Tin Phan
I am using oracle 7.3
When I delete more than one thousand records using "delete from tbl where fl < 10" I get rollback extent and it doesnt delete. How can I extend this oracle limitation ...
please could you explain all of that sets? , please.
SET VERIFY OFF;
SET TERMOUT OFF;
set trimspool on;
SET COLSEP " ";
SET ECHO OFF;
SET FEEDBACK OFF;
SET NEWPAGE 0;
SET HEADING O...
I am loading data from the data-files that have lots of duplicates into some staging table.
I do not have any control over data-file
(this is external log-file and sometimes i am getting ...
hi,
In my form (ver 6i) I have a header block and 10 detail blocks
I want to make a open query such that If I give a condition in my detail block thru Enter Query Mode and Press Execute ...
I have a production database that is set up incorrectly. The DB_BLOCK_SIZE parameter is set to 8K when it should be set to 64K. I'm currently building another contingency database to replica...
About SORT_MULTIBLOCK_READ_COUNT, it says that if you increase the size of this parameter you are increasing the amount of blocks read from disk (from temporary segments) to memory. If you do...
We have a multidimensional database but Oracle never seems to use the STAR query method. I always have to put the hint in. I analyzed all the tables. Is there some way I can steer the optimize...
If there is any write operation performed in the Oracle database(i.e. ADD/MODIFY/DELETE) then I should be informed from within my JAVA-JDBC code i.e. I should have some sort of event-listeners...
I want to load the value '- 486.21' into a table using SQL*Loader. The column datatype to be loaded is numeric. I want to use direct path loading so I can't use any SQL operators to trim the...
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...
Hello,
I'm new to Oracle and Unix so bare with me. I just installed Oracle8i (release 3) On a sun ultra 60. Installtion went fine no errors. Than I ran dbassist entered all the paramters...
Hi,
Dynamic SQL statement fails at runtime in Character
Mode, but runs succesfully in GUI mode.
compaq tru64 unix server and d2k rel 1.6.1 running on it with oracle database rel 8.0.5.1
...
I have a problem registering nodes with OEM.(Ver 2.2). All the nodes have registered IP addresses and linked directly through the internet (Each has DNS address). All the nodes are running Ora...
I've created a form based on a table UserInfo.
One of the fields is a CHAR(1) column storing the status of the user.
On the form I want to display the meaning of that single-character as w...
Is there anyway that I can compare 2 records in the same table or in different tables of the same structure, without a field by field compare. All I need is a boolean value back.
Hi, I'm a beginner in Oracle and I dun have experience in Oracle.Can anyone recommend any useful site for me to learn the concept and also the way to implement it?Thanks
yesterday at one
point, run form server-client button gave me a warning that FRM-10044:cannot
create file, when i pushed the next help button showed that internal system
error. I do not und...
DIGITAL ALPHA machine
Oracle 8.1.7
Looking to set up 5 or 6 listeners (one per client DB)
Each client has between 50 and 250 users
I would like to separate each client (group of users) ...
Hi friends,
How can i store nd retrieve ARABIC words in Oracle 8i..? should i have to download any translators for that..?
please give me a detailed info on that..
thanks..
Jim...
Hello everyone,
I am loading a csv file into a table in
oracle 8i using sql*loader.
It is giving an error of..
"partial record found at end of datafile"
This is normally caused by the w...
Can we call UNIX executable from Forms 4.5 on WIN NT? What are the settings are required on local PC and remote UNIX machine?
I would like to create database. Is there any way to estimate the Size of SGA while creating Database?
Is there any formula which will give me approximate size of SGA?
The database which I a...
Hi,
It's me again.
May I know how can we get the latest data from a table, for example
table labResult
itemID
labDate
labValue
custID
There is a lab itemID(such as BMI) is entered ...
