Ave !
Set environment variable EDITOR=vi
Br.Jorma
-Original Message-
Sent: 13 September, 2003 10:09
To: Multiple recipients of list ORACLE-L
Dear Friends,
ed command in SQLPLUS( on UNIX ports )not working. I hope there is some
EDITOR setting to use VI editor, but forgot where to do
Ave !
If it's so, that user_a
like to use customer table and user_b customer_b
table with same
application, why You can't use synonyms? User_a synonyms
points to customer table
and user_b synonyms points customer_b table etc.
Or is there some decision
making before start using
Ave !
Is there any reason not to
keep maxextents always unlimited :) Extentsize should
be reasonable of
course.
Br.
Jorma
-Original Message-From: ext venkat Rama
[mailto:[EMAIL PROTECTED]Sent: 16 July, 2003 07:34To:
Multiple recipients of list ORACLE-LSubject: Rollback
Segs
Hi
Ave !
Here is one possible solution.
Create two tiny scripts. First script let say ex.sql which includes only
word exit and linefeed and second one cont.sql which has only one space
character, nothing else. Then in Your sql script:
--
column NAME noprint new_value SCRIPT_NAME
select
You should:
select sys_store_id.nextval from dual;
or similar to get a value from sequence.
Br.Jorma
Hallo,
I have this sequence,
CREATE SEQUENCE SYS_STORE_ID
START WITH 1
INCREMENT BY 1
NOMAXVALUE
NOCYCLE
CACHE 10;
I am trying to run this script,
Title: Error extensions in the alrtXXX.log
I think the only erros
which can exists in alert.og are ORA-
-Original Message-From: ext Denham Eva
[mailto:[EMAIL PROTECTED]]Sent: 24 January, 2003 11:04To:
Multiple recipients of list ORACLE-LSubject: Error extensions in the
alrtXXX.log
Ave !
How about something like:
delete from varukorgtmp where varutyp = 3 and EAN =
(select EAN from varukorgtmp a where rowid !=
(select min(rowid) from varukorgtmp b where a.EAN = b.EAN));
Should work, but not tested :)
Br.Jorma