I've finally managed to fit IOUG-A into my
timetable, after years of thinking that I really
ought to go some day.
I see from the 'University Class' listings that
no-one is doing anything about specific on
how the cost based optimizer works.
Two questions -
If I found some place in the locale t
Guys,
i know a bit of Linux.and not completely a newbie to Unix.
Can u suggest me a good/best book for Unix ?
..Unix for oracle DBA.
i.e,tuning unix for good performance of oracle.
any such book available ?
kindly let me know guys.
TIA.
Jp.
--
Please see the official ORACLE-L FAQ
Hi Murat Balkas,
1. Perhaps you want to play around with Oracle's sysdate from dual?
2. If I am you, I will prepare my sql script then using cron (unix) to execute it
(Windows has it's own version of scheduler program come with OS)
I believe most OS equip with scheduler program
Good luck.
Sin
Hi John Dunn,
My answer is never commit, Oracle will rollback.
Are you consider auto commit an implicitly commitment?
Sinardy
-Original Message-
Sent: 02 January 2003 22:14
To: Multiple recipients of list ORACLE-L
> Under what circumstances is a COMMIT done implicitly?
>
> If I cal
Hi All,
I want to avoid generation of archivelogs against all the DML applied
to some tables.
Thank you
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: GL2Z/ INF DBA BENLATRECHE
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.
www.samba.org
Raymond Lee Meng Hong wrote:
> Hi friend
>
> My colleuge after installing Application Server and my database in a red
> hat linux 7.3 and resign , It leave me no clue on configure a samba folder
> in application server.
>
>
> But i don't have any idea on configura those "folder"
The best method that I know is:
1) export from production.
2) drop user cascade in development or at least drop all tables.
3) create user in development.
4) import into development with indexes=n and constraint=n.
5) import again into development with rows = n and ignore = y.
Step 4 will build a
Hi Raja Kumar,
If you don't know what are the differences use the parameters touser and fromuser
During importation
Oracle will recreate those tables
I think if you not use the ignore = y you will get error message since Oracle cannot
insert due to different table structure
Just guessing
If
Hi Sony,
Commit will slow down your script. (I mean use the reasonable number of transactions
per commit)
Perhaps you can set your Rollback segment optimal value to null.
Your rollback will never shrink : )
Sinardy
-Original Message-
Sent: 06 January 2003 10:09
To: Multiple recipients
Hi,
I want to move ( insert into select and than delete from ) some
records of a table to another one at midnights. It would be very nice if it
has logging facility.
Do you have any good documantation about
* scheduled triggers
* executing time based queries using sqlplus
Thanks in
I have 2 8i database out of which one is production and the other is for
development and testing.
How can I update the data of the second one as the first one? tried import
but it didnt update the data nor capture some change made directly to the
table structure of the first ones.
Thanks
--
Pl
>- Original Message -
>From: "Sinardy Xing" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Sun, 05 Jan 2003 20:28:36
>
>Ha ha ha... but what is Chanukah?
>
Jewish Diwali :-)
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-
Chanukah is a Jewish holiday that is celebrated about the same time as
Christmas.
It depends on the differences between the Jewish calendar and the Christian
one.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, January 06,
101 - 113 of 113 matches
Mail list logo