Re: Deployment of Oracle Client

CAUTION - only theory and heuristical speculation If you're not using only Win32, another method is to separate the registry part from the file system part. Various 3rd party tools take a "diff" of the registry before and after the install of a piece of software. This more or less allows for a t

how does CBO compute cardinality

Hello List, could someone please tell me how does cost based optimizer compute cardinality for each step in the explain plan? Is there a general formula which is independed on a particular version (I mean 8.0 and upward) ? Thanks in advance, Ed -- Please see the official ORACLE-L FAQ: http:/

Ignore it

Test, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Deployment of Oracle Client

The way we did it to 2000 users without a hitch. You dont need to install full client, only sqlnet or net8 (approx 28meg). We use Novell launcher. Take a snapshot on one machine, then novell automatically launches it to all clients.There should be similar products to this.(I think SMS by Microsoft

Re: Who are they ?

Hi, These are users for oracle intelligent agent and two of the oracle enterprise options. They're used to separate the additional objects from the common catalogue. You should change the passwords or at least lock their accounts to protect against security attacks. oli [EMAIL PROTECTED] w

RE: RE: (Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag uti

Paul, I believe you, which helps, because I wasn't inclined to take Oracle tech support's word for it without them providing a more in depth explanation. I would guess that getting a more in depth explanation from them would be a bit of a wild goose chase. 1Gb data file sizes sounds good. Also,

Re: (Fwd) Use of third-party tools in Oracle environments [Note:47292.1]

(fyi, from Metalink) ---begin--- Doc ID: Note:47292.1 Subject: Official Backup Policy -- Certification, RMAN, EBU, Third-Party Software Type:FAQ Status: PUBLISHED Content Type:TEXT/PLAIN Creation Date: 16-OCT-1997 Last Revision Date: 04-MAY-2000 Language:

Who are they ?

Lists, In Oracle Security Manager I found 3 users other than SYS and SYSTEM . what is task of these users ? <> DBSNMP <> MDSYS <> ORDSYS TIA, =bambang= <> Bambang Setiawan <> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan INET: [EMAIL PROTECTE

RE: Off Topic?

Petrol Kiosk ;) -Original Message- Sent: Tuesday, 13 March 2001 5:13 AM To: Multiple recipients of list ORACLE-L Can anyone tell me about the job options in United Arab Emerates? Please email me privately. Thanks! __ Do You Yahoo!? Yahoo

RE: oracle and America

OH ERIC! GROAN >From: "Eric D. Pierce" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: oracle and America >Date: Mon, 12 Mar 2001 11:38:32 -0800 > >yes, but perhaps if they were within a polar circl

RE: oracle and America

I agree since it's not much used in the bakery stores, construction materials, pre-cooked meals, etc -Original Message- Sent: Monday, March 12, 2001 11:50 AM To: Multiple recipients of list ORACLE-L one of my friends returning from America told that ORACLE is not much used in America.

Re: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on di

Folks, here is the maze of amazing info from Andrew Baker's NT support web site: > URLs: > > http://www.ultratech-llc.com/Personal/Files/?File=Defragger.TXT > >"If you're looking for some proof of how fragmentation can > negatively affect your system, see the following:" > > http://sup

RE: Script for reversing a string?

Hi. How about using a simple 'reverse' function available with SQL ?? Here is an example from 7.3.4.3 : Connected to: Oracle7 Server Release 7.3.4.3.0 - Production With the distributed and parallel query options PL/SQL Release 2.3.4.3.0 - Production SQL> select reverse('oracle') from dual; RE

Listener consolidation

Hi all: Our listeners have evolved over time, whereby when we moved from 8.0 to 8.1, a new listener was created to support this instead of having one listener listening to all databases of different versions. We are trying to consolidate so that we only are running one listener (8.1) and it i

AW: Script for reversing a string?

Hi! Here's the function: -- snip - create or replace function reverse_string(iText in varchar2) return varchar2 is oText varchar2(2000); begin for i in 1 .. least(2000,length(iText)) loop oText := oText || subs

Re: What or who is PUBLIC?

It might not be a role from dba roles, but look at the underlying source for the view, and you'll see that its EXPLICITY excluded in the where clause, even though its ALL stored in USER$. joe "Maser, Donna (SEA)" wrote: > > Good point Joe. Happily, we are both right. > Although you are correc

RE: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on d

Title: RE: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on di KK - I definitely agree w/your statement. I'd take computer number one, too! And, I did not have the resources to dig into it morei am sure, like me, you'd be want to if you could:) RM -Original Messag

Re: ScanMail Message: To Sender, (OT)

Where do you let corporate draw the line, before long you'll see no email, cause you can take damn near anything out of context. joe "Hand, Michael T" wrote: > > Joe, Cohorts, > > Look at it from the other side. If I worked in a Corporate legal office and > was aware of filtering technology,

RE: RE: (Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag uti

Okay - before this one dies ... this incorporates my usual NT bias. So you have a new box - with newly created NTFS volume - lets assume JBOD and no hardware RAID. They're empty. Completely. You create new tablespaces with multple datafiles, each equal to 1 GB so that your backup job can compress

Re:RE: oracle and America

Kevin, With the COTS (that's Commercial Off The Shelf) mentality that is permeating the military procurement system, stranger things have happen!! Believe me, I've seen them. Dick Goulet Reply Separator Author: "Kevin Kostyszyn" <[EMAIL PROTECTED]> D

RE: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on d

On 12 Mar 2001, at 13:17, Mohan, Ross scribbled with alacrity and cogency: Date sent: Mon, 12 Mar 2001 13:17:18 -0800 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > I don't see the logic in the last post: "You can't have fast and best." Dude, t

RMAN resource usage...

Listers, Could anyone throw any light as to the kind of resource RMAN takes up from the DB. Thanks. Anjan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 Sa

Re: One Database, Multiple Apps

Actually, if you're doing a *lot* of inserts without bind variables, try shrinking your shared pool. You'll be parsing everything anyway and that way it takes less time to fail the hashtable lookup. I have such a beastie, and this works for me -- it was able to roll over a 200M shared pool in ju

Re: moving from Access to Oracle

You might try just changing the tables in the master Access DB to links-to-Oracle-tables through ODBC. I don't know enough about Access replication to tell if this would work, but it's cheapest. Alternatively, install Oracle Lite on the mobile client and use links in the client MDB, but let Orac

RE: Script for reversing a string?

U did the right thing Jay. Oracle does provides u the answer. thats why its called Oracle (answer to everything), except when it comes to licensing select utl_raw.cast_to_varchar2(utl_raw.reverse(utl_raw.cast_to_raw('LOOK'))) from dual / -Mandar > -Original Message- > From: Miller, Jay

RE: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on d

Title: RE: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on di I don't know Ross, I didn't want to dig to deep into it.  The way I see it is as follows, "hey, that computer is a dual 550 with 10k rpm scsi drives and a gig of ram.  I betcha it would be faster than that piii600 with

Re: Does NT write to random locations on disk?

If you created it using the Database Assistant, it created a bunch of strangely small data files with autoextend turned on. When the file autoextends, it grabs the next free hunk of disk, of whatever size you set it to grab. Whether something else is creating ephemeral files that cause these fra

RE: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on d

Title: RE: (Fwd) Re: (Fwd/Oracle) Does NT write to random locations on di EP, I don't see the logic in the last post: "You can't have fast and best." First, he doesn't define terms. "Fast"?  Is that peak I/O? Streaming I/O? Single block read? Seek time? Write time? Come on, trying to red

Script for reversing a string?

Before I reinvent the wheel, I was wondering if anyone has written a function that will reverse a string? Our auditors are requiring that Oracle passwords not contain the reverse of the user name and I was about to start writing this function when I decided to check here first. Thanks! Jay Mille

Off Topic?

Can anyone tell me about the job options in United Arab Emerates? Please email me privately. Thanks! __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: h

RE: (Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag utilities

That is a pretty pathetic answer. "Datafiles, if they are sized correctly, will never need to be defraged". Yeah right, and if I install software the way it says to on the box, it will always work and I'll never have any problems. -Original Message- Pierce Sent: Monday, March 12, 2001 2

Re: Weird - unable to extend err

Better than that -- one day I was creating a database and forgot to set the temporary tablespace -- then I loaded and indexed a rather large table (>4G, >78M rows). I now have a 4G system tablespace on that database :-). "Joseph S. Testa" wrote: > Ganti, things like new users get created in the

Re: RE:compare date

I got the date select * from backups where date(backup_date) = '2001-01-01' Mitchell - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, March 12, 2001 5:20 AM > > > backup_date like '%01/01/2001%' that may work > > OK > > Cheers > Ga

RE: oracle and America

some how I find it very hard to believe that the tracking system for any military weapon is a Windows 98 2nd edition, Pentium III 700mhz with 256 mb of RAM. "FIRE!!!..oh crap..it locked up again..gotta stop playin solitaire." -Original Message- B Sent: Monday, March 12, 2001 3:31

RE: ScanMail Message: To Sender, (OT)

That's a good point. I mean about the racism and such. -Original Message- Michael T Sent: Monday, March 12, 2001 1:11 PM To: Multiple recipients of list ORACLE-L Joe, Cohorts, Look at it from the other side. If I worked in a Corporate legal office and was aware of filtering technolog

RE: oracle and America

ROTFLMAO... Thank You Eric! That even tops some of Mladen's quips. -Original Message- Sent: Monday, March 12, 2001 1:39 PM To: Multiple recipients of list ORACLE-L yes, but perhaps if they were within a polar circle, it would be ok for them to have control of a few Icy B.M.s? On 12 M

(Fwd) Re: (Fwd/Oracle) Does NT write to random locations on di

Dick & folks, "the plot thickens" (or something) see below for comments from some of the NT listserv folks... side note: clearly Oracle's internal NT development groups(s) have considerable knowledge of NT's file system, and they would presumably have a good idea of how to approach this

RE: oracle and America

Not ICBM's - but they do control Patriot's. -Original Message- Sent: Monday, March 12, 2001 2:06 PM To: Multiple recipients of list ORACLE-L GRAANN! > -Original Message- > From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] > Sent: Monday, March 12, 2001 2:39 PM > To:

RE: Oracle DB & ODBC

Step 1) find a really tall building. Step 2) jump   Seriously, step one is be sure you're using MS Visual C, as there are all kinds of issues in trying to get the libraries working with other compilers.  Step two is get it working via odbctst.exe.  If you can get it working this far, you sh

RE: (Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag utilitie

Title: RE: (Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag utilities EP, You are making a rather large assumption. You are assuming they put the people who KNOW the answer on tech support. Anymore, that is a fading proposition. Now "for the most part" I think the "iTar" gives yo

Re:(Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag util

Eric, That's a very interesting tap dance that OTS did for you. As usual they seem very reluctant to take a position with regards to a third party tool. At anyrate, assuming that you did "correctly" size your DB during initial creation & good old MicroSlop did not do anything strange they a

Re: (Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag

If I read oracle correctly when you say defrag, you mean the blocks making up the physical datafiles. Oracle means the internal structure of the database and tables. When you use a Oracle defrag utility from a third party, it reorgs the tables and rows. You are just talking defraging the harddr

RE: oracle and America

GRAANN! > -Original Message- > From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] > Sent: Monday, March 12, 2001 2:39 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: oracle and America > > yes, but perhaps if they were within a polar circle, it would be > ok f

RE: What or who is PUBLIC?

Good point Joe. Happily, we are both right. Although you are correct that PUBLIC gets created as a role 'under the covers', it is not listed as a role (try 'SELECT * FROM DBA_ROLES'), nor is it ever referred to as a role in the Oracle documentation. If you RTFM (:> as you are so fond of

(Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag utilities

Does anyone else get the impression that Oracle tech support isn't really answering the question about OS fragmentation below?? I thought it was obvious that moving db files when the db is open is likely to be a bad idea, but can't imagine why defragging at the OS level when the db is closed

Re:RE: oracle and America

Mladen, Well, hold onto your b&^t because about a year ago I read about a certain Navy Aircraft carrier that was headed back to port because their MicroSlop SQL*Server DB had irreparably crashed. I understand it was replaced by "another vendor's DB". Wonder who that could have been? Dick G

RE: oracle and America

yes, but perhaps if they were within a polar circle, it would be ok for them to have control of a few Icy B.M.s? On 12 Mar 2001, at 11:07, Gogala, Mladen scribbled with alacrity and cogency: Date sent: Mon, 12 Mar 2001 11:07:02 -0800 To: Multiple recipients of l

Re:RE: ScanMail Message: To Sender, (OT)

Well, You al might find this interesting too: E-mail filters are great for stemming the flow of unwanted pornography and ads, but are they too good? We here at the InformationWeek Daily last week got a peek at one possible filter future when hundreds of our newsletters were bounced back becaus

RE: Discount for register the exam

guess you are right!    Kimberly Smith <[EMAIL PROTECTED]> wrote: Best discount program I have found so far has been my employer.  0 cost to me.  Other then that I think you can only apply one discount at a time can't you? -Original Message-From: WENDY YUE [mailto:[EMAIL PROTECTED]]Sen

RE: One Database, Multiple Apps

Lisa Koivu asked about: I am thinking of just implementing a schema in my current database for this purpose and making the table as quick for inserts as possible (no primary key, minimal indexing, PCTUSED set appropriately, etc.) Lisa, I recently did the exact same thing: created a schema fo

fast_start_io_target and log_checkpoint_interval

Hi! is there any difference in the way oracle processes FAST_START_IO_TARGET and LOG_CHECKPOINT_INTERVAL apart from the fact that fast_start_io_target gives us a measure of no:of i/os required for instance recovery and log_checkpoint_interval gives us the number of o/s blocks require

RE: Rename tablespace

Thanks Dick! -Original Message- Sent: Monday, March 12, 2001 11:41 AM To: Multiple recipients of list ORACLE-L Ron, The trick is to export the schema's that were using the old tablespace. Then after you've dropped & rebuilt it, check all of those users default tablespace and reset

RE: oracle and America

As a DBA working in the US, I can only confirm that Oracle, strangely enough, is not much used in the parts of the US within the polar circle. I also doubt that there are any Oracle DBAs on the decks of the US nuclear subs. To appease to world, there aren't any SQL Server DBAs either. Having Micr

RE: oracle and America

Just check the jobs board on technet, or www.dice.com among other sites. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch |

RE: number of Mb to add?

Also, expanding the available space on a datafile to handle only the next extent is just not being a proactive DBA. Give it enought room to expand. Also don't forget that the datafile it self can be expanded in size (7.3 and above) up to the available space on the volume or the file size limit

inserting, updating, selecting millions of rows in a table

Our customer one of the large wireless co. needs to accomplish 3000 transactions per second. Each transaction has one insert, one select and 3 updates. All of them are on the same table. There are 172 processes performing these transactions in a random fashion so bulk binding is out of question.

RE: OEM - Tunning Pack, Diagnostic Pack....

Oracle has prices for this product based not on users (at least server part - OMS) but on power units. Alex Hillman > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Clinton > Naude > Sent: Monday, March 12, 2001 6:30 AM > To: Multiple recipients of li

oracle and America and Microslop

When I ran the original "Oracle and America" e-mail, Windows tried to force a download of an additional package from Microsoft to view it. I don't know what it wants (I wouldn't let it proceed). Microslop is so weak in security, I would NEVER allow a automatic download from anyone without kno

Vanilla BD size on Oracle Apps?

List, We are looking into the Oracle Applications Package as a means to house our old application. I know that the database size depends on the option selected that are available in the financial suite. Does anyone on the list have the URL/info on a white paper or propaganda that would give

Deployment of Oracle Client

How do most organizations deploy sqlnet client to a large user base? We've currently got hundreds, maybe thousands of users with various versions of the client installed on their desktop. We're also about to roll out Windows 2000 to a large percentage of these users. In testing we've determi

Re:One Database, Multiple Apps

Lisa, If this is a purchased application, which it does not sound like, you may not have an option since many a third party vendor loves to run rough shod over the database. I've got a message in work to the list on a third party product we recently installed which is a "bad actor" in this r

RE: oracle and America

LOL... LMAO.. ROFLMAO.. ROFLMGDAO..   Slap your friend around the head with a great big sweaty old fish.. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K.KaradenizSent: Monday, March 12, 2001 04:50To: Multiple recipients of list

RE: Discount for register the exam

Does my company need to know that I am quoting this info. about the OTN membership? Will they get my test results? rgds, raja -- On Mon, 12 Mar 2001 07:40:25 Gupta, Brijesh wrote: >At the time of registration just mentioned that you are OTN member, thus >eligible of discount. They will give

RE: ScanMail Message: To Sender, (OT)

Joe, Cohorts, Look at it from the other side. If I worked in a Corporate legal office and was aware of filtering technology, I would insist it be used. The current legal climate in the US where employers are sued at the drop of a hat over sexism, racism, ageism and any other -ism you can think

Re:Rename tablespace

Ron, The trick is to export the schema's that were using the old tablespace. Then after you've dropped & rebuilt it, check all of those users default tablespace and reset it to the new one. Don't forget to assign a quota of some type on that tablespace as well. On the imnport the objects w

Re:Record Length ...

Harsh, Are you talking about a 'host variable'? In that case look at the declared size of the field as in: NBRAHMS:8.04:GOULET> desc module_master Name Null?Type -- MODULE_ID

Re:oracle and America

Humm, If Oracle is "not used" much in America then why is there such a demand for Oracle talent? The statement is very false. Dick Goulet Reply Separator Author: "Bunyamin K.Karadeniz" <[EMAIL PROTECTED]> Date: 3/12/2001 8:50 AM one of my friends

quotes

Just got my oracle quote back. I had asked about backup servers and failover. To quote the salescritter, "In most cases where an environment requires a standby failover server, a license will be required..." Dennis Taylor The light at the end of the tunnel is the

RE: oracle and America

May be he was in South America or on a Caribbean beach ;-).   Out of curiosity, which database is much used ?  Or none ? -Original Message-From: Bunyamin K.Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Monday, March 12, 2001 11:50 AMTo: Multiple recipients of list ORACLE-LSubject:

Re: oracle and America

I think your friend, well, to put it nicely, was misinformed >From: "Bunyamin K.Karadeniz" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: oracle and America >Date: Mon, 12 Mar 2001 08:50:26 -0800 > >one of my friends retur

RE: number of Mb to add?

Title: RE: number of Mb to add? Joseph, Well, do you really want to deal with a datafile that small, whether that's KB or bytes?  What about when it extends beyond that extent?  Usually datafiles less than 100MB are not worth the hassle, and the size should be much larger in a production da

RE: RE[2]: Re-claiming the space from Table after deletion

This is exactly what meant - this is a quote from my message - "you can increase value of PCTUSED to 100-PCTFREE-5" Alex Hillman > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Morton, > Ronald D > Sent: Monday, March 12, 2001 9:41 AM > To: Multiple

Anyone Using Oracle Enterprise Manager on 8.1.6

Hi All, Is anyone out there using OEM against an 8.1.6.0 database on Solaris 2.7 , if so, are there issues? Such as security and the like. Please let me know,I'm planning on using it on my database. TIA Larry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Tay

RE: oracle and America

No it's not true   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K.KaradenizSent: Monday, March 12, 2001 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: oracle and America one of my friends returning from America told

RE: number of Mb to add?

It's Oracle blocks. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Monday, March 12, 2001 11:20 AM To: Multiple recipients of list ORACLE-L if I get this message, IMP-00058: ORACLE error 1654 encount

oracle and America

one of my friends returning from America told that ORACLE is not much used in America.     Is it True??   Bunyamin    TIA

RE: date format

Yes it is, but only with the time series cartridge. -Original Message- Sent: Monday, March 12, 2001 9:20 AM To: Multiple recipients of list ORACLE-L List hi! When we want to format data, we can do: select to_char(sysdate,'dd.mm. hh24:mi:ss') from dual; Is it possible to form

Re: function index concepts - urgh

if you change your script, you will be able to make a rowid match (assuming the last/first name combinations are unique). If you don't change the script, you will get an index range scan. Oracle will match the upper(last_name) and will then have to read every row with that last name and do an

Rename tablespace

I need to rename a tablespace. If I do an export, won't the import want to put all the objects back in the old tablespace? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Discount for register the exam

Best discount program I have found so far has been my employer.  0 cost to me.  Other then that I think you can only apply one discount at a time can't you? -Original Message-From: WENDY YUE [mailto:[EMAIL PROTECTED]]Sent: Sunday, March 11, 2001 11:45 AMTo: Multiple recipie

RE: function index concepts - urgh

Remember that you need the parameter query_rewrite_enabled=TRUE for those indexes. Regards. > -Mensaje original- > De: Diana Duncan [SMTP:[EMAIL PROTECTED]] > Enviado el: lunes 12 de marzo de 2001 16:55 > Para: Multiple recipients of list ORACLE-L > Asunto: RE: function index c

One Database, Multiple Apps

Title: One Database, Multiple Apps Hello all - I have one medium-large production database here. Our system is hybrid but more similar to OLTP.  As far as I know quick inserts are not a problem. I need to implement tracking software, where all I'd have to do from the database side is just

RE: Discount for register the exam

You have to mention at the time of registring your exam the code "S36" and ask for concession, Then they will charge you instead of 125 usd, 100 usd. Raghu. >From: "Gupta, Brijesh" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >S

number of Mb to add?

if I get this message, IMP-00058: ORACLE error 1654 encountered ORA-01654: unable to extend index TOTSAPPL.PK_DAILY_OPERATOR_ACTIVITIES by 15006 in tablespace USERS the 15006, is it bytes or rows or what? I just want to know how many bytes to enter as the size of the new ADDFILE. TIA -- Please

Re: One Database, Multiple Apps

Lisa, One of the biggest advantages that jumps right out is the user administration at the OS level. One login can get the user to more than one application/instance. At the Oracle level you have all of your scripts on one server and that makes it easier to manage the database. It's not the q

RE: "OIP-04109: Error creating temporary file"

Oops - I meant of course Oracle Objects for OLE (OO4O) -Original Message- Sent: 12 March 2001 15:46 To: Multiple recipients of list ORACLE-L I think (stress think) OIP messages are Oracle Objects for NT. -Original Message- Sent: 12 March 2001 15:20 To: Multiple recipients of li

RE: How to drop a datase ??

I can't imagine those records being that important if there was no backup plan in place. -Original Message- Sent: Sunday, March 11, 2001 11:20 PM To: Multiple recipients of list ORACLE-L Sorry , If you accidentally drop it without having backup , there's no other way to recover it...

Sr. level Oracle DBA -Peoria, IL..

*Description: Peoria, IL company needs a Sr. level Oracle DBA with Unix experience to join its' I.T. team. This position will have typical DBA responsibilities i.e.: physical database design, installations,performance analysis, system tuning, backup, recovery, etc. This is a full time staff po

RE: "OIP-04109: Error creating temporary file"

I think (stress think) OIP messages are Oracle Objects for NT. -Original Message- Sent: 12 March 2001 15:20 To: Multiple recipients of list ORACLE-L Anyone know what this means...or even what product OIP is? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Autho

Re: function index concepts - urgh

At 11:25 AM 3/10/01 -0800, you wrote: > >This should do it. > >select * from holder >where last_name = upper('Taylor') >and first_name = upper('Dennis'); Hm. Intuitively then, I should change my index creation script from (UPPER(LAST_NAME||' '||FIRST_NAME)) to (UPPER(LAST_NAME)||' '||UPPER(F

Export from 11i

Hello, we have issues with the export functionality in 11i Applications. It says it would export something, but i cannot find anything on my HDD. Is it still in out-format and where is it sent to? Or is the export functionality OUT OF ORDER as some other promised things also?? Thanks in advance

RE: function index concepts - urgh

In no way would I ever disagree with Jared ;-), but wouldn't it be better to create two indices rather than the one? create index HOLDER_LASTNAME_IDX on HOLDER (UPPER(LAST_NAME)); create index HOLDER_FIRSTNAME_IDX on HOLDER (UPPER(FIRST_NAME)); The select statement Jared wrote would definitely w

RE: date format

Title: RE: date format Hi Sonja, Unfortunately Oracle does not support milliseconds. Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL  33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The

RE: Record Length ...

Thanks, But it gives bytes for "current status of field". i.e. if field is empty or filled it will be different. This makes the assumption that at least one record must be having all fields filled except CHAR, to know the maxm recd length. Right ? -Original Message- Sent: Monday, March

RE: Discount for register the exam

Title: RE: Discount for register the exam At the time of registration just mentioned that you are OTN member, thus eligible of discount. They will give it. But you will have to mention it. Thanks -Original Message- From: Viktor [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 11, 200

RE: Oracle Lite and Palm Synchronization

Dave, we played around w/ this setup for a while here at my client, but they ultimately decided to go in a different direction (complexity, cost issues). We were trying to push sales and pricing data out to the field. I would have liked to have implemented this just for the hell of it. Anyway, i

moving from Access to Oracle

Listers, I have a client who currently has an application that uses an Access database with an Access front end interface (VBA). Since the users are required to make changes to data at any time, they each have the app and a local database replicated on their laptops which they can update and the

OT Re-claiming the space from Table after deletion

Title: OT Re-claiming the space from Table after deletion Sure it wasn't F = 9/5*C + 32 ? Formulas are s comforting, aren't they? ;-) -Original Message- From: Morton, Ronald D [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 9:41 AM To: Multiple recipients of list O

"OIP-04109: Error creating temporary file"

Anyone know what this means...or even what product OIP is? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet acce

insertion into CLOB

Title: insertion into CLOB Hi gurus, Oracle 8.1.6.2 Solaris 2.6 I'm doing some tests with a CLOB field.  I created a stored procedure, which inserts text into a CLOB. Here is my table : create table relance (nom varchar2(50), texte CLOB); Here is my code : create or replace procedure i

  1   2   >