Not able to view table

Hi all, I have created with the following details:   Global DB name: manu.ifpjyo SID:    manu Username:   SYSTEM Password:    manager Tables:    tblBundleCon, tblTextCon, tblFinalImage   I am able to connect to the database: SQL> connect system@ma

Re: PATCH confirmation

How long does it take to install complete patch from 8.1.7.0 to 8.1.7.2 ? Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, Nove

Control files & Redo Logs

Hi!!! Is it a good idea to put redo logs and control files on the same disk with nothing else on the disk??? Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (

RE: Question! ORA-12571

Hien, I would try to uninstall Oracle and reinstall it. It is possible that teh networking component was not installed properly. Below is an extract from Oracle 8i iInstallation Guide - release 3 (8.1.7) for NT on how to manually remove all Oracle components from NT. Long To remove all Ora

RE: Standby Database

Richard, Comments inline.. -Original Message- Sent: Thursday, November 29, 2001 6:40 AM To: Multiple recipients of list ORACLE-L This sounds good, but I have a couple of questions. How do you guarantee that you won't lose any committed transactions? I mean, the C program could lag b

RE: backup unix script

should we say the ! is a tag like EOF(what we normally use). srinivas -Original Message- Sent: Thursday, November 29, 2001 4:37 PM To: Multiple recipients of list ORACLE-L Hi grace it basically means that log in to sql*plus and execute whatever is below this line till you hit bang(!)

Re: Question! ORA-12571

Thank Jared and Folks! I Tried to config HW, Almost not find out any misconfugured HW. I also reinstall SP2 of W2k. Last two week I reinstalled Windows and It's working until now then repeat that error. Please tell me how to turn trace file on, view log... or uninstall Oracle all cleaned, delete i

Re: Off Topic - Windows XP Dialup connection

Actually unless you have XP Professional you cant join a domain it is one the the things that differentiate HOME from Professional HTH Peter McLarty                   E-mail: [EMAIL PROTECTED] Technical Consultant        WWW: http://www.Mincom.com APAC Technical Services     Phone: +61 (0)7 330

Re: OT: Solaris

Hi  Lisa Hed on over to http://www.sunmanagers.org and subscribe there for a good list regarding Sun Admin. Have a look at the archive http://docs.sun.com/ab2/ contains the sun Administrators Docs This is also a good book http://www.oreilly.com/catalog/solaris8/ HTH Cheers Peter McLarty    

RE: Duplicating a Database and Changig SID

I'm interested, please post it to the list. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ron YountSent: Thursday, November 29, 2001 5:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Duplicating a Database and Changig

RE: Possibly moving to Sun Equipment

We have a few production E420Rs, 4-450 mhz processors, 1 to 1.5 G memory. I've been quoted benchmarks (although I haven't researched them) that an equivalent Intel processor runs faster. Based on that I might be inclined to recommend faster processors if we were buying new. The CPU does seem to

Managing dblinks/synonyms across DEV/QA/PROD db environments

Does anyone have a good URL, paper, book that talks about best practices when it comes to use of db links, synonyms when you've got multiple db environments such as dev/qa/prod? For example, is it a no-no to create views with db links? Is there an alternative? Or do you create different views (

RE: Possibly moving to Sun Equipment

Steve he 420R is an older sparcII server, very good for workgroups and development boxes, but with your transaction load, see if your budget will extend to a F3800 Sunfire. These run Solaris 8 only so if that is a problem as to the version of Oracle you have then try a 3500 or even a 4500, We ar

RE: Calling SQL*Plus and Run Procedure in UNIX script, How ?

Robert, Here is an example of logging into sql plus and running a stored procedure. I pass 3 variables to my stored procedure. This is alot more to my shell script than this but this will hopefully get you what you want. I pass $1, $2, and $3 on the command line (separated by spaces) when I exe

RE: Favor requested

It loaded essentially immediately. I am on IE 5.5, high encryption, Raptor Firewall. I post to the list because it might be of some value to others. hth -Original Message- This is way off topic, but if several people could hit the following Web page, it would really help me: ht

RE: Possibly moving to Sun Equipment

Well I have just returned from the Sun site, and checked out the two systems. The 420r is a rackmount server in the Enterprise Server series. It uses Sparciii processors, up to 4 at 450mhz. I don't' think I would consider this configuration an upgrade. I also doubt you'd classify this one as a

MATERIALIZED VIEWS

Hi, We need to create the materialized view on query like: select * from table1 union all select * from table2 union all select * from tabl3 we r getting error set operation not allows. Is there any other way to create the materialized views based on union all queries??? Thanks -Harvinder -

RE: Duplicating a Database and Changig SID

If you are using RMAN and would like some direction on how to change the DBID as well, let me know and I will send you some directions/steps for that as well.   -Ron- -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sonja SehovicSent: Thursday,

OT: Favor requested

This is way off topic, but if several people could hit the following Web page, it would really help me: http://www.jcpenneyportraits.com Does it load fast or stall with an hourglass on image downloads? Don't reply to the group, but mail me your results mailto:[EMAIL PROTECTED] I am experiencin

O/S upgrade

I recently upgraded one of my Tru64 Unix system from 4.0f to 5.1. Can I run the 4.0f compiled 8.0.5 binaries under 5.1, or should they re-compiled under 5.1. Also can I copy a database from a 4.0f system to 5.1, or is this a export/import situation. ? Thanks Darren ---

RE: Possibly moving to Sun Equipment

Steve - Is the 420R part of the new Sun Serengeti series? We had a test box here and I recall the model number as being similar. If it is the same thing, that box was a real screamer. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 29, 2

Re: Snapshot Problems

Patch your database with the appropriate bug fix. --S Jeff Wiegard wrote: > > Good Day. > > I have a problem with recreating some snapshots. I would like to > add to the current set of snapshots. They were created in the > following manner: > > create snapshot snap_test as select * from test

Re: rman disk channel destination

try this .. RUN { ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/disk1/%d_backups/%U'; ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/disk2/%d_backups/%U'; ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '/disk3/%d_backups/%U'; BACKUP DATABASE; } Deepak PS: straight from the ma

Calling SQL*Plus and Run Procedure in UNIX script, How ?

In UNIX shell script: How does one invoke SQL*Plus, pass a shell variable to run a stored procedure ? i.e. if you have a UNIX variable $my_table (= dept) how do you invoke sql*plus and pass $my_table to a procedure which you'd otherwise manually run in sql*plus as SQL> exec check_table('dept') T

RE: rman disk channel destination

Hi Lisa, You can put the full path after the backup format keyword. Check out the "format" keyword section in the backup command. It's in the RMAN Command Syntax section 10 in my 8.1.7 docs. Steve Orr -Original Message- Sent: Thursday, November 29, 2001 2:30 PM To: Multiple recipients

RE: rman disk channel destination

Lisa - I am new to RMAN (just had the Oracle class), so bear with me, and I'll take a shot. I don't quite understand your question. In the class workbook, the following example appears: RMAN> create script level0backup { 2> allocate channel d1 type disk; 3> backup incremental level 0 4>

Re: Standby Database

Thanks for this Don. You and Patrice ( Unix vs. NT thread ) have together justified the time I spend on this list. Jared "Don Granaman"

RE: rman disk channel destination

Title: rman disk channel destination Hi,   Are you asking how to set the target directory for the backup images   If you are the script should go something like this:   .. allocate channel d1 type disk backup format '\u01\backups\controlfiles\cf%d_t%t_s%s_p%p' (current controlfile);

RE: rman disk channel destination

Title: rman disk channel destination Lisa,   You specify the destination directory with the FORMAT keyword, by which you both format the backup piece files and specify their destination.   Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiN

Re: Re: ACM SIGMOD-papers of interest #1

Try amazon.com Jared "Cyril Thankapp

RE: Oracle/UNIX vs. Oracle/NT

Patrice, This is great stuff, thanks. "Boivin, Patrice

RE: guess I'm presenting at OOW

Kirti, FedEx a few of the review forms to me, and I'll fill them out as an absentee. :) Jared "Deshpande, Kirti"

RE: Crontabs and Oracle

Kevin One thing you mentioned concerned me, the "CSH and not for KSH". I assume you are referring to Unix C shell and Korn shell script languages. I don't know if this is your problem, but I wanted to make the following points: 1. The #! /bin/ksh mentioned earlier will make sure the scrip

RE: RE: RE: Siebel.

Dick, question for yaif you "owned" Siebel, lock, stock and barrel, what would you do? 1) Fix and switch ALL RI to the database ( oracle and ms and ibm and others) 2) Just fix it where it is broken, but leave it in the app itself 3) leave it out but publish a tech spec document telling user

Re: ORA-12701 on Oracle 9i

I had this EXACT problem yesterday when I was trying to build a new 9i DB. My solution was to blow away all files associated with the new DB and to build it again. I got the build to succeed by changing a line in init.ora #remote_login_passwordfile=EXCLUSIVE remote_login_passwordfile=NONE HTH &

Re:RE: RE: Siebel.

Dennis, You ought to be a sales droid! That was a perfectly worded reply and in MANY instances I'll agree with you. The ease or of lack thereof in administering an application is very often decided on by damagement by whether or not they need a dedicated/specialized resource to handle it.

Possibly moving to Sun Equipment

Sorry for the double posting. I failed to include a subject line initially. My first day back, and already a list faux paus. Two I guess if you count the double post. Hello All, It has been a while since I have been here, but I am back and properly s ubscribed to the list again. I am looking t

rman disk channel destination

Title: rman disk channel destination This info isn't forthcoming on metalink or in the doco as far as I can tell.  Can anyone tell me how to change the directory associated with the rman command 'allocate channel disk'?  Or at least figure out where it is, rather than hunt and peck?  Is it f

RE: RE: Siebel.

Dennis, Maybe I'm naive, or I'm giving too much credit to those making the purchase, but I feel that for applications the size and cost of most ERPs you could market them using features such as stability and data integrity along with the bells and whistles. A cleaner schema would also make it eas

RE: RE: Siebel.

Damn. I've been wracking my brain all day trying to figure out how to say this. Thanks, Dennis. --Walt Weaver Bozeman, Montana -Original Message- Sent: Thursday, November 29, 2001 1:55 PM To: Multiple recipients of list ORACLE-L Henry - The issue isn't the major RDBMS vendors, altho

Major 11i issue question?

HI, The 11.5.5 Oracle 11i database has a problem exporting from one server and being able to import into a database on a different vendor's server. Example Sun to Compaq. Is anyone on this list working on the problem(similar post to oaugnet-dba list). It looks like the new stuff, object types of j

ORA-12701 on Oracle 9i

Title: ORA-12701 on Oracle 9i Dear dba list, I have a test  9.0.1 database that was working fine. After being down for while (no time to play with it) I tried to start in and I am getting the following errors. Metalink does not help. Machine is Sun 420 OS 5.7, SQL> conn sys/manager as sysdb

Re[2]: OpenWorld dispatches

Hello Jared, I'll (hopefully) remember to post reminders to the list. The URL for our dispatch page will be the same all week: http://oracle.oreilly.com/news/openworld_dispatch_1101.html On this page will be a link to each day's individual dispatch. Best regards, Jonathan Gennick mailto:[E

[no subject]

Hello All, It has been a while since I have been here, but I am back and properly s ubscribed to the list again. I am looking to draw from your experiences here with hardware. Our current database resides on a Data General Aviion system with a Clarion drive cabinet. While we are very pleased wi

Re: Errors running catdbsyn.sql

Ken Janusz wrote: > > When I run catdbsyn.sql I get these errors > > drop synonym DBA_CATALOG > ORA-01434: private synonym to be dropped does not exist > > create synonym DBA_CATALOG for SYS.DBA_CATALOG > ORA-01471: cannot create a synonym with same name as object > > Why is this and what can

RE: RE: Siebel.

Henry - The issue isn't the major RDBMS vendors, although there can be interesting variations among them when it comes to how RI is implemented. Most successful ERP packages have been around for a number of years, so they have had to be available on many platforms. On some of those platforms the p

RE: Determinants of control file

Title: Determinants of control file Other than dumping/ tracing the control file, you can find the required details in the dynamic view V$controlfile_record_section. This view has all the information you want     Best Regards, K Gopalakrishnan     -Original Message- From: [

Errors running catdbsyn.sql

When I run catdbsyn.sql I get these errors drop synonym DBA_CATALOG ORA-01434: private synonym to be dropped does not exist create synonym DBA_CATALOG for SYS.DBA_CATALOG ORA-01471: cannot create a synonym with same name as object Why is this and what can I do about it? Thanks, Ken -- Pleas

Re: PATCH confirmation

yes Seema Singh wrote: > > Hi > I think patch 1882450 is for upgrade from 8.1.7.0.0 to 8.1.7.2.0 right? > thanks > seema > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis M. Heisler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

changing password of default users

Due to a security problem, we are looking into changing the passwords for several default users: ORDSYS ORDPLUGINS MDSYS CTXSYS I seem to recall that if the password for these users was changed, some sql file was to be changed as well so that future runs of "catalog", etc would not have a pr

Re: GRANT REFERENCES

Thanks for your reply Paul. Would you be kind enough to elaborate on the 3rd point. I thought I followed but what I implemented gave me this error ORA-02021: DDL operations are not allowed on a remote database. Any pointers would be most appreciated. - Original Message - To: "Multiple

PATCH confirmation

Hi I think patch 1882450 is for upgrade from 8.1.7.0.0 to 8.1.7.2.0 right? thanks seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: Solaris

Title: OT: Solaris I like the "UNIX System Administration Handbook" from Prentice Hall because it highlights *NIX command and directory variations. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 29, 2001 11:49 AMTo: Multiple recipients o

Re: backup unix script

Hi grace it basically means that log in to sql*plus and execute whatever is below this line till you hit bang(!) .. literally. Deepak --- grace <[EMAIL PROTECTED]> wrote: > hi gurus, > > I found this unix script ... can any tell me what > this means? > sqlplus - sys/msd > filename.dat < does

Re: Question! ORA-12571

Hien, This could be a problem with your Network. You need to talk to your network admin about this. It's also been a problem with Oracle at times, but in older versions. When we've experienced this, it's been a bad piece of HW or misconfugured HW. There's a lot on MetaLink, so check there.

RE: RMAN, Netbackup question

That's what I thought but the class has Class Type of Oracle. And under that class type the multiple data stream is greyed out. So I shouldn't use "oracle" as the class type then? >>> [EMAIL PROTECTED] 11/29/01 01:49PM >>> I think you need to configure your NetBackup "class" to handle multiple s

RE: Crontabs and Oracle

Kevin, Here's a trick to get all you need in a shell script for a cron job. This is useful for situations such as yours where you just can't seem to get the environment set correctly. Run your job from the command line to make sure it works. I assume that you've already done this. Now set yo

Re: Off topic Perlesque question

Ivan, The best place to ask this question is on a Perl list of course, but I understand your quandary. Why not do what many folks on this list do: open a hotmail account specifically for your perl list subscriptions? Then you don't fill up your mailbox. It would also help to know which modul

Re: LAWSON NAS and SAN

I will attempt to address one of your questions, the one regarding HD size. The answer is it depends on the throughput and latency of the individual drives. Though you may have fewer spindles by using larger drives, they are newer technology, likely faster, and you may actually see more through

Re: OpenWorld dispatches

Thanks Jonathan. Feel free to post those to this list as well if you like. Or maybe even better,a daily reminder to the list that you have a new dispatch available and the URL? Thanks, Jared

RE: RE: ORA-03113

Title: RE: RE: ORA-03113 Thanks Rao for correcting me.  Like I confessed earlier, I am unix savvy, not an expert :) -Original Message- From:   Rao, Maheswara [SMTP:[EMAIL PROTECTED]] Sent:   Thursday, November 29, 2001 1:55 PM To: Multiple recipients of list ORACLE-L Subject:   

RE: Checking DB Status in NT env.

> select 'PING' from dual; How very clever Mark. ;) Jared "Mark Leith"

RE: RE: ORA-03113

Try doing: ps -ef|grep pmon|grep It will look something like oracle 20065 1 0 Nov 11 ?0:07 ora_pmon_BI Issue the kill against the PPID that is returned, in this case 20065. The kill command would look like: kill -9 20065 Terry -Original Message- Sent: Th

OT: Solaris

Title: OT: Solaris I apologize if this is a duplicate. I may be thrown into solaris system administration .  Can anyone recommend any good books, websites, etc. for a beginner?  I consider myself unix savvy but not an expert and am not adverse to starting at square one, especially since my

RE: enable the partitioning option in database?.

I should have mentioned that my comments were for UNIX platform. I recommend calling Oracle Support to see if there are equivalent commands for NT platform. Gerardo -Original Message- Sent: Thursday, November 29, 2001 6:30 AM To: Multiple recipients of list ORACLE-L i didn't find t

RE: 9ias Vs IIS

Try sans Also do a search in google for isn news or for IIS hacking or IIS security, I'm sure you will come up with something. Yahoo, C|Net, Wired, Register also have articles on IIS, I am convinced. You can also go to www.microsoft.com/security and do a graph

RE: RE: ORA-03113

Title: RE: RE: ORA-03113 Lisa,   ps -fu oracleSID - command would not work.  The reason is when you -u option with ps, it looks for the user by name mentioned. In this case, there would not be any user by name oracleSID (most likely).  All the oracle processes would be owned by the user

RE: Listers meeting at OOW

OK I'll be there too but I'm not local anymore :-) See Ya! Loco in Montana, Steve Orr -Original Message- Sent: Wednesday, November 28, 2001 1:26 PM To: Multiple recipients of list ORACLE-L Hi all, Are the locals driving down to SF from parts of the Bay Area? (methinks we will have a

RE: Email through trigger

The package is UTL_SMTP Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Aldi Barco Enviado el: Thursday, 29 November, 2001 11:05 AM Para: Multiple recipients of list ORACLE-L Asun

RE: RMAN, Netbackup question

I think you need to configure your NetBackup "class" to handle multiple streams. -Original Message- Sent: Thursday, November 29, 2001 11:23 AM To: Multiple recipients of list ORACLE-L Richard-I've seen ti done before.. But I can't remember the details. I had a couple of guys on my

RE: RMAN, Netbackup question

Richard-I've seen ti done before.. But I can't remember the details. I had a couple of guys on my team at a previous shop do it. Greg -Original Message- Sent: Thursday, November 29, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Hi all, I have a question regarding RMA

RE: RE: ORA-03113

Title: RE: RE: ORA-03113 Yes, you are right.  If you have multiple instances change the command to something like this, assuming your sid name is SID > ps -fu oracleSID|grep -v PPID|awk '{ print $2; }'|xargs kill -9 Try it without the xargs kill -9 to verify it's choosing what you need.  O

Re:RE: RE: Siebel.

Sounds like the path NAI's predecessor took with Support Magic. WHAT A MESS Dick Goulet Off to buy a new shovel, wonder why? Reply Separator Author: "Mark Leith" <[EMAIL PROTECTED]> Date: 11/29/2001 8:45 AM Another good one is when they change

Re: SYS vs SYSTEM

"Van M. Etheridge" wrote: > > Hi Ken, > > My guess is that you need to set up sys.dba_all_tables with a public > synonym. > > HTH > > Van > > -Original Message- > Sent: Thursday, November 29, 2001 11:50 AM > To: Multiple recipients of list ORACLE-L > > 8.1.7 on W2000 > > select owne

RE: CROSS TAB QUERY

Title: RE: CROSS TAB QUERY I gave it a whack and came up with the following solution (I needed the distraction).  For demo purposes each statement build upon the previous ones.  But first a little reality.  There are some problem boundaries that can be declared.  The first one is that there a

RE: Standby Database

Title: RE: Standby Database Shareplex is a great tool, i have heard anecdotally. Of course, it ain't cheap, either.     Both facts need to be addressed.     Is there any interest in sharing that kind of sales information? For, say, a Sun 6500, 12 processors, 8GB RAM, "shareplexing" to ano

OT : 9ias Vs IIS

- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 14:40 > So which would you rather use? > apache > Would you rather use a less secure (yes > I *DO* believe it is less secure) larger target, or the alternative that is

RE: Statistics not updated

No. -Original Message- Sent: 29 November 2001 15:30 To: Multiple recipients of list ORACLE-L Are you seeing 'UNABLE TO EXTEND TEMP TABLESPACE...' in your alert log? -Original Message- Sent: Thursday, November 29, 2001 6:05 AM To: Multiple recipients of list ORACLE-L Hi DBAs

RE: Comments on RMAN

Title: RE: Comments on RMAN It's here, halfway down http://www.evdbt.com/library.htm -Original Message- From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent:   Thursday, November 29, 2001 10:35 AM To: Multiple recipients of list ORACLE-L Subject:    Re: Comments on RMAN

RE: GRANT REFERENCES

I haven't done it with the REFERENCES privilige but with others the following will work: 1. create the same user account with the same password in the other database. 2. grant the appropriate permissions to that user. 3. refer to the table with @servicename or create a synonym with the @service

RE: Comments on RMAN

Did anyone else get an error while trying to open the RMAN pdf file? David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigita

Oracle DBA Team Leader Needed in Milwaukee

Oracle DBA Team Leader Years Exp: 5+ years Location: Milwaukee, WI Compensation: Competitive Package Prod Offered: Financial Services Candidates local to the Greater Milwaukee area preferred but all will be considered. This is a full time staff position so no sub-contractors or third parties pl

Snapshot Problems

Good Day. I have a problem with recreating some snapshots. I would like to add to the current set of snapshots. They were created in the following manner: create snapshot snap_test as select * from test@test_DB; They are executed nightly in the following manner: execute DBMS_SNAPSHOT.REFRESH('

RE: SYS vs SYSTEM

Hi Ken, My guess is that you need to set up sys.dba_all_tables with a public synonym. HTH Van -Original Message- Sent: Thursday, November 29, 2001 11:50 AM To: Multiple recipients of list ORACLE-L 8.1.7 on W2000 select owner, table_name, tablespace_name from dba_all_tables; When I

Re: RE: ORA-03113

If I'll apply this command it's will take all oracle processes down for every instance in this box? Thanks. >>> [EMAIL PROTECTED] 11/29 10:35 AM >>> Why don't you want to want to take all the oracle processes down? I thought that's what you wanted to accomplish with shutdown immediate? Go

RE: backup unix script

my, that's attractive! ;-) -Original Message- Sent: Thursday, November 29, 2001 11:15 AM To: Multiple recipients of list ORACLE-L I believe the it is as follows: Run SQL*Plus | THIS SHOULD NOT BE HERE | | database username | | | data

RE: Comments on RMAN

You can find this on Tim's web site www.evdbt.com Barb > -- > From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, November 29, 2001 8:35 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Comments o

RE: RE: Siebel.

Another good one is when they change the application from flat files to an RDBMS.. And then continue to forget all about relational database theory.. Love it!! -Original Message- [EMAIL PROTECTED] Sent: 29 November 2001 14:50 To: Multiple recipients of list ORACLE-L Henry, I am so

RE: RE: Siebel.

Just curious, but which of the major RDBMSs don't have RI? Henry -Original Message- Sent: Thursday, November 29, 2001 10:55 AM To: Multiple recipients of list ORACLE-L Another factor is that when RI was first introduced, people tended to overuse it and then performance was bad. I don't

RE: Standby Database

Title: RE: Standby Database I usually don't do these kind of posts... but I've seen a lot of activity on this topic lately.  What is really the problem we are trying to solve here?  Maybe we are using the wrong tool.   If you are looking for data protection in the event of a failure,

RE: Siebel - ODB.

Title: RE: Siebel - ODB. Of course a well designed database should (??!!) be used by multiple applications. So ideally, constraints which are data driven (long term) would be in the database, and constraints which are application driven (business rules) would reside in the application. But w

SYS vs SYSTEM

8.1.7 on W2000 select owner, table_name, tablespace_name from dba_all_tables; When I log into sqlplus as SYS is runs. When I log into sqlplus as SYSTEM I get the error table or view does not exit. What is happening here and how do I fix it? Thanks, Ken -- Please see the official ORACLE-L

RE: ORA-03113

grep, then, for the instance you DO want to take down. or, ask Mladen again. I understand he likes taking things down! ;-) -Original Message- Hi All! I tried shutdown immediate and get ORA-03113. Now I can't connect to database. How I can take instance down? On this HP box 10 differ

RE: ORA-03113

You could always start a bit nicer and kill pmon, wait a couple of minutes to see if the others are brought down. They usually will as Oracle recognizes the instance failure. -Original Message- Sent: Thursday, November 29, 2001 8:35 AM To: Multiple recipients of list ORACLE-L Why don

Re: Win2K Drive Mapping Question

- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 19:03 > Anyone know how to map more than 26 drives on Win2K > workstation? I trying to map 36 servers to a > workstation. > for Win2k u could do this by using Distrib

RE: Multiple instances - Sun Solaris: shmsys and semsys settings

here is the excerpt from my /etc/system file, we currently have 12 instances on it. Be sure to apply the logic in the comments and not the actual values that I used. The settings will make sense to your SA. The logic comes from reading many papers on the subject (I have them around here somewhere

RE: RE: Siebel.

Another factor is that when RI was first introduced, people tended to overuse it and then performance was bad. I don't think this is such a problem today, but I think many ERP packages were either developed before RI was common to all SQL databases, or were discouraged by the initial problems. But

Email through trigger

Hi Listers, What is the oracle procedure / package to send an email through store procedure or trigger ? Tia. Aldi _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L

ORA-03113

Hi All! I tried shutdown immediate and get ORA-03113. Now I can't connect to database. How I can take instance down? On this HP box 10 different databases. This command was posted some time back by Mladen: ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9 It's will take all oracle p

RE: Comments on RMAN

thanks Ruth. Santi -Original Message- Sent: Thursday, November 29, 2001 6:46 AM To: Multiple recipients of list ORACLE-L I thought I had another one but I can't find it. It was done by Michael Abbey of Pythian Consulting of Ottawa, Canada. His presentaion was entitle something like '

  1   2   >