I installed Oracle 9i (Win2000) but decided to delete it and re-install 8i. I have gone through the Universal Installer to uninstall 9i, physically deleted...
Hi You might be trying to install Oracle 8i on Pentium 4 processor. Please refer Note:131299.1 on Metalink. Unfortunately, cut and paste did not work from...
Hi Experts, I am working on a project, in which I need to read from flat file & also create a comma/space delimited flat file output. I saw somewhere that a...
X Y
arora_rajesh@...
Mar 11, 2003 2:48 am
307
Hi Rajesh, With the help of UTL_FILE you can read a flat file and also write a output to OS by simply putting a logic of comma delimited. Flat file can be...
Sameer Wadhwa
swadhwa@...
Mar 11, 2003 2:17 pm
308
Hi All, We are an IT services firm providing technology solutions to a diverse customer base in the Americas and in Europe. As a part of our service offerings,...
how should i get the timestamp i.e when i have inserted a row into a table, my table is not having any date field in it. my database is in no archive mode, i...
mail2petluri
mail2petluri@...
Mar 13, 2003 12:15 pm
311
I have data in one of the table as X Y 1 xxxx 1 yyyy 1 zzzz 1 aaaaa 0 bbbbb 0 ccccc 0 ddddd 0 eeeee 1 fffff 1 fffff 1 fffff Which composite index...
Hi, I'm a new oracle user. I am actually a GIS specialist by profession. I would like to house spatial data in oracle. But I don't want to use 3rd party GIS...
According to me , y+x will be a better option . Your Y column has more distinct data and so that should be the prefix column . Since u r trying to create a...
Amith Uppal
uppal_amith@...
Mar 17, 2003 11:52 am
314
I've used mapinfo, I've read the Oracle documentation, and loaded spatial data; but I'm not expert. However, what I do know is that the trick is to properly...
Hi Experts, I am executin dbms_profile to see the the performance of one of stored procedure. The stored procedure took 3 min to complete it execution, but...
I am OCP 8i DBA and am looking for Power POint Presentations for Data base architecture and administration. Will appreciate if you can direct me to the right...
Hi All I need Your Help please I am trying to install oracle 8.1.7.0 at sun Solaris for Intel when I Run the /install/Solaris/runInstaller it's tell me please...
Go to DBSpecialists.com and download their hite paper for installing Oracle 9i on Solaris. It works. Or else go to OTN.oracle.com and download instructions...
hello, i am having a problem and not able to connect to oracle when i try to connect it gives the message ORA-01092 Oracle instance terminated .disconnection...
Hi Pavan, What are the error in the alert and trace file. Sameer ... From: pavanpatidar [mailto:pavanpatidar@...] Sent: Wednesday, April 16, 2003 3:14 AM...
Sameer Wadhwa
swadhwa@...
Apr 16, 2003 1:33 pm
327
i want to run oracle reports from a Java Frame. How can i do that ? regards Ahsen Saeed ... Do you Yahoo!? The New Yahoo!...
Hi Saeed, Refer the book Oracle web 101 for step by step instructions. Sameer ... From: Ahsen Saeed [mailto:ahsensaeed2003@...] Sent: Wednesday, April...
Sameer Wadhwa
swadhwa@...
Apr 30, 2003 1:24 pm
330
Hello all, In Oracle Report I want to print Labels in Last Page of the report ,Which should print the labels in same area in all Reports.When I keep Labels...
Hi !I have some questions regarding Oracle Reports. Please reply if you know. a) How can we call oracle reports from a Java Frame ?b) Can we send an oracle...
This is not a job, but an answer for some of us that used to have a 9 to 5 full time job In Corporate America with full health care benefit and more. However,...
Hi All ! IS there a way to check the validity of the archive log files . Like we can use db_verify to check for the validity of the data files . What about for...
Amith Uppal
uppal_amith@...
May 13, 2003 6:52 am
335
Hi Amith, I think, RMAN will check the validity of archive logs files while backup. Thanks Sameer ... From: Amith Uppal [mailto:uppal_amith@...] Sent:...
Sameer Wadhwa
swadhwa@...
May 13, 2003 2:00 pm
336
Hi Amith, I think, you can use db_block_checksum = true to ensure , the corruption is detected at the time of creation of archive log files, as well as...
Rajesh Arora
arora_rajesh@...
May 13, 2003 2:24 pm
337
Hi All ! In unix shell scripting , even if we prompt for username / password , it will still display in the ps command . I need a way to get rid of this . I...
Amith Uppal
uppal_amith@...
May 14, 2003 11:57 am
338
If I undestand you correctly, you are prompting for user/pass at the shell script level and passing them to SQLPlus. Instead of read USER read PASS sqlplus...
Hi Amith, Here is a script I saved long time ago. Take a look at it. It should hide the arguments passed to sqlplus(including username/password), & hides it...
Rajesh Arora
arora_rajesh@...
May 14, 2003 2:03 pm
340
Hi all ! That was very helpfull ! Amith Rajesh Arora <arora_rajesh@...> wrote: Hi Amith, Here is a script I saved long time ago. Take a look at it. It...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
