We have Dell 8450 server machine with four processors. We would like to install Oracle Database. Do we have to purchase four processor licence or we can go for...
namaliq
namaliq@...
Feb 1, 2002 11:42 am
177
Since the Oracle will use the 4 processors, you will have to purchase for 4 CPU. It doesn't matter that another application resides on the machine. Unless you...
Hi Nadeem, You need to buy Oracle licenses for each of the processor that you use. Confirm with your oracle sales representative first before deploying oracle...
Hi Rajesh, Getting ora-1555 on large exports with 'CONSISTENT=Y' is common. The only way to guarantee that you will not get ora-1555 is to do the export when...
Hi Amith, Calculate the date for last day of each week thats saturday by the below formula. sysdate + 1 + ( 7 - to_char(sysdate+ 1,'D')) Thanks Jason ...
Hi, When user does A DML, the before image data goes to rollback segment and block becomes dirty with the changes. The block header keeps information of the...
Sameer Wadhwa
swadhwa@...
Feb 1, 2002 7:28 pm
182
Hi Experts, I am writing a article on ROLLBACK SEGMENT , following is a paragraph from it. Please let me know , if there is any issue or concern about this. ...
Sameer Wadhwa
swadhwa@...
Feb 1, 2002 8:11 pm
183
Hi : Thanks for Ans. New Question is that , How to findout lastday of Each Year. Regards - Parag...
Parag Mehta
paragrmehta@...
Feb 2, 2002 8:57 am
184
Hi Parag, I have posted the answer at Oracle DB Resources http://oracle.dbresources.com/modules.php? op=modload&name=XForum&file=viewthread&tid=27 Thanks Jason...
Hi : Please Solve the Foll Qeury. I have Two Table with Foll Data. Table A ====== No Name ... 1 XYZ Table B ======== No Name ...
Parag Mehta
paragrmehta@...
Feb 4, 2002 7:15 am
186
Follow this : 1. Get the trace of the control file . -> alter database backup controlfile to trace; 2. Shutdown the current database . 3. Change the...
Amith Uppal
auppal@...
Feb 4, 2002 4:57 pm
187
Solution is: Select a.no,decode(b.name,'PQR','NULL',a.name),b.name from a,b where b.no=a.no ... From: Parag Mehta To: OraTechSupportGroup@yahoogroups.com Sent:...
Yahoo
bpkssrao@...
Feb 5, 2002 3:56 am
188
Hi All, Does any one getting this error Oracle server 8.1.6.3.0 Intermedia I found a error in trace file as follows :- ORA-12012: error on auto execute of job...
Sameer Wadhwa
swadhwa@...
Feb 5, 2002 2:49 pm
189
Hi, The question is not clear enough or it has been answered by the questioner itself. When a data block undergoes modification, the undo block does store the...
Sudheendra Vijaykumar
sudhi76@...
Feb 6, 2002 1:49 pm
190
Hi sudhi, Thanks for the feedback and sorry for grammer and spelling mistakes . I rewrited it again , let me know your comments I am trying to explain the...
I'm wondering if it's possible to set up the time Oracle (I've got Oracle 8i 8.1.6.3.0 64 bit on AIX) waits before stopping a transaction which is deadlocked...
Hi: I am installing oracle 8.1.7 on a solaris 8 box. I am getting ORA-03114 ( not connected to ORACLE) error message when the installer tries to create a...
lawrelu3
lawrelu3@...
Feb 22, 2002 12:22 am
194
Try looking in alert log. ... Da: lawrelu3 [mailto:lawrelu3@...] Inviato: giovedě 21 febbraio 2002 22.19 A: OraTechSupportGroup@yahoogroups.com Oggetto:...
Hi All I have cold backup of a Oracle 7.3.4.5.0 and want to restore into a different database on same oracle version. In Oracle 8i, I have been doing very...
Hi Dear DBA's, I'm working for Adobe Systems and I was contacted by oracle sales guy's that we'll be audited by oracle tech's on our usage of oracle products....
Rajinder Gaur
Rgaur@...
Feb 28, 2002 6:10 pm
197
Can you help me .. I don't know toally the reason this error happened! I use refcursor type. the stored procedure works perfectly. error messages is.. ...
yakim73
yakim73@...
Mar 4, 2002 1:29 am
198
Hello, would anybody know a method to copy data between a O7 and a O8 databases faster than the sqlplus "copy" command ? (excluding sql*loader, export &...
brphi
brphi@...
Mar 6, 2002 9:22 pm
199
Have you tried "create table A as select * from table B" over a datalink? Katherine Harms "brphi" <brphi@.... To:...
Katherine Harms
kharms@...
Mar 6, 2002 11:37 pm
200
Hi, I am having SMTP in and out IPs. Using SMTP-OUT IP i am able to send the mails successfully.But i need to check the mails that are sent to a particular...
I want to insert list of control chars thru a INSERT query. How can one do that? Thru sqlloader its possible. Create table t ( X NUMBER Y VARCHAR2(5)); I want...
Hello everyone. Excuse me for interrupting your discussions, but I just want to let you know we distribute mail magazine dedicated to Oracle users. This mail...
Yuka Iwanaga
ca94102@...
Mar 20, 2002 2:40 am
204
Clear DayDo you want to pass oracle exams? If your answer is yes then you have find what you need!! Hi friends! Interested in passing ORACLE CERTIFIED DATABASE...
johan
johan8johan@...
Mar 21, 2002 7:37 pm
205
Hi, Can you please add my e-mail id in this group? Thanks, Thatchin __________________________________________________ Do You Yahoo!? Yahoo! Movies - coverage...
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.
