View is nothing but virtual table that means a query attach to view. Data is not storing the data into view and data is stored in tables. So you can not create...
p k s subrahmanyeswar...
bpkssrao@...
Jul 5, 2002 8:21 am
242
Why would anyone want to have an index on a view ? If it is got to do anything with performance, then you should consider tuning the query used to define the ...
Sudheendra Vijaykumar
sudhi76@...
Jul 5, 2002 8:25 am
243
Currently I have two databases system one is an sql server the other is oracle8i. All the data is in the oracle then we transfer whatever data we need to the...
Hi, Cud ypu pls look into this query. 1 update (select sd.oldCatCode SDoldCatcode , itm.oldCatCode itemCode 2 from gesynddetailstbl sd, 3...
vishakha@...
Jul 18, 2002 1:18 pm
245
Hi Vishakha, In your query line 1 to 10 has a multijoin view. In a multijoin view you can only update column from the key perserved table. Your view is...
Sameer Wadhwa
swadhwa@...
Jul 18, 2002 1:31 pm
246
Another way to find out is create a simple view as create or replace view samtestview as select sd.oldCatCode SDoldCatcode , itm.oldCatCode itemCode from...
Sameer Wadhwa
wadhwa_s@...
Jul 18, 2002 1:57 pm
247
Hi Experts, What will happen , if the size of transaction is larger then redo log file size. How Oracle handles this ? Any comments ? Thanks ...
Hi Sameer, First of all, thanks a lot for your reply. I can resolve this problem using instead of triggers. But for some reasons, we donot want to use...
vish
gvishakha@...
Jul 19, 2002 5:57 am
249
Hi Sameer, Vishka Just to clarifiy, does it mean than "Instead of " Triggers superseed to Non Key Preserved Coloumn? Pl. comment. Regards Vikas ... From:...
Vikas
vtandon@...
Jul 19, 2002 6:03 am
250
Hi John, From a logging point of view, every transaction is nothing but a set of changes made to the database. These changes are grouped logically in to...
Sudheendra Vijaykumar
sudhi76@...
Jul 19, 2002 10:52 pm
251
I am using Oracle 8i with intermedia text option. I have created a text index on the text column. When I try to query the column with the special charecters...
Sunil Mohite
sunilvmohite@...
Jul 24, 2002 11:40 am
253
Hi, If I remember correctly, I've never seen any rows in the "bonus" table right from oracle 7.x versions. Thanks, Sudhi. ... Looking for an easy way to get...
Sudheendra Vijaykumar
sudhi76@...
Jul 29, 2002 12:43 pm
254
Hi, I am new here. I have installed database in window 2000 by selecting typical installation. The Enterprise Manager Cofiguration Assistant doesn't...
Hi, I export 8i database to expdat.dmp file. I need to import this file to 9i database. I have created same users and grant same roles to the users. After I...
hi friends, I need some help on these topics. i have a oracle 8i db. where can i get all the sql help of oracle. some online books(downloadable if any)? 1> can...
Man! looks like you are on some serious fire!!! For starters try out www.orafaq.org Bharat. ... databases. ... steps? ... ...
bharat@...
Sep 9, 2002 8:11 am
262
Hi Guys, Can anyone redirect me on 'How to setup OEM on linux box 6.2/7.2' Thanks, Vishakha __________________________________________________ Do you Yahoo!? ...
vish
gvishakha@...
Sep 28, 2002 12:23 pm
263
hi techies thanks in advance. pls reply in brief q> what do u mean by distrubuted transaction? q> what is two phase commit? why is it called so? q> set...
Hi all, I am looking out for a suitable opening in a good/stable firm. I am Physics graduate from Mumbai University. I have approx 4 years of experience...
Dear Friends, I am doing a project over Internet Banking System. I need to move from form to form using a html link (hyperlink). I want that whenever i click a...
irfan kazi
irfan_a_kazi@...
Oct 29, 2002 5:02 am
266
oracle's ilt is availabaleand also sts software. these 2 r good enough for certification. solaris admin is good combination with 8i. i am here to assist u...
Khurram Shahzad Butt
ksbutt@...
Oct 30, 2002 8:16 am
267
Hi all, One of our developer is inserting a 1Gb of datafile without commiting a DATA. As LGWR copies commited and uncommitted data from redo log buffer to redo...
Hi Sameer,
DBWR will write both committed and uncommitted data to
the datafiles. When a commit is issued, then only the
buffers that were still lying around...
Sudheendra Vijaykumar
sudhi76@...
Nov 5, 2002 2:00 pm
269
DBWn writes only the committed records to the datafiles. The blocks having committed records are known as dirty blocks/Buffers. When checkpoint occurs or...
Sameer Wadhwa
swadhwa@...
Nov 5, 2002 4:53 pm
270
Is there a way of knowing the OS block size . Amith ... Do you Yahoo!? U2 on LAUNCH - Exclusive medley & videos from Greatest Hits CD...
Amith Uppal
uppal_amith@...
Nov 7, 2002 4:21 pm
271
Try This select max(l.lebsz) OSBLOCKSIZE from sys.x$kccle L / Hope it will help ... From: Amith Uppal [mailto:uppal_amith@...] Sent: Thursday, November...
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.
