RE: V$RECENT_BUCKET and V$CURRENT_VIEWS

Hi there, Have a look at http://www.ixora.com.au/newsletter/2001_03.htm#ideal for an 8i alternative. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Monday, 7 May 2001 11:30 To: Multiple recipients of list ORACLE-L

RE: OT -- MS makes a statement about open-source software movemen

I think .net will catch on, because it will be pushed by a company that has about 96% of the PC desktop market... all the other vendors (including Oracle with its java-centric view of the world) will have to accommodate .net. Ahem, how compatible will .net be with java, I wonder, given that it

Re: Taking your time when a crisis occurs

I agree, many serious problems have been created by DBA's that act before they think things through. When I have a problem with the database, I get a cup of coffee, put my feet up, and think about what happened and what to do to solve the problem. Between corrupted data files, hardware

RE: OT -- MS makes a statement about open-source software movemen t

A friend of mine explained to me over the weekend that open source is good for most companies, it gives them something to build on, or adds utilities to their proprietary software. Open source only becomes a threat when you want to control ALL the layers, i.e. from the OS right up to the

ORA-12203:TNS:unable to connect to destination while creating d

Hi I have installed Oracle 8.0.6 on Win NT. When I´m trying to create a new database with the database assistent I get the following message: ORA-12203:TNS:unable to connect to destination The message appears while creating dabase files, and the installation stops after only 1%. Does anybody

RE: list table in schema

If you have dba priviledges, you can issue the select select table_name from dba_tables where owner = 'SCHEMA_NAME' order by table_name; [EMAIL PROTECTED] 05/07/01 01:35AM This won't work. TAB is a synonym for USER_TABLES. Although this is present in current DB releases, it's there for

Re: multiple schema in a database ???

Having multiple schemas is a very normal part of an Oracle Database. For example, our current database has 70 different schemas [EMAIL PROTECTED] 05/07/01 03:00AM Andrea Oracle schrieb: Hi all, We'll have a meeting about the following issue: Due to large amount of transactions each

Re: OT -- MS makes a statement about open-source software movemen

- Original Message - Will we have to push something like JInitiator onto client machines in case they have .net running on them? I am just one DBA worrying about this... I think you're spot-on here. That's what's most likely. The hordes will make sure Java dies quickly now that M$

RE: Taking your time when a crisis occurs

Title: RE: Taking your time when a crisis occurs These are good points, but beware of the boss that thinks looking over your shoulder and asking questions helps. Either your supervisor trusts you or he/she doesn't. For me, having someone right behind me breaks my concentration and can make

Re: Taking your time when a crisis occurs

Ah, yes...reminds me of the time I attended a meeting with our new COO. She had a zillion ideas and a bunch of requests for information. When the meeting ended, she asked me what I was going to do first. I startled her with, I'm going to lunch, wanna join me?. She did and we mapped out our

Re: multiple schema in a database ???

Oh by the way, an easy way to set up the same structure for each user is to build all the tables in a setup schema, then do the following. 1) Export everything in the setup schema using the following command exp userid=setup/pass file=setup.exp 2) Create the new schema (user), making sure to

Re: Taking your time when a crisis occurs

want to tell me how you hold off the CEO who is breathing down your neck on the 24x7 database that's down? From: William Beilstein [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Taking your time when a crisis occurs Date:

RE: multiple schema in a database ???

Ours is ASP environment and each customer has a different schema. Make sure 1. Your database BR procedures are correctly implemented and tested with recovery scenarios. 2. If possible, take an export and incremental exports and test your exports. Rao [EMAIL PROTECTED] -Original

Re: Rename Datafile

Dear DBAs Question about alter database rename file '/oldlocation/datafile1' to '/newlocation/datafile1'; This command ususal to move a datafile to a new location. In case of rename file, I mean here '/oldlocation/datafile1' to '/newlocation/newdatafilename'; or '/oldlocation/datafile1' to

Re: Rename Datafile

Hi Mitchell, The steps should work. Oracle recommends to shutdown the mounted database before opening again after the change(I am not sure about if this is required) I would just open the closed db. I usually, a.Backup the database(going to do a structural change!) b.Take the tablespace connected

RE: Taking your time when a crisis occurs

You have to be like an ankylosaurus, with armour plating everywhere, and spikes on your tail. The armour plating to deal automatically with frets while you continue concentrating on your work, and spikes to keep people away to give you room to get the job done. If you can't bring the database

Re: Rename Datafile

Mitchell wrote: 1. shutdown database (normal or immediate) 2. cp /oldlocation/datafile1 /newlocation/newdatafilename or mv /oldlocation/datafile1 /oldlocation/newdatafilename nope don't use mv. the database needs to see the old datafile until you rename it. so use cp and then after

Re: Taking your time when a crisis occurs

Rachel Carmichael wrote: want to tell me how you hold off the CEO who is breathing down your neck on the 24x7 database that's down? establish a perimeter and use automatic weapons?;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED]

Re:multiple schema in a database ???

Andrea, As I recall you asked for some help on this before and it seems like some progress has been made. Therefore I believe you still need to ask the question of why does each user need his/her own copy of the tables. I have NEVER seem a circumstance where this was required in the

RE: 9iAS Forms Server Stability

We use forms 6 for a couple very small applications, and when I upgraded the forms server from 2.? to 6.0, it was an unpleasant experience to get forms running. Like you said, it involved upgrading to new Java VMs in IE, and on and on. Most of what we do is use HTML forms to collect data that

Re: Taking your time when a crisis occurs

I had this situation last year, when I recognised the voice of my boss at 4am I knew something was going wrong (24x7 database). The CEO held a quick meeting , ask us our advices , then let us work without asking us each 5 minutes how things were. I appreciated that a lot . --- Rachel

RE: OT -- MS makes a statement about open-source software movemen

Now of course we want to know what that URL is... Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region,

RE: Rename Datafile

You do not need to shut the database. Only take the tablespace offline where the datafiles are reorganized. Rao [EMAIL PROTECTED] -Original Message- Sent: Monday, May 07, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Dear DBAs Question about alter database rename file

Re:RE: More oracle news from the ether - IBMMix reaction

Regrettably I find most of what is in the letter as marketing hype. If I were using Informix or DB2 right now, I'd be scared as hell. There is no telling what will get dropped from which product, what will merge where what the migration costs are. There is also a very good chance that it may

RE: Rename Datafile

Why not to make tablespace offline, rename datafile in oracle and them use unix mv command to move it? Copy is not good ig there is no space. Alex Hillman -Original Message- Sent: Monday, May 07, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Mitchell wrote: 1. shutdown

RE: Taking your time when a crisis occurs

Title: RE: Taking your time when a crisis occurs I usually hire a large, mean and extremely rude person to stand at the entrance to my cube and say Mr. Adams is busy right now. Come back later. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff,

RE: Taking your time when a crisis occurs

Title: RE: Taking your time when a crisis occurs Yes, Rodd, you are right. There are times when being blunt is warranted. I do it now - I couldn't a few months ago. At my last employer I was very very good at it and my boss let us do our jobs without interference. However, the real question

RE: Taking your time when a crisis occurs

At my previous employer (ATT) I was in charge if a large electronic switching system. When there were problems the manager would be breathing down my neck to make the diagnosis and repairs as quickly as possible. I made a sign and pointed to it when he would bother me during the crisis. It

RE: OT -- MS makes a statement about open-source software movemen

working on it || -Original Message- || From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] || Sent: Monday, May 07, 2001 12:57 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: OT -- MS makes a statement about open-source software || movemen || || || Now of course we

FILE SYSTEM BUFFER IN JFS : ON OR OFF : CONCLUSION

I know I am slightly late but I have been losing some sleep and lot of patience with my project(s) so bear with me : ). The question was The ideal mounting option for ORACLE on JFS ? suggested is RBS TEMP files : mincache=dsync, convosync=dsync DATAFILES REDO files :

RE: Rename Datafile

Title: RE: Rename Datafile -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] On Mon, 7 May 2001,Hillman, Alex scribbled on the wall in glitter crayon: -Why not to make tablespace offline, rename datafile in oracle and them use -unix mv command to move

Re:Fwd: files needed

Jared, I assume from this message that your trying to help another. Therefore I'll try to stay simple. The pcscfg.cfg file is in the $ORACLE_HOME/precomp/admin directory and it's being 0 bytes is not a bad thing. It's purpose is to set pramaters used by PRO*C on each precompilation. If

RE: Taking your time when a crisis occurs

---excerpt--- ? definition #1) Dilbert's boss, a clueless manager who likes to have pointless meetings, harass workers. He really doesn't have a clue. definition #2) A specific form of a very common creature, he is one of those

RE: Taking your time when a crisis occurs

Work smarter not harderis that anything like, Know the difference between doing things right and doing the right thing? [EMAIL PROTECTED] 05/07/01 01:51PM PHB comes from Dilbert: Pointy Haired Boss. Those managers who wander around in a clueless state of perceived self-importance

RE: OT -- MS makes a statement about open-source software movemen

The characteristic dysfunctional dynamic would lead one to expect to frequently see both sides in such conflicts shooting themselves in the foot with wild abandon. This explains why my clay feet are full of holes. I often bend over backwards in trying to see both sides As for .net,

Re: Source code of objects

It is DBA_SOURCE / ALL_SOURCE / USER_SOURCE. For example: SELECT distinct OWNER, NAME FROM DBA_SOURCE; lists all source-code related objects in the database (functions, packages, procedures, types). SELECT TEXT FROM DBA_SOURCE WHERE OWNER = 'SYS' and NAME = 'UTL_FILE' ORDER BY LINE; will give

client for Progress

Hi All, I want to know which is the tool for Progress (Where I can connect to database and create objects, insert data, query the data etc..), similar to SQL*Plus in Oracle?. Thanks in advance Uday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: udaycb INET: [EMAIL

No Subject

help

RE:

Are you an idiot?? -Original Message- Sent: May 07, 2001 3:31 PM To: Multiple recipients of list ORACLE-L help -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hutchins, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

RE: sql query

Hello, SELECT COUNT(*), TO_CHAR(date column, 'DD-MON-YYY:HH24') FROM your table GROUP BY TO_CHAR(date column, 'DD-MON-YYY:HH24'); HTH -- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] -Original Message-

RE: sql query

Title: RE: sql query see answer below -Original Message- From: Ravindra Basavaraja [mailto:[EMAIL PROTECTED]] I want to get count of records that are generated every hour.(group by hour). Since the date field will have timestamp varying every second how do I group a set of

RE:

Wow, not necessary. -Original Message- Robert Sent: Monday, May 07, 2001 3:52 PM To: Multiple recipients of list ORACLE-L Are you an idiot?? -Original Message- Sent: May 07, 2001 3:31 PM To: Multiple recipients of list ORACLE-L help -- Please see the official ORACLE-L FAQ:

RE: RE: OT -- MS makes a statement about open-source software

:-) Feeling snowed? || -Original Message- || From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] || Sent: Monday, May 07, 2001 2:41 PM || To: Multiple recipients of list ORACLE-L || Subject: Re:RE: OT -- MS makes a statement about open-source software || || || OK, who's got the shovel?

RE: Taking your time when a crisis occurs

RE: Taking your time when a crisis occurs - http://www.amazon.com/exec/obidos/ASIN2/B4SU3E Barbie as Glinda from The Wizard of Oz Our Price: $19.99 Availability: Usually ships within 24 hours. Manufacturer's age: 3 years and up Shipping: Currently, item can be shipped only

RE:

no, but you are rude geez, lighten up here! From: Hutchins, Robert [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Date: Mon, 07 May 2001 11:52:00 -0800 Are you an idiot?? -Original Message- Sent: May 07,

RE: sorry,

Learn how to spell! -Original Message- Sent: May 07, 2001 4:53 PM To: Multiple recipients of list ORACLE-L i was trying to get commands from listguru and obviously typed the wrong address ...and no Mr. Hutchins, an idiot would be the jerk who sends that type of misanthropic respone

RE: How to deal with needing function based indexes but stuck wit

Title: RE: How to deal with needing function based indexes but stuck with St -Original Message- From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] Oracle Standard Edition 8.0.5 How are people handling storing data, such as a name, in the database, and then being able to

RE: sorry,

Boy, did I call that one, or what? Whoo-eee, here comes my career at Psychic Friends Network, doing MS-product support! -Original Message- Sent: Monday, May 07, 2001 4:53 PM To: Multiple recipients of list ORACLE-L i was trying to get commands from listguru and obviously typed the

OT, Microsoft.net

Users hold back on plans for .Net At a Microsoft-related conference last week, many IT managers said they're confused by the software vendor's multifaceted .Net technology initiative and aren't rushing to make plans to move to the new Web-based computing services platform.

RE: sorry,

Amazingyet true.. -Original Message- Sent: Monday, May 07, 2001 5:01 PM To: Multiple recipients of list ORACLE-L Boy, did I call that one, or what? Whoo-eee, here comes my career at Psychic Friends Network, doing MS-product support! -Original Message- Sent: Monday,

RE: sorry,

Geeze! It's getting a little vicious here. -Original Message- Sent: Monday, May 07, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Learn how to spell! -Original Message- Sent: May 07, 2001 4:53 PM To: Multiple recipients of list ORACLE-L i was trying to get commands

RE: sorry,

Jeez Robert, you need to take a week off. What exactly did he spell wrong, oh I see, respone. Clearly we all know what he was typing, but I forgot how quick you are to point out other peoples errors. Man, if you are the boss of someone, I would really hate to be them. -Original

RE: sorry,

Folks, let's deal with this in the following fashion 0) Whine and bemoan the loss of decency in everyday life, the callowness, the reprehensible lack of self-control, and the horrid manners of Robert Hutchins. 1) Send out a team to Robert's place of business and

RE:

That was totally uncalled for. It is obvious that they were sending a help command to ListGuru and sent to the list instead. Lighten up. [EMAIL PROTECTED] 05/07/01 03:52PM Are you an idiot?? -Original Message- Sent: May 07, 2001 3:31 PM To: Multiple recipients of list ORACLE-L help

Cool way to crash an Oracle database, any time, any place

Just thought I'd share what I learned today with everyone. This is Oracle 8.1.7 on a VA Linux 4450, Linux Red Hat 6.2. I'm migrating customers from MySQL to Oracle, using Sqlloader to load the data into Oracle. In one table I have the following column: C$NOTES VARCHAR2(4000) In my Sqlloader

oracle education:

Hi, Does anyone know the email/name of the person who heads-up the Oracle Education Dept? Thanks Patrick ===Patrick HousholderSr. Staff Anl Tech Spt DesignUnited Airlines Flight Training CenterDenver CO

Re: Cool way to crash an Oracle database, any time, any place

Walt, What's scary about this is not just that you've managed to crash the database by very innocent means, but we don't know how else this bug can be invoked. It could be something equally innocuous. Q: Are you loading in direct mode? Jared On Monday 07 May 2001 16:20, Weaver, Walt

Inserts slowing down on OLTP systems

Anyone have ideas on why OLTP database inserts would slow down by 100% from levels 15 days ago ? We alreay checked hit ratios in shared pool , checked for any storage issues etc thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET:

Re: fwd: denormalization (http://www.tdan.com/i014ht04.htm)

Interesting paper. Clear and concise writing. I don't take issue with point #4 below, though I do question their terminology. 'Over Normalization' is hardly a good term for a denormalization technique. Jared On Monday 07 May 2001 16:15, Eric D. Pierce wrote: from The Data Administration

Unix vs NT (backups, etc. - random boomarks)

random stuff from an old archive bookmark file: http://www.oreview.com/9805harr.htm ( http://home.mira.net/~gharriso ) - (general technology issues in Digital Preservation:) http://www.clir.org/pubs/reports/rothenberg/contents.html ---excerpt---

Re: XML PLSQL Parser: Installation problems

Ah, welcome to the wide wide world of Java compatibility. Any chance of upgrading your database to at least 8.1.6? Jared On Monday 07 May 2001 13:45, Gaston Jermak wrote: Hi list, I am trying to load the XML Parser for PL/SQL v1.0.2 downloaded from Technet into an Oracle 8.1.5 database

Re: sorry,

ROFLMAO! Geez Ross, do you really have a job? Like, when do you *work*? Or is this it? Jared PS. Bruce is more likely to kick you off than I am, and Jesus doesn't care. On Monday 07 May 2001 14:52, Mohan, Ross wrote: Folks, let's deal with this in the following fashion 0) Whine and

Re:

http://www.dali-estate.org/eng/pics/monta1.jpg On 7 May 2001, at 11:31, wrote: Date sent: Mon, 07 May 2001 11:31:00 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] help -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re: sorry,

On Monday 07 May 2001 13:52, lando wrote: ...and no Mr. Hutchins, an idiot would be the jerk who sends that type of misanthropic respone to an obvious error. Wow, you have quite a vocabulary for an idiot. ;) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: sorry,

HELP On 7 May 2001, at 13:52, Mohan, Ross wrote: Date sent: Mon, 07 May 2001 13:52:28 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Folks, let's deal with this in the following fashion ... We could just forget the whole damn thing. ( sung

Re: SQL query needing Oracle cast

Chris, there are other ways to do this, but they are version dependant. Which version of Oracle are you using? Jared On Monday 07 May 2001 14:07, Christophe Schockaert wrote: Hi all, I need to get the top N values from a table. It's quite easy to formulate in english, but rather

Re: Cool way to crash an Oracle database, any time, any place

I've checked this on a 817EE penguin SuSE7.0. The row gone simply into the bad file. oli [EMAIL PROTECTED] wrote Just thought I'd share what I learned today with everyone. This is Oracle 8.1.7 on a VA Linux 4450, Linux Red Hat 6.2. I'm migrating customers from MySQL to Oracle, using

Re: Taking your time when a crisis occurs

Eric, What's with you and Barbie? David A. Barbour Eric D. Pierce wrote: RE: Taking your time when a crisis occurs - http://www.amazon.com/exec/obidos/ASIN2/B4SU3E Barbie as Glinda from The Wizard of Oz Our Price: $19.99 Availability: Usually ships within 24 hours.

RE: Inserts slowing down on OLTP systems

Hi, Can u elaborate? What does the statement Inserts slow down by 100% from levels 15 days ago? mean. I did not understand especially the levels part of it. Also, mention as to how you are doing the inserts. Are the inserts done as select * from another_table? or Using SQLLOADER?

can we create our own error messages ?

Hi guys, Can I create my own error message in create profile mypasswordprofile limit failed_login_attempts 3 - if error Prompt Call ext 127, 128, 129 to unlock your account password_life_time - same as above but diffrent message ; Do I have to replace

consistency in cost?

I am working with an 8.1.6 database on Solaris 2.6 and I am wondering if there is any consistency in the optimizer. We have two nearly identical databases (one a clone from two weeks ago). A five table join has nearly the identical execution plan on the two databases. The difference is in the

Re: consistency in cost?

Henry, You say 'nearly identical'. What are the differences? Are the 2 databases on the same platform? If not, what are the differences, hardware and OS? Jared On Monday 07 May 2001 21:55, Henry Poras wrote: I am working with an 8.1.6 database on Solaris 2.6 and I am wondering if there