Mladen,
Thanks for your input. Yes, I also rebuilt all relevant indexes with
nologging option so no normal redo genearation either. However, the table
was moved into LMT tbs from a dictionery managed tbs.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
That's because nologging attribute only affects the direct
operations, i.e. the the operations that prebuild blocks and add
them below the flood watermark. That includes sqlloader with direct=y,
inserts with /*+ append */ hint and CTAS. Normal SQL based operations
are not affected.
On
In addition to operations provided in Mladen's explanation, all partitioning
operations such as exchange/split.. partition, etc. do not generate data
related redo for segments marked nologging.
HTH.
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
So how do I turn logging to YES on the index?
-Original Message-
Sent: Wednesday, October 22, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L
In addition to operations provided in Mladen's explanation, all partitioning
operations such as exchange/split.. partition, etc. do not
A quick look at the docs for 'alter index' will reveal all.
Roger Xu [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/22/2003 04:05 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: questions regarding
Alter table ...Move TS nologging
is 100% equivalent to CTAS and should generate minimal amount of logging
even if it ran serially (no PQ).
Actually the type of command is considered CREATE TABLE
So I'm not sure how the original poster was able to determine that the
operation generated huge
Waleed,
I agree with you as I moved a 5GB table last week with nologging option with
extent size 500M and did not see any normal redo generation for that. It is
8.1.7.0 database. that table has 8 indexes for total size of almost 3GB.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple
No need to say yes(not a valid option either) as logging is default.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 22 Oct 2003 15:05:05 -0800
So how do I turn logging to YES on the index?
-Original Message-
Sent:
Well, Rafiq, when you move the table, indexes are marked stale, which means
that you must rebuild them. Marking indexes unusable shouldn't generate any
redo log, except for the dictionary block that was altered. Other then that,
moving table is an opration roughly analogous to CTAS and I
Yes, but you may not get any answers.
On Friday 04 July 2003 00:59, purushottam krishna hegde wrote:
hi all,
can i post questions on java and j2ee PF here?
waiting for +ve response for all of u
thanking all
purushottam hegde
-
Do you Yahoo!?
SBC
best pl,ace ive seen for java questions are the
sun.com forums.
- Original Message -
From:
purushottam krishna hegde
To: Multiple recipients of list ORACLE-L
Sent: Friday, July 04, 2003 3:59 AM
Subject: Questions on java
hi all,
can i post questions on
Hi!
IMO, better not to ask offtopic questions, since this is a mailinglist
there's no possibility to fine-grained control which mails hit our
mailboxes.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, July 04, 2003 12:59 PM
Yes,
You are trying to insert a row that contains values that already exist in
the table, and there is a constraint on the table that says the values for
the row(s) must be unique.
Now about that column BONGID ... What are you smoking?
-Original Message-
Hallo,
I get this
This message is telling you that your insert violates the
primary key constraint for the table. This means that the
primary key, KUNHOD_TMP1_ID, value in your inserted record already
exists in the table.
HTH,
Peter Schauss
-Original Message-
Sent: Wednesday, March 19, 2003 4:16 AM
To:
-Original Message-
From: John Dunn [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 12:04 AM
To: Multiple recipients of list ORACLE-L
Subject: Questions for Oracle list
Question 1)
I've got a update trigger on a table that updates a record in another
dba_stmt_audit_opts
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 27, 2002 8:58 AM
Other than keeping a pencil and paper record of currently active AUDIT
statements, is this information held anywhere in ORACLE? That is, is
Hi Paul,
Check out:
DBA_OBJ_AUDIT_OPTS
DBA_PRIV_AUDIT_OPTS
DBA_STMT_AUDIT_OPTS
Not sure on the rest of your mail (due to not actually having used auditing
in earnest ;P) but I'm sure the rest of the list can help out with that..
HTH
Mark
-Original Message-
Vincent
Sent: 27 March
Here's my all purpose 'Where the heck is that and what is it called?' sql
script.
I find it quite useful for times when I think theres an object in the
database that I
want to see, but am not quite sure about it's name.
Jared
e.g. @finobj audit
-- findobj.sql
col cobject noprint new_value
Hi Dick and Bjørn,
Thank you for your comments. It seems to me that db design in a J2EE environemnt is
not much different to non J2EE environment. A few interviewees gave this reply and
basically I agree with them. Since many Web applciation these days use
Java I guess that large number of
You clearly also need to ask these persons about application design.
Together with the database design, poor application design is the
source of countless performance problems. The good application
developer is fully aware of how Oracle handles SQL statemens, how he
should and should not
dba_ind_expressions
-Original Message-
From: Cyril Thankappan [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 8:25 AM
To: Multiple recipients of list ORACLE-L
Subject: Questions
Hello Listers,
I have a couple of questions.
1. Is there 'some way' (from the
Rachel,
Wasn't talking about you. Let's just say it's a Financial firm with offices
in Merrimack NH. Almost went to work for them, glad I did not!!
Dick Goulet
Reply Separator
Author: Rachel Carmichael [EMAIL PROTECTED]
Date: 7/19/2001 1:55
Rachel folks, fyi:
--- Forwarded message follows ---
...
This is the summer of Win2000 and Developer6i/Oracle8i training
I went nomail for vacation a while ago (and then family sick
leave when my kids, 3 years and 7 years old, got summer
colds/asthma), and didn't go back on the
Wednesday, July 18, 2001, 9:06:20 PM, Chuan Zhang wrote:
CZ What are the benifits of having a support contract?
All joking aside, I wouldn't want to manage a database
without having a support contract. With support, you have
something to fall back on when you can't solve a problem
yourself.
Title: RE: Questions about Oracle World Wide Support
Chuan,
Without a support contract you better hope that you can get yourself out of every single recovery disaster that can possibly happen. If your data isn't important, then don't purchase a support contract. If you know everything
Turn the question around, and ask what are the difficulties you will
face if you *aren't* supported?
Some answers:
1) no help from Oracle Support for installation,bugs,problems,etc
2) no product media
If you don't need either of those from Oracle support, then you could
save some money.
Eric,
Where you been Welcome back.
Be aware that if you do not pay for continuing support, and then you
later (years later) decide you need a suport contract again *for the
platform you started on*, Oracle has been known to retroactively
charge (at a percentage at least 50%?) for the years
Meng Fangtao
m.fangtao@geneTo: Multiple recipients of list
ORACLE-L
Oh Mitchell,
You have to set s-bit permission should be 6755 --something like that.When
user updates a record he is ultimately writing to datafiles.At that time
he should assume as file-owner.That means only thru sqlplus or thru some other
application only he can write to the file,Neither he
DBAs
Whis is right security for oracle datafile. 640 or 777 or others.
I found today in my AIX that some oracle datafile is 777 or some are 660.
But when I chmod 644 for those 777 files. The user could not do update and I
had to change back. what is wrong
How about sys file. Mine is 666
, February 23, 2001 1:32 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: questions: security on the unix
DBAs
Whis is right security for oracle datafile. 640 or 777 or others.
I found today in my AIX that some oracle datafile is 777 or
some are 660.
But when I chmod 644 for those 777
]
-Original Message-
From: Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 1:32 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: questions: security on the unix
DBAs
Whis is right security for oracle datafile. 640 or 777 or others.
I
Thanks Brian.
It is very strang. I have two database on 2 nodes.
db1, one instance all 640 for datafile.
db2 2 databases. that I have change the test database for 640. the error
message said the datafile premittion error.
owner is oracle:dba
Mitchell
Are you set uid all
33 matches
Mail list logo