Try this link:
http://math.about.com/science/math/library/howto/htmean.htm
Jared
On Saturday 30 June 2001 19:00, MacGregor, Ian A. wrote:
> I ran the code from Oracle SQL 101 which Jared posted modifying it to find
> the median of the sal column on that table
>
> SQL> select
> 2 rownum,
>
hi,
In linux it is bash shell and you have to change you bash_profile of oracle and
not the .profile file. check that out
Csillag Zsolt wrote:
> Hi,
>
> Since I'd like to install Oracle for Linux, I need to change the profile for
> user 'oracle'.
>
> I edited the .profile file located in /home
Title: RE: temp problem when rebuilding Index
This will have to be decided based on the key fields for the index. You will have to arrive at an approximate value and increase temp accordingly.
rgds
amar
-Original Message-
From: Gregory Conron [mailto:[EMAIL PROTECTED]]
Sent: Sunday
also, try man bash (or whatever your shell is). It will explain what
files are sourced under which circumstances.
george
On Saturday, June 30, 2001, at 01:20 PM, Gregory Conron wrote:
> On June 30, 2001 01:30 pm, Csillag Zsolt wrote:
>> Hi,
>>
>> Since I'd like to install Oracle for Linux, I
I ran the code from Oracle SQL 101 which Jared posted modifying it to find the median
of the sal column on that table
SQL> select
2 rownum,
3 sal
4 from (
5 select sal
6 from scott.emp
7 where sal is not null
8 union
9 select 1 from dual where 1=2
10 )
11 gro
On June 30, 2001 08:30 pm, Raghu Kota wrote:
> Yeah I can't do parition, I think I have increase TEMP. But How
> much can I increase?? Is there any measurement?? Thanks to all
> responses.
How much free disk space do you have? If your index is 6gigs, you
will need a like amount of temp space to
Hmmm, it is just me or did everyone get the same message multiple times (like ten or
more)?
>>> [EMAIL PROTECTED] 06/29/01 05:02PM >>>
Folks,
Have a question regarding sizing raw volumes and
Oracle datafiles. I'm using Veritas 3.1, Solaris 2.6
and Oracle 8i (R2)
This is what I did. Using Vol
What shell are you using? Different shell uses different startup filename.
If you are using bash, then it's .bashrc
>>> [EMAIL PROTECTED] 06/30/01 12:30PM >>>
Hi,
Since I'd like to install Oracle for Linux, I need to change the profile for
user 'oracle'.
I edited the .profile file located in /
Yeah I can't do parition, I think I have increase TEMP. But How much can I
increase?? Is there any measurement?? Thanks to all responses.
>From: Gregory Conron <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: temp probl
On June 30, 2001 06:35 pm, Raghu Kota wrote:
> Hi Friends
>
> Iam rebuilding my 6Gb index, But Iam getting problem with TEMP
> tablespace. What is solution for this??
>
> iam using alter index index_name rebuild tablespace_name;
>
> ORA-1652: unable to extend temp segment by 128 in tablespace
You can drop the index and recreate it again, it would be faster and would
need less space
Ramón Estévez
*809-565-3121 x 225
* [EMAIL PROTECTED]
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Raghu Kota
Enviado el: Saturday, 30 June, 2001 4:36
Hi Friends
Iam rebuilding my 6Gb index, But Iam getting problem with TEMP tablespace.
What is solution for this??
iam using alter index index_name rebuild tablespace_name;
ORA-1652: unable to extend temp segment by 128 in tablespaceTEMP
Any Ideas??
Thanks
Raghu.
_
Is there a way to do what would be an ALTER SYNONYM?
I've got a synonym created that rotates between pointing to two different
tables. Sometimes it points to TABLE_A, sometimes to TABLE_B. (This is
so that behind the scenes, I can truncate and reload TABLE_A, and then
swap, etc. so the table "n
i'm w/jared, i've yet to get "unattended" install to work.
joe
Jared Still wrote:
>
> Oliver,
>
> Have you actually seen the non-interactive setup work?
>
> I've tried, no go.
>
> I'll try scp when I can get non-interactive to work.
>
> Jared
>
> On Friday 29 June 2001 10:53, Oliver Artelt
Oliver,
Have you actually seen the non-interactive setup work?
I've tried, no go.
I'll try scp when I can get non-interactive to work.
Jared
On Friday 29 June 2001 10:53, Oliver Artelt wrote:
> Hi,
>
> read the chapter 'Non-Interactive Installation and Configuration' in your
> platform-depe
What version of database?
On Wednesday 27 June 2001 04:20, Csillag Zsolt wrote:
> Hi,
>
> In the following select statement I have a function "GetSid" that slows the
> update for hours even if the Link_keszit updatable table consists of a few
> rows.
>
> Update UpdateTable--Varosokat updatel
Title: RE: ADMIN: Results of voting
Sorry listers. THat was supposed to go to Ashoke directly and not to the list. I forgot to paste the email address...
--Chris
[EMAIL PROTECTED]
-Original Message-
From: ASHOKE MANDAL [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 30, 2001 2
Title: RE: ADMIN: Results of voting
The vote was about whether or not you could go to the fatcity.com site where the list was hosted and get the subscriber list or not. 44 said to remove the list since hackers and virus planters can get the list and use it against you. 6 (myself included) sa
On June 30, 2001 01:30 pm, Csillag Zsolt wrote:
> Hi,
>
> Since I'd like to install Oracle for Linux, I need to change the
> profile for user 'oracle'.
>
> I edited the .profile file located in /home/oracle folder but it
> seems to me that this isn't the file that Linux loads at startup.
Take a l
Hi,
Since I'd like to install Oracle for Linux, I need to change the profile for
user 'oracle'.
I edited the .profile file located in /home/oracle folder but it seems to me
that this isn't the file that Linux loads at startup.
T.I.A.
Zsolt Csillag,
Hungary
--
Please see the official ORACLE-
test.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajesh Dayal
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
21 matches
Mail list logo