Hi Amith , Sorry for delay in responding. if the tablespace is dictionary managed and you have a objects in it, having various extent sizes. You might have a...
Sameer Wadhwa
swadhwa@...
Dec 4, 2002 7:22 pm
293
We would like to introduce ourselves as Skots Consultants, a professionally managed company specializes in Executive Search and Selection. We have a team of...
We would like to introduce ourselves as Skots Consultants, a professionally managed company specializes in Executive Search and Selection. We have a team of...
Hi, We r from an IT placement company called Talent Search Inc having offices in Chennai, Bangalore and associates in US and Singapore. We work with many...
Hi Ramesh, ... Thats because we don't want Oracle to hang if the archiver process takes a long time to archive. LGWR shouldn't be waiting to write to the redo...
Sudheendra Vijaykumar
sudhi76@...
Dec 20, 2002 6:56 am
298
Hi Sudhi, The concept of archiving comes only when the database is in archive mode. If the database is in noarchive mode why two online redo's why not one for...
Hi Ramesh, I was expecting the 'noarchivelog mode' comment, but was too lazy to write in it. The threat of running in noarchivelog mode is far too much to risk...
Sudheendra Vijaykumar
sudhi76@...
Dec 20, 2002 8:18 am
300
Hi Sudhi, Thanks for the comments. I am still confused with something? This was an internview question whether to have "two or more" or one log file group in...
Hi Ramesh, Yeah. thats correct of saying that Oracle should have imposed the min of 2 log groups when running in archivelog mode. But, hey thats the way they...
Sudheendra Vijaykumar
sudhi76@...
Dec 20, 2002 9:27 am
302
Hi Sudhi, Thanx for the information. Regards, Ramesh...
Hi all, I am currently assisting in the migration of our database from SQL Server 2000 to Oracle 9i. My question is: is there any way to migrate the stored...
bllack_nite <bllack_n...
bllack_nite@...
Jan 23, 2003 8:25 am
304
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!...
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.
