Re: Backup DB files to the Tape

> The only thing missing are the Hostess Twinkie wrappers. So, put your wrappers there to make it perfect. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, December 19, 2002 8:52 PM > > Long live Dilbert! > > The scary

ORA-04031

I received ORA-04031 while exporting database. Can someone explain what causes it and how to fix it? . exporting post-schema procedural objects and actions EXP-8: ORACLE error 4031 encountered ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","BEGIN :1 := "SYS"."DBMS_R

Undelete Record

Hi Listers, I have little problem : how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-505

RE: db block Size for Indexes Tablespaces in 9.2 ?

Please pardon the forthcoming non-quantitative response... Yay! Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101, Jan 7-9 Knoxville - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas

RE: Faking an ORA-600

this is sooo cool... i mean these tiny small things.. wich are hidden in oralce supplied packages...!! thanks Jared... > -- > From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Friday, December 20, 2002 8:48 AM > To: Multiple re

Re: db block Size for Indexes Tablespaces in 9.2 ?

Please pardon the forthcoming rant... Block size is one of the last things to consider in tuning indexes. Yes, it's a knob that can be twiddled, but it should be one of those out-of-the-way knobs that hardly ever get touched. It's much the same as adjusting DB_BLOCK_BUFFERS in order to improve

Re: ora_sql_txt system defined event attribute

Title: RE: ora_sql_txt system defined event attribute couldn't find anything abt ora_sql_text on metalink. What is this? How do you capture ddl from ksdwrt?   Thanks Shaleen - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: T

performance comparision between LMT and DMT

Hi: We have several oracle 8173 dbs on Solaris 2.8. Recently I was planning to move all dictionary managered tablespace to locally-managered tablespace (except SYSTEM ts), because there are many advantages using lmt as I read. Today I did the following on a test db and here is what I did and fo

RE: Deadlock

See Note 164661.1 on MetaLink for an excellent explanation of deadlocks. Jared "Fink, Dan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/19/2002 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subj

RE: Open the password

Thank you Naveen, it's working out now > -Original Message- > From: Naveen Nahata [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, December 19, 2002 1:39 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Open the password > > on the machine where the database is installed, you

Re: Faking an ORA-600

If you are monitoring the alert.log, try dbms_system.ksdwrt http://www.oracledba.co.uk/tips/plsql_alert_log.htm Jared "Ball, Terry" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/19/2002 12:51 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL

RE: Deadlock

And Oracle would generate a trace file listing the deadlock situation. - Kirti -Original Message- Sent: Thursday, December 19, 2002 4:04 PM To: Multiple recipients of list ORACLE-L Seema, Changing INITRANS may help IF you see waits for data block headers. INITRANS/MAXTRANS deal

Re:RE: Deadlock

Please allow me to provide a case in point on the subject that we discovered and fixed some time ago. We have 2 PeopleSoft SQR's that are used for material movement into and out of the stock room. Both run on a scheduled basis and it is NOT odd to see both running at the same time. Now for

RE: Faking an ORA-600

Okay, so I can't trype, I mean type... through should be THROW. I like this method because it does not make any schema changes, corrupt any indexes (even if they are junk). And it is very easy to repeat for multiple sids. dba:X920>oracle dba:X920>tail -3 $ORACLE_BASE/admin/X920/bdump/alert_X920.l

Re: FW: kinda OT: veritas netbackup

>From an external perspective this is easy to say but... a) You've coughed up a whole lot of cash for NetBackup. b) You're looking for a good enterprise wide solution Seems like its time to go RMAN hth connor --- "Spears, Brian" <[EMAIL PROTECTED]> wrote: > > Hi, > > I am the other g

RE: Faking an ORA-600

If you don't mind messing up a datafile, you could copy junk over an index datafile. Then use the index in a query. We had a corrupt index that always generated an ORA-600. R. Smith -Original Message- Sent: Thursday, December 19, 2002 3:39 PM To: Multiple recipients of list ORACLE-L "

RE: How do I find Oracle's product roadmap?

Title: RE: How do I find Oracle's product roadmap? > From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] > > > Jeremy - In his OpenWorld Guru session I believe Ken Jacobs > debunked this > myth > http://www.oracle.com/oracleworld/online/sanfrancisco/index.ht > ml?chats.html >

RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

Title: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB Oh the good old days when at the state government they decided to call us Bureau of Application Development And System Software   Yep, until the initials became apparent.. I think it lasted about 2-4 weeks, and they changed it.

RE: Faking an ORA-600

Type "oracle" at the command line and hit enter... It should come right back to the command prompt but you'll see the following in the alert log... ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], [] -Original Message- Sent: Thursday, December 19, 2002 3:52 PM

RE: Faking an ORA-600

If this is unix, type oracle at the command line. It will through an ORA-00600 in the alert log of the database identified by $ORACLE_SID. I learned this one the hard way...after a series of panicked calls to Oracle support when I was a Jr. DBA (e.g. last week ;) Dan -Original Message- S

RE: Deadlock

Seema, Changing INITRANS may help IF you see waits for data block headers. INITRANS/MAXTRANS deal with the number of transactions that can lock a block at a given time. Deadlocks are caused when TransactionA has locked RowA and TxB has locked RowB. Then TxA needs to lock RowB (but c

RE: strange error on DBMS_STATS

believe me, I'm talking to the wrong person if I want to get the right answers. Okay, we fixed it but I'm not sure why it happened. I re-granted s/i/u/d on all the tables owned by the schema_owner directly to the user running the gather_stats it's running properly. Reconstruction of events: 1)

RE: Transportable Tablespaces as backup?

Kirti, Jonathan - Thanks for your responses. I was able to validate the process with a small test tablespace. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 18, 2002 8:34 PM To: Multiple recipients of list ORACLE-L I did that

RE: Faking an ORA-600

Title: RE: Faking an ORA-600 How about taking the text of the ORA-600 error and CAT the text to the end of your alert file?  I am assuming that you will be parsing the alert log for that type of notification greg -Original Message- From: Ball, Terry [mailto:[EMAIL PROTECTED]] Se

RE: How do I find Oracle's product roadmap?

Title: How do I find Oracle's product roadmap? PL/SQL isn't going away ... there is a paper on TechNet http://TechNet.oracle.com put out by PL/SQL development team.   What we heard is that PL/SQL dev team has competition from JAVA team for features, so new features are being added to pl/sql.  

Re: Faking an ORA-600

"Ball, Terry" wrote: > > We are trying to test out monitoring software (on a test database at > 8.1.6.3). We have been able to generate most of the errors that we want to > monitor for, but have been unable to generate an ORA-600. Does anyone have > a way of doing this? > > TIA. > > Terry Ball

Re: Faking an ORA-600

Have you tried a search on metalink for 8.1.6.3 and ORA-00600 in the Advanced search section of the Bug database ? Offhand, this might work: create a table with 3 columns create table t1 as select trunc((rownum-1)/100,0)b1, mod(rownum,100)b2,

RE: How do I find Oracle's product roadmap?

Jeremy - In his OpenWorld Guru session I believe Ken Jacobs debunked this myth http://www.oracle.com/oracleworld/online/sanfrancisco/index.html?chats.html If I am mistaken as to which session discussed this, perhaps s

RE: Happy Holidays

Title: RE: Happy Holidays Well I've got another excuse. We just moved into our newly constructed house. I tell the kids that they get their own room for Christmas and they just say, "Oh Dad!" So even though we're still living out of boxes I have to got get more junk and put it in fancier boxes

RE: Happy Holidays

or when we are really bad ... 8 am on Christmas Day at the local convenience store that never seems to close -Original Message- Sent: Thursday, December 19, 2002 3:17 PM To: Multiple recipients of list ORACLE-L you're a man. Genetically you can't start shopping until at LEAST 6

RE: Faking an ORA-600

Title: RE: Faking an ORA-600 dbms_system.ksdwrt(2,'abc2_ora_2269266.trc:ORA-00600: internal error code, arguments: [794], [0x700189CDE40], [0x700189CDF08], [0x700189D0398], [4294967295], [], [], []'); Basically put anything in the string ... Lather , rinse, repeat. Raj _

Re: Faking an ORA-600

vi and manually add it ??? Stephen Andert Scottsdale, Arizona >>> [EMAIL PROTECTED] 12/19/02 01:51PM >>> We are trying to test out monitoring software (on a test database at 8.1.6.3). We have been able to generate most of the errors that we want to monitor for, but have been unable to generate

RE: Happy Holidays

you're a man. Genetically you can't start shopping until at LEAST 6 PM on Christmas Eve. --- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > Merry Christmas and/or Holly Happy-days to all. > > Man... I haven't even started my Christmas shopping yet. Sigh... > > > Steve Orr, > Still needing snow for

How do I find Oracle's product roadmap?

Title: How do I find Oracle's product roadmap? I'm back in a development house that is focused on Oracle development, along with J2EE and various other strains. I've become (by default) the resident guru for PL/SQL development and technical implementation support for our professional services

API for TNSPING

Does anyone happen to have a pointer to documentation on any APIs for TNSPING that exist ?? One of our developers is putting together a page and he would like to get the value of the 'length of time' that TNSPING returns. Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.

RE: Happy Holidays

Title: RE: Happy Holidays Merry Christmas and/or Holly Happy-days to all. Man... I haven't even started my Christmas shopping yet. Sigh... Steve Orr, Still needing snow for a white Christmas (and skiing) in Montana... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL P

Faking an ORA-600

We are trying to test out monitoring software (on a test database at 8.1.6.3). We have been able to generate most of the errors that we want to monitor for, but have been unable to generate an ORA-600. Does anyone have a way of doing this? TIA. Terry Ball, DBA Birch Telecom Work: 816-300-1335

RE: strange error on DBMS_STATS

Title: RE: strange error on DBMS_STATS I thought people talked to themselves so they could get all the right answers. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 3:16 PM To: Multiple recipients of list ORACLE-L Subject: Re:

Re: Happy Holidays

Kevin, Thanks to you (and also to Lisa) for offering to share your scripts. Every little bit helps. Cherie Machler - close to leaving for vacation Oracle DBA Gelco Information Network

Re: Simple Query for Week number

Thanks Yechiel. I missed that. That is a life saver. "Yechiel

Re: strange error on DBMS_STATS

you and Raj had the same thought. but no, the index is owned by the table owner got access so I could run the gather with a 10046 trace. so of course it's not failing as yet. sigh. and my boss wonders why I talk to myself --- Stephane Faroult <[EMAIL PROTECTED]> wrote: > Rachel Carmichael wrote:

Re:Deadlock

Seema, Unless your the application developer there is nothing you can do. Deadlocks are always an application error. Dick Goulet Reply Separator Author: "Seema Singh" <[EMAIL PROTECTED]> Date: 12/19/2002 11:54 AM Hi I have been noticing some ti

RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

Title: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB Does this 'Ass Management' apply to duhvelopers as much as it applies to tablespaces ?? Thrashing will be more useful.   ps: Before you say something I have been a developer for about 9 years (and still consider my self a part dev

RE: Restoring DB from specific RMAN backup set.

At 1st and 3rd? -Original Message- Sent: Thursday, December 19, 2002 2:42 PM To: Multiple recipients of list ORACLE-L Fortunately that is not the real SID name, had to sanitize it before I posted. Realized after I sent it that DB2 was not the best choice. Where are Abbot and Costello whe

RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

Title: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB :-0     Our ASS managment does a lot of thrashing lately...   It's close enuf to Friday and a 2 week vacation as well. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 20

RE: Restoring DB from specific RMAN backup set.

Title: RE: Restoring DB from specific RMAN backup set. Jared, LOL. Sounds like Abbot and Costello doing the DBA version of 'Who's on First'. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From:   [EMAIL PROTECTED] [S

RE: read only tablespaces

That's going in my DBA Script Toolkit! -Original Message- Sent: Thursday, December 19, 2002 12:26 PM To: Multiple recipients of list ORACLE-L That's a keeper! "Orr, Steve" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/19/2002 07:21 AM Please respond to ORACLE-L To:

Deadlock

Hi I have been noticing some times following error with one table during update. DEADLOCK DETECTED Current SQL statement for this session: "The following deadlock is not an ORACLE error. It is a deadlock due to user error in the design of an application or from issuing incorrect ad-hoc SQL. The f

Happy Holidays

Tis the season to give. At least thats what i've been told. Anyway, I've put together a little page of my favorite sql scripts. (I've actually written only about 1/2 of them. The rest are stolen from various sources, including this list!) http://www.tuningoracle.com/my_stuff/sql Kevin To

RE: strange error on DBMS_STATS

good question. It should be but I can check that. I don't know that it's failing on the index though. I'm going to use Tim's "hammer" and see if I can find out --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > Probably wrong question ... but was rebuilt index still owned by > schema > owner?

RE: Restoring DB from specific RMAN backup set.

Fortunately that is not the real SID name, had to sanitize it before I posted. Realized after I sent it that DB2 was not the best choice. Where are Abbot and Costello when you need them :) -- Paul -Original Message- Sent: Thursday, December 19, 2002 2:29 PM To: [EMAIL PROTECTED] Cc: [E

Re: strange error on DBMS_STATS

Rachel Carmichael wrote: > > We are not changing passwords, so I am presuming that this involves > (somehow) a change of username. According to the package header, it > will throw an ORA-2 if there are insufficent privileges. We rebuilt > an index yesterday but did NOT change or add any table.

Re: strange error on DBMS_STATS

I love the hammer. The problem is, this is the production database, I'm the development DBA. Until there are production problems. I have no access to the system, and I have no access to the routine that runs dbms_stats. Other than that, I can do anything :) I'll see if I can get this inserted into

RE: read only tablespaces

Shao, No mean spirited replies that I can see. At least 2 replies actually gave a technical answer to your question. The answer is easily found in the documentation. Do you have official Oracle Installation CD's? If so, the documentation CD is included. Install it on your desktop/laptop/ w

RE: Simple Query for Week number

Yechiel, Excellent! It all depends on how 'WEEK' is defined. (Shades of our former President). Oracle appears to define it as 7 day increments. So, using November as an example. Nov 1, 2 - Week 1? or Nov 1 - 7 Nov 3 - 9 - Week 2? or Nov 8 - 14 One of those vexing business

Re: Spool file behavior on Solaris

OraCop wrote: > > hello, > This is what i am doing: > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ora

RE: Restoring DB from specific RMAN backup set.

Paul, Who chose 'DB2' as a SID? That must be confusing. DBA1: What are you backing up? DBA2: DB2 DBA1: What? I thought it was an Oracle database? DBA2: Yeah it is, DB2. DBA1: But if it's Oracle, why are you backing up DB2? DBA2: It's an Oracle database called DB2. DBA1: But, if yo

Re: FW: kinda OT: veritas netbackup

Holiday Greetings, We use NetBackup Exec on a Novell network and the backup manual say's that it can backup open files and not hamper the operation of the system. Horse pucky. When a file is open by Oracle the tape backup "backs up the file without a lock" but if Oracle needs to use the file for

RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

Title: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB ASS Management?  I'm snickering, I know it's juvenile humor, but... LOL!  Let me tell you, my ASS is not on the Free List.  And thrashing?  I'll leave that one alone! Sorry everyone.  Couldn't resist.  Is it Friday yet... -

RE: Backup DB files to the Tape

That's "MR. Condescending Unix user" thankyouverymuch. -Original Message- Sent: Thursday, December 19, 2002 1:03 PM To: Multiple recipients of list ORACLE-L Condescending Unix user! -Original Message- Sent: Thursday, December 19, 2002 12:45 PM To: Multiple recipients of list ORA

RE: kinda OT: veritas netbackup

In that case Brian ... sorry, not going to be any help.  Good luck. -Original Message-From: Spears, Brian [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: FW: kinda OT: veritas netbackup    Yes, we have

RE: read only tablespaces

That's a keeper! "Orr, Steve" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/19/2002 07:21 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: read only tablespaces Here's the specific SQL que

Re: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

Depending on your circumstances, ASS Management can eliminate severe contention on the freelists / freelist groups area. However, because Oracle is overgenerous with its allocation of bitmap blocks (which may turn out to be in excess of 1% of your database), you may end up thrashing your system b

RE: Backup DB files to the Tape

Condescending Unix user! -Original Message- Sent: Thursday, December 19, 2002 12:45 PM To: Multiple recipients of list ORACLE-L "Here's a nickel, kid. Go buy yourself a better computer." -Original Message- Sent: Thursday, December 19, 2002 10:15 AM To: Multiple recipients of lis

Re: Simple Query for Week number

Check out the date 19/11/2002. format 'W' return 3 instead of 4. I wrote something to do this. It select the week day number of the current date, the week day number of the first of the month and the current week. If week day of the first of the month is higher then the current week day Then add 1

RE: Giving back Perl

Title: Giving back Perl Pl. send me a copy of the code.   -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 12:30 PMTo: Multiple recipients of list ORACLE-LSubject: Giving back Perl Hello everyone - I've been trying to writ

RE: Backup DB files to the Tape

Long live Dilbert! The scary thing around here is that the guy that most fits the description is an NT admin. He even has empty Mountain Dew cans all over his cubicle. The only thing missing are the Hostess Twinkie wrappers. > -Original Message- > From: Brian Dunbar [mailto:[EMAIL PROTE

RE: Giving back Perl

I'm interested, send at your convenience. And . "Oracle Diaper Administrator" ... Diaper ??? As in what my 3 year old has stopped needing at night? ~brian -Original Message- Sent: Thursday, December 19, 2002 11:30 AM To: Multiple recipients of list ORACLE-L Hello everyone - I've

Re: read only tablespaces

Shao We operate of the principle of GIGO - Garbage In, Garbage Out. The people on this list expect you to write clear questions if you want clear answers. Sometimes a questions like yours allow us to horse around a little. All in good will and between friends. Yechiel Adar Mehish - Original M

Re: Spool file behavior on Solaris

42 Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, December 19, 2002 6:45 PM > and the result is...? > reply of course only if it pertains to oracle :-) > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > >

RE: Restoring DB from specific RMAN backup set.

Database is 9.0.1.4 running on Win2K. The database called DB2 is not running in archivelog mode. The database is being backed up using RMAN: I.e. set ORACLE_SID=DB2 rman target / catalog rman@otherdb shutdown immediate; startup mount; backup database format="f:\oracle_backup\%d\%d_%U" tag full_b

FW: kinda OT: veritas netbackup

   Yes, we have coded it to do this and it works   but for many reasons.. including simplicity we want to avoid    this solution for the entire 12B enterprise solution... when it confuses   others, and is much more vulnerable for screwups with Mount point management   and recovery.   Bri

RE: read only tablespaces

Come on now, these guys are just joking. I don't see any egos or mean replies. You asked which dictionary instead of which data dictionary view. It is a learning process and we should all have a little fun. :) -Original Message- Sent: Thursday, December 19, 2002 10:30 AM To: Multiple rec

Giving back Perl

Title: Giving back Perl Hello everyone - I've been trying to write more Perl lately and after showing my Perl mentor some of the stuff I had written over the last couple of weeks the first thing he said was "why don't you give back to the community".  So I figure if I offer up my latest

RE: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB

Title: RE: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB if you have activex controls that you want to replace, there is 'Java Importer' and in Forms 9i you can use PJCs also. Read through Forms information at  http://technet.oracle.com Raj ___

RE: strange error on DBMS_STATS

Yes, but it turned out to be privs (or lack thereof) to run the stats or associated queries in a procedure, rather than privs to do the analyze itself. Do you have auditing turned on? That's usually the first place I check to see what objects changed since the last time it worked. GL! Rich Ri

RE: Spool file behavior on Solaris

Geez, Not only people come to list expect an answer and can't take jokes, now they expect us to read their minds too. Sigh -Original Message- Sent: Thursday, December 19, 2002 10:34 AM To: Multiple recipients of list ORACLE-L hello, This is what i am doing: __

RE: Simple Query for Week number

select to_char(sysdate, 'W') from dual; Paul -Original Message- Sent: Thursday, December 19, 2002 10:54 AM To: Multiple recipients of list ORACLE-L Hey Folks, Looking for the simplest of queries to find the week number, given a date. For example, 19th December 2002 falls in the 3rd we

RE: Backup DB files to the Tape

"Here's a nickel, kid. Go buy yourself a better computer." -Original Message- Sent: Thursday, December 19, 2002 10:15 AM To: Multiple recipients of list ORACLE-L It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. > -Original

FW: kinda OT: veritas netbackup

   Hi,      I am the other guy involved in this issue of Not backing up OPEN files on Unix with Netbackup.     We are keeping 2 days of logs on disk  up to 60gig of logs..  The tape backup people are not happy about us   backing this up often to provide extra redundancy especially as we impl

Re: strange error on DBMS_STATS

...I've got this hammer called "SQL Trace" and just about every problem looks like a nail... Good thing is, this'll probably resolve it for you. Can you run this in the same session prior to running the GATHER_SCHEMA_STATS? alter session set max_dump_file_size = unlimited; alter session se

Re: kinda OT: veritas netbackup

Here's an idea. First of all, I assume you are using plain vanilla netbackup, no RMAN. That's what it sounds like. Add the arch directory to the list of directories to exclude. Create a SQL script to create a list of files in the arch directory to backup. I won't supply details, cuz I know you

RE: Simple Query for Week number

Raj, How do you define week number? If a month starts in the middle of the week, is that week #1 or must it be the first full week? If the format mask 'W' is adequate, use 1 select sysdate, to_char(sysdate, 'W'), 2 '01-DEC-02', to_char(to_date('01-DEC-02'), 'W'), 3

RE: strange error on DBMS_STATS

Title: RE: strange error on DBMS_STATS Probably wrong question ... but was rebuilt index still owned by schema owner? Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is

RE: Simple Query for Week number

Dan, Thanks. The "W" works just fine. What I was looking for. Phew!!! I almost wrote a PL/SQL for this ; "Fink, Dan"

RE: strange error on DBMS_STATS

this is being run in sqlplus as execute dbms_stats.gather_schema_stats If I didn't run it (on another schema) within the same sql script, I'd think it was that I didn't have privs on dbms_stats. I'll keep looking --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > Yes, but it turned out to be priv

Re: Spool output issue on solaris

try sqlplus -s --- OraCop <[EMAIL PROTECTED]> wrote: > This is what i am doing: > > 1- login to sqlplus on solaris > 2- spool temp.out > 3- run an sql file useing: @myfile.sql >Sql file contains this: > set termout off > set head off > set echo off

Re: kinda OT: veritas netbackup

Hello Joe   Just schedule another backup of the archive logs 1 hour (or 5 minutes) after the regular backup. NetBackup will take a second (complete) backup of the archive file and when you want to restore , restore the last copy of the files.   Yechiel AdarMehish - Original Message ---

RE: Restoring DB from specific RMAN backup set.

Paul - Can you specify what you mean by "no archive log mode" and "backed up with RMAN"? Was the database open? Which Oracle version? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 19, 2002 9:40 AM To: Multiple recipients of

RE: Footprint of 9i

> I'm not sure what type of systems you're running, but I > haven't seen drives smaller than 18G much lately. Perhaps > its time to upgrade to a SAN anyway? :-) 1G isn't all that > much to ask (especially if your production systems are > running in ARCHIVELOG mode), but your comments prove tha

RE: Footprint of 9i

My issue is with memory requirements... try running iAS 9i R2 on 700M of RAM, with a local db. Ugh! Pat. -Original Message- Sent: Thursday, December 19, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Oracle 9.2.0.1 on NT: Demo files 80MB. Starter databases - 300MB Yechiel Ada

Re: Spool file behavior on Solaris

and the result is...? reply of course only if it pertains to oracle :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 19, 2002 10:34 AM > hello, > This is what i am doing: > >

Re: read only tablespaces

What is obvious here, is that you don't do your homework (RTFMing) before asking questions. That's why you get, what you asked for :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 19,

FW: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB

> -Original Message- > From: Paulo Gomes > Sent: quinta-feira, 19 de Dezembro de 2002 12:50 > To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' > Subject: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB > > Hi people > Now it's my turn, i really need some help here. > I'

RE: Spool file behavior on Solaris

The solution is: -Original Message- Sent: Thursday, December 19, 2002 8:34 AM To: Multiple recipients of list ORACLE-L hello, This is what i am doing: __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mai

RE: Spool file output

OK. Is there a question or comment here someplace? -Original Message- Sent: Thursday, December 19, 2002 10:40 AM To: Multiple recipients of list ORACLE-L This is what i am doing: 1- login to sqlplus on solaris 2- spool temp.out 3- run an sql file useing: @myfile.sql Sql file conta

RE: Methods to get DDL

I did not work on the new version, so I have no comments on what is or is not in there -- I don't know how much was removed, added or changed. --- Bob Metelsky <[EMAIL PROTECTED]> wrote: > > The original is SQL & PL/SQL Annotated Archives > > > > > > Ahh yes... but the new version is/ seems to

kinda OT: veritas netbackup

RESEND:  never saw it get posted:   Can we force veritas netbackup (HPUX) to NOT backup open files?   Here is the problem:  while arch process is writing out archive logs, the netbackup script that backs up the arch directory will write a partially written log to tape, we're trying to avoid th

Re: Restoring DB from specific RMAN backup set.

As long as you haven't opened the database with resetlogs between the time of the backup you want and the present you can just restore it and recover, using backup controlfile, until cancel. If you have opened it with resetlogs, you will have to change the incarnation of the database, Consult the

RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

We were the other way around in our testing lately:-)   We turned on auto space management to remove the contention. Afterwards-we removed quite a bit of header block/free list contention..   anyway, more tests to follow -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTEC

  1   2   >