Errormessage

2001-10-23 Thread Roland . Skoldblom
Hallo I run this select statement and get this errormessage. What should I do to solve it? I have a databaselink from the actual schema to another schema. SELECT RIK2.VARE.EAN_NR, RIK2.VARE.LEVNR, RIK2.ART_HIERARKI_CALC.VGR, RIK2.VARE.SORTIMENT

RE: Errormessage

2001-10-23 Thread Robertson Lee - lerobe
statement and get this errormessage. What should I do to solve it? I have a databaselink from the actual schema to another schema. SELECT RIK2.VARE.EAN_NR, RIK2.VARE.LEVNR, RIK2.ART_HIERARKI_CALC.VGR, RIK2.VARE.SORTIMENT, RIK2.VARE.VARENAVN FROM RIK2.VARE, RIK2

Re: Errormessage

2001-10-23 Thread Mandar Shete
Hi Roland, check if your temp tablespace is getting filled up (look at dba_free_space, v$sort_segment, v$sort_usage). Are you getting any other messages with this one ? Mandar. [EMAIL PROTECTED] wrote: Hallo I run this select statement and get this errormessage. What should I do

RE: Errormessage

2001-10-23 Thread Jeroen van Sluisdam
ORACLE-L Onderwerp: Errormessage Hallo I run this select statement and get this errormessage. What should I do to solve it? I have a databaselink from the actual schema to another schema. SELECT RIK2.VARE.EAN_NR, RIK2.VARE.LEVNR, RIK2.ART_HIERARKI_CALC.VGR

Re: Errormessage

2001-10-23 Thread C.S.Venkata Subramanian
temp default storage(next 3M); this sql stmt will alter the temp tablespace's next extent from default value to 3Megs. HTH Venkat -- On Tue, 23 Oct 2001 00:10:19 Roland.Skoldblom wrote: Hallo I run this select statement and get this errormessage. What should I do to solve it? I have

Errormessage

2001-10-19 Thread Roland . Skoldblom
Hallo, what does this errormessage mean. I get it when i try to do this select statement. If I dont include the last two lines in the statement it works fine. What does this depend on? and which action shallI do to make it work? SELECT RIK2.VARE.EAN_NR, RIK2.VARE.LEVNR

RE: Errormessage

2001-10-19 Thread Mohan, Ross
Let me guess that tablespace 3 is your temporary tablespace? -Original Message- Sent: Friday, October 19, 2001 12:00 PM To: Multiple recipients of list ORACLE-L Hallo, what does this errormessage mean. I get it when i try to do this select statement. If I dont include the last

RE: Errormessage

2001-10-19 Thread Deepak Thapliyal
, Ross [EMAIL PROTECTED] wrote: Let me guess that tablespace 3 is your temporary tablespace? -Original Message- Sent: Friday, October 19, 2001 12:00 PM To: Multiple recipients of list ORACLE-L Hallo, what does this errormessage mean. I get it when i try to do this select

Re: Errormessage

2001-10-19 Thread Ruth Gramolini
Hallo, what does this errormessage mean. I get it when i try to do this select statement. If I dont include the last two lines in the statement it works fine. What does this depend on? and which action shallI do to make it work? SELECT RIK2.VARE.EAN_NR, RIK2.VARE.LEVNR, RIK2

RE: Errormessage

2001-10-19 Thread Jacques Kilchoer
Title: RE: Errormessage see answer below -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] what does this errormessage mean. I get it when i try to do this select statement. If I dont include the last two lines in the statement it works fine. What does