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
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
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
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
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
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
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
, 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
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
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
10 matches
Mail list logo