And make sure all your indexes are local."M.Godlewski" <[EMAIL PROTECTED]> wrote:
Alternatively you could create the table based on a time_key and map that to the time table. Then the partitions key could change meaning as the years go by.
i.e. time_key 1 = January of 2004
time_key 2 = Fe
Did you try copying a junk file to it. dd if= of=
:) did not think corrupting something would be a problem. "Bellow, Bambi" <[EMAIL PROTECTED]> wrote:
WOW! There's something you don't hear everyday, Chauncy!How aboutecho "Mary had a little lamb" > /dev/rdsk/-Original Message-Sent: Friday
Did you try copying a junk file to it. dd if= of=
:) did not think corrupting something would be a problem. "Bellow, Bambi" <[EMAIL PROTECTED]> wrote:
WOW! There's something you don't hear everyday, Chauncy!How aboutecho "Mary had a little lamb" > /dev/rdsk/-Original Message-Sent: Frida
Do you have cursor_sharing set?
Long term : Have the developers use bind variables. Short term identify the sql doing the most damage by looking at sql being reparsed etc. Fix them to use bind variables if possible.
About alert.log some errors go to alert.log some errors do not.
Do you have
Do you have primary keys etc and hint file? Also do you have constraints disabled. Some "Nelson, Allan" <[EMAIL PROTECTED]> wrote:
Since the results of triggers firing in the source will appear in thelog files, then in general you do not want the same triggers firing inthe target. Similarly since d
Did you check if it is a privilege issue because the access privilege is granted thru a role. roles are not recognised in PL/SQLHemant K Chitale <[EMAIL PROTECTED]> wrote:
I face this peculiar behaviour when I connect from my 9.2.0.1/Tru64 databaseto a 9.2.0.4/Solaris [upgraded from 9.2.0.1 to 9.2.
Just FYI : Quotes do not mean anything here. Quotes are generally used to create lowercase objects. Without quotes everything is converted to uppercase. "Virk, Istifad" <[EMAIL PROTECTED]> wrote:
Try compiling without the quotes around the package name:CREATE OR REPLACE PACKAGE XYZ_PKG-Original
Maybe from service_name in init ora file. David Wagoner <[EMAIL PROTECTED]> wrote:
You might get some surprising results from SELECT ORA_DATABASE_NAME FROM DUAL; (see below). I have a DEV database cloned from Prod. and it still lists the Prod. DB name with that query. Where is it reading the na
Did you check if there are any triggers on table order_master_sts_log? Are there any foreign keys that might lead back to 'select lookup' the initial table order_master
Good luck.Gary Jackson <[EMAIL PROTECTED]> wrote:
Hello,I have a moderate size 8.0.4 database that has been running perfectly for
You can ofcourse use enterprise manager. You would have to get the body and other things like triggering event etc.
To use the "Show SQL" option : one trick to use is a space some place (basically non-change) and hit "Show SQL". That should give you the whole trigger sql. Good luck.
* Jared :
You can use view all_triggers or user_triggers to get the entire text. trigger_body has the trigger text. triggering_event, trigger_type , REFERENCING_NAMES etc have other details. You can also use enterprise manager to get it. One trick in enterprise manager is to add some spaces somewhere (a no
1) You would need less network bandwidth with shareplex than you would for transporting archive logs. about 1/3 rd of what you would need for physical stdby.
2) CPU burden would be 'little' I guess.
3) Shareplex replication allows you to have the table available for read on the target. (even up
Point noted. Excellent posts from both you and Walt. I guess that is what the forum is for. To present one's experience without trashing someone else's point of view.
Since you have first hand experience on the latest I guess John should listen to both of you first. Thanks
"Jesse, Rich" <[EM
Hi,
No. I recommend that you do not change cursor_sharing if you are doing it just to get rid of 4031. There could be serious problems. ora-600 etc. Maybe Oracle has fixed everything in latest 817 but I suggest not to take that chance.
For 4031 you can do the following : pin pl/sql sql preferab
Just one more step :
Before you import. You also have to reduce or make zero the quota of this user on 'system' tablespace. I do not know if zero works. and make sure the user does not have 'unlimited tablespace' priv implicitly or explicitly , either directly or thru a role.
Because when you i
Even if the default tablespace for user is other than 'SYSTEM' question is :
Where does the data from anlyze go? To some catalog table? What you can do is :
1) Check if 'SYSTEM' has any other user non-system/sys user objects. Move them away. I do not know if moving system objects out of 'system
bin laden : you are right about drink and cd but now a days they tell you to open a metalink tar. unless this is production.
seriously : is nfs mounted volume supported. on nt it does not recognize non local drives. Mladen Gogala <[EMAIL PROTECTED]> wrote:
Get a drink, put some nice CD in th
Related question would be : If in a composite index of 6 fields if the second column is null then would it be able to use the index for the rest of the four columns. How would it handle that. Assumption : First column is not null which would make it choose the index.
IS it possible that somethi
18 matches
Mail list logo
