Re: Oracle Trial License

John, I have quoted OTN(Oracle Tech Net). That's the same. If you take a further look down at "few other things", you'll see the text I quoted. Two conditions together limit the usage only for development and prototyping and only for period of 30 days. Btw, the download site of www.oracle.com is

RE: E business Suite 11i - for Apps DBA's

AFAIK it is only available if you have bought the Suite. If you have purchased it, then the Hard Copy of the documentation is provided to you. In that case you can also view the documentation at etrm.oracle.com, there you will need the metalink id. HTH Naveen -Original Message- Sent: M

RE: Transferring data from one table to another

Thank you, Amjad, The problem is that then I have to write a procedure for each of the tables. I was looking for something that could be set at database level and would apply to every table. Aleem -Original Message- Sent: Monday, August 12, 2002 10:43 AM To: Multiple recipients of

E business Suite 11i - for Apps DBA's

Hello Application DBA's I'd like to know where I can get/buy E-business Suite 11i documentation with the ERD and data dictionary of the tables. Thank you so much. -- Maria Aurora VT de la Vega OCP Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: ht

RE: Houston, do I have a problem?

This is an interesting report. I think the responses to it are even more interesting. One response admits confusion (which I think is a completely fair reaction). Another zeroes in knowingly on some specific details. If everyone had time to respond, I would expect a rash of differing opinions abou

RE: Transferring data from one table to another

well if u wanna commit after 1000 records u could very well use a cursor and within the loop keep a counter which will indicate the no. of records inserted...upon reaching 1000 records just commit and reinitialize the counter.. i have written the "Pseudo" code below: declare cursor c1 is

RE: TO_CHAR got one space in front

well that space is used 4 the sign bit...   rgds, Ams. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of shuanSent: Monday, August 12, 2002 6:53 AMTo: Multiple recipients of list ORACLE-LSubject: TO_CHAR got one space in front Hi all,  

Re: /etc/system on Sun Solaris 8 for 8i and 9i

How do you know it ran out of resource? What's the error message and when does this appear? During startup, during heavy use or when it's just idle? ltiu On Sunday 11 August 2002 20:08, you wrote: > Dear All, > I've Sun machine that run Oracle 8.1.7. Recently I installed new oracle 9i2 > 64-bit

Transferring data from one table to another

Hi, We are transferring data from one table in a schema to another table in another schema with identical fields using INSERT INTO schema1.abc (SELECT * from schema2.abc) The source table has 1.6 million records. The tablespace increases to consume full disk space and yet seems to be demanding mo

Re: Unix Solaris forum.

www.sunmangers.org will do it for you Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile

/etc/system on Sun Solaris 8 for 8i and 9i

Dear All, I've Sun machine that run Oracle 8.1.7. Recently I installed new oracle 9i2 64-bit on the same machine. But unfortunetly the old instance (8.1.7) is run out resource. I must set the /etc/system to higher value. But it is still the same. Could you please someone give me advice about it, a

Unix solaris forum.

Hi, DBAs, Could anyone recommend a good unix solaris discussion/news group for me? Thanks, Chuan Unless otherwise stated, this e-mail does not represent the views of TransACT Communications Pty Limited. This text and any attachments of this e-mail are confidential and may be legally pr

TO_CHAR got one space in front

Hi all,   Have you guys ever try this before:     1* select to_char(1.6,'0.') from dualSQL> /   TO_CHAR(1.6--- 1.6000   Notice that got one space in front of "1.6000"?   I'm using Oracle 8.0.5 in Linux.   Thanks in advance.

Re: Houston, do I have a problem?

Kirti, Get it in WRITING that you are not allowed to change anything. So that when they start to beat on you (okay, I know your boss, HE won't beat but HIS boss might) you are covered. You have my sympathies... I've worked under similar conditions (Rachel, we are giving you 750GB for your databa

RE: Lock table table_name in exclusive mode - Performance gain?

All my comments are with regards to 8i. Might do things differently with 9i ;-) Familiar with the technique for doing large deletes? For example, you want to delete 40 million rows from a 100 million row table. It can often times be much more effective to do a CTAS (or insert append into an exist

Re: Houston, do I have a problem?

On 2002.08.11 18:43 "Deshpande, Kirti" wrote: > This is not a joke.!!! > buffer busy waits 10740450 36 8193235928 > > db file parallel write 1749695 0 2935317 >

Re: Houston, do I have a problem?

Kirti, since i'm still not up to speed on the "Wait event concept". What should i see as a problem in your report. thanks, joe Deshpande, Kirti wrote: >This is not a joke.!!! > >This is from a business critical production database that I was asked to >'review' past Friday. > >The report

Houston, do I have a problem?

This is not a joke.!!! This is from a business critical production database that I was asked to 'review' past Friday. The report is from v$system_event taken at 10:30am, Aug 9, 2002. The server (and database) was bounced on Aug 4, 2002 at 9:20am. This was the 1st time I was logging into

Security risk with catsnmp catalog

Hi Listers, There is a security risk with catsnmp catalog (/rdbms/admin/catsnmp.sql) which is shipped with Oracle releases. This is generic. Details : this file drop and recreate user dbsnmp with default password "dbsnmp" and give him different privileges. For 8i releases, it is mostly V_