OraTechSupportGroup : Messages : 221-250 of 457

Messages: Simplify \| Expand (Group by Topic)		Author	Sort by Date

221	Hi all! I'm trying to install 8i on RedHat Linux 7.0. I've tried everything (that I could find on the internet), but have not been successful. I even...	hyderabadee	May 2, 2002 4:05 pm
222	1. Check which version of glibc u have on ur system? rpm -qa \| grep libc 2.install the following 3 RPM's compat-glibc-6.2-2.1.3.2.i386.rpm ...	vish gvishakha@...	May 3, 2002 5:51 am
223	Dear Friends Alter table <table_name> Move tablespace <tablespace_name>; Using this command, moved all tables to another tablespace except one which is having...	p k s subrahmanyeswar... bpkssrao@...	May 3, 2002 11:31 am
224	Create the following procedure: procedure move_tablespace ( p_table_name varchar2, p_tablespace_name varchar2, p_index_tablespace varchar2 default...	vr_bala	May 3, 2002 1:12 pm
225	Thanks, Vishakha, for your response. Actually, I got the database creation to work after I posted my "mayday" on this group. I went back to the installation...	hyderabadee	May 3, 2002 2:26 pm
226	Vishakha, the webpage at the URL you mention talks about installing oracle 8i on RH 7.1 and RH 7.2, not on RH 7.0. -svp...	hyderabadee	May 3, 2002 7:18 pm
227	If you don't want the table / data use the following command. DROP TABALESPACE <tablespace_name> INCLUDING CONTENTS; Suppose you want to drop the tablespace...	Ramesh Prashanth ramesh@...	May 6, 2002 5:33 am
228	hi dear, May be this will help you: http://www.palslib.com/Oracle/Installation.html hths Vishakha ... ...	vish gvishakha@...	May 6, 2002 7:04 am
229	Thanks, Vishakha, but I don't need it anymore. Like I described in http://groups.yahoo.com/group/OraTechSupportGroup/message/225 , I've installed Oracle 8i on...	hyderabadee	May 6, 2002 4:02 pm
230	Limitations of the "ALTER TABLE MOVE" Command: * Supported only in Oracle 8.1.5 and higher * Does not support directly some objects and some data types: *...	Ramesh Prashanth ramesh@...	May 9, 2002 2:41 pm
231	Hi, I came accross a set for Oracle8i paper 1Z0-001. If any body want its sample set you can contact vaikunthus@.... They are giving few questions for...	mike jhonson mike_john_74	May 15, 2002 3:59 am
232	How to drop multiple column from the table. I tried the following syntax but it did not work ALTER TABLE <TABLE NAME> DROP COLUMN (<COLUMN1>,<COLUMN2>); I am...	john reuna dbajohn2001	May 28, 2002 3:23 pm
233	Oracle does't support dropping multiple columns. It is not a bug. But you can overwrite using the following procedure my_drop. /* Created by Balasubramanian.R ...	vr_bala	May 28, 2002 5:25 pm
234	Hi Oracle provide us this functionality Or9i SamSQL>desc emptab Name Null? Type ... EMPID...	Sameer Wadhwa swadhwa@...	May 28, 2002 6:06 pm
235	hi, I am getting one EOF communication error. In the following query when i comment out "AND v1.categoryId =63089" the query runs but uncommenting fires ...	vishakha@...	May 30, 2002 10:42 am
236	Are you using index with desc option ? ... Da: vishakha@... [mailto:vishakha@...] Inviato: gioved� 30 maggio 2002 14.06 A:...	lavezzi.ivan@... livans	May 30, 2002 10:54 am
237	Is is possible to create an index on a view? Thanks, Randy Scott rscott@... Austin Data Center 1300 South Mopac Expressway Austin, TX 78746 Phone:...	Scott, Randy (TIFPC) useme1	May 31, 2002 1:22 pm
238	hi Experts, I enabled the logminar which cause a v$logminer_contents to a millions of row. How do i clean up this view it is talking so much time to query. ...	john reuna dbajohn2001	May 31, 2002 7:31 pm
239	no i am not using index with desc clause. The problem got solved when i took export/import at user level. The export at table level also didnt resolve it. It...	vish gvishakha@...	Jun 7, 2002 3:08 pm
240	Hi, We can create index on view. We will get the error ORA-01702. Bala...	vr_bala	Jul 5, 2002 3:31 am
241	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...	GPP2	Jul 11, 2002 1:05 pm
244	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 ...	john reuna dbajohn2001	Jul 18, 2002 4:17 pm
248	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

Yahoo! Groups Tips

Did you know...

Messages

Yahoo! My Yahoo! Mail
	Sign In New User? Sign Up
		Tech - Groups - Help

Yahoo! Groups Tips

Did you know...

Best of Y! Groups

Messages