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

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:

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: /etc/system on Sun Solaris 8 for 8i and 9i

When I start the 9i2 instance, the 8i3 instance could only establish 2 max. Unfortunetly, I forgot to log the error message. Yesterday, when I checked the error message on Oracle Doc, that sayed to be change the /etc/system. Please advice.. - Original Message - To: Multiple recipients of

Re: TO_CHAR got one space in front

check out the 'fm' format clause ie to_char(x,'fm'); hth connor --- shuan [EMAIL PROTECTED] wrote: Hi all, Have you guys ever try this before: 1* select to_char(1.6,'0.') from dual SQL / TO_CHAR(1.6 --- 1.6000 Notice that got one space in front of

RE: Transferring data from one table to another

Hi Aleem, well cant u pass the table name dynamically to the procedure for all the tables in the schema within an outer loop... n e ways iam not sure abt the database setting but logically speaking there shld b some property setting for some autocommit... rgds, Ams. -Original Message-

how to check the existence of a dir on remote server

__ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

How tocheck the dir existence on a remote server

Hello All, Solaris: 2.8 Can somebody tell me how find whether a directory/file is existing on a remote server. I used the folloiwng script, but did not work. rsh if [ -d srvr27:/export/home/oracle ] then echo existing else echo not existing fi I put rsh after the [ -d . but that also did

[no subject]

SET ORACLE-L NOMAIL __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network

Re: how to check the existence of a dir on remote server

UNIX or Windows? What protocol to connect? etc. J{ On Monday 12 August 2002 12:48, you wrote: __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Pruner Jan [EMAIL PROTECTED]

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

try reducing the number of processes in the 9i init.ora to see if you can start the database. if the error message is about semaphore or semaphore sets you will need to increase the semmni, semmns and semmnu parameters. Then you need to reboot the Sub box. The OS-specific documentation will

RE: How tocheck the dir existence on a remote server

Try this rsh server_name [[ -d /tmp ]] echo Is there || echo Is not there Works for me HTH Lee -Original Message- Sent: 12 August 2002 11:53 To: Multiple recipients of list ORACLE-L Hello All, Solaris: 2.8 Can somebody tell me how find whether a directory/file is existing on a

RE: Bitmap Header in a Uniform LMT?

I have been looking at LMT recently I created a 10001M datafile at 8K block size for a 64K locally managed extents Noticed from dba_free_space that the largest contiguous free space was 3968M Dumped the file header and got the same results as Paul / Jeremiah but I did note that for a 8k block

interMedia Text

Dear List, We have :- Solaris SunOs 5.8, Oracle 8.1.7 I have created three databases using the dbassist tool and I included, as one of the installation options, InterMedia. Having read the installation guides (including post installation for Oracle InterMedia) and the Oracle interMedia Text -

RE: Physical Database Layout

Hi Manav, Sorry for a late reply. Actually I had left it for gurus to reply, and moreover I was enjoying the weekends! Since you are working on enterprise application, surely the organization which will use u application will have a DBA. So you only need to be concerned about the table

RE: Houston, do I have a problem?

Cary, Your last paragraph is *GREAT* advice. Every DBA should take it out, print it large, and paste it to the top of their screen. Focusing first on the highest priority item in the business model will win you the biggest supporters in the organization. Tom Mercadante Oracle Certified

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

case, the app is very bad and we (me and another member on the list) were tasked to pull it out of the ditch (my 42nd day straight on this on back to back to back, etc 100/hr weeks, I want to hear the violins!). If we were to have written it, there wouldn't be the need for some of these large

CLOB columns

Hi Guys, I am using a CLOB column in my database. Is there any way to fetch and see the entire content of the CLOB field? For (eg) If I have stored my resume in the CLOB colum (in a text/HTML format) then is there any way to display the entire content in the database or in some other

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

Maria, Unless things really changed with 11i, Oracle has never HAD an ERD for the Apps. That's one of the reasons customization is such an incredible chore. As for the data dictionary, the Technical Reference Manuals can be ordered from Oracle. Be prepared, they are hideously expensive. HtH,

What Oracle versions are supported on MS2000?

Can anyone tell me what Oracle versions are supported on MS2000? Ron Smith -- 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) 538-5051 San Diego, California--

RE: Transferring data from one table to another

Abdul In terms of committing every so many records, investigate the SQL*Net COPY command if you are not familiar with it. For transferring this many records, you may also want to investigate CREATE TABLE AS SELECT . . . . NOLOGGING Dennis Williams DBA Lifetouch, Inc. [EMAIL

Re: Unix Solaris forum.

...it's www.sunmanagers.org (rather than a forum for well-lit livestock feeders :-) )... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, August 11, 2002 10:18 PM www.sunmangers.org will do it for you Cheers --

RE: Statspack archiving

Just a quick note to thank everyone for the contributions to this and the ODBC stuff I posted recently. Regards Lee -Original Message- Sent: 10 August 2002 20:53 To: Multiple recipients of list ORACLE-L The original question on this thread was for an automated purge for STATSPACK.

process size limitation on HP-UX

Title: process size limitation on HP-UX When 32 bit Oracle (8.0.5) is running under hp-ux 11 (64 bit), is the shadow process size limited by the 'maxdsiz' kernal parameter (defaults to 64 Meg) or the 'maxdsiz_64' kernel parameter, which default to 1 Gig? Matt Adams - GE Appliances -

SQL*Loader : How can I load the Line Feed as part of data

Greetings, We have one column in a table and this column need to store data with Line Feed, denoted by \x0d\x0a in the following row. This data comes from Sybase database. If \x0d\x0a cannot be loaded as Line Feed through the SQL*Loader then how can we do it? Any help is appreciated. Thanks,

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

The 11.5.6 and 11.5.7 versions of the TRMs have recently been made available online at http://etrm.oracle.com/pls/etrmlatest/etrm.etrmnav.show These include the ERDs for each module. Complicated reading =) HTH, Mike Hately Oracle DBA -Original Message- Sent: 12 August 2002 14:13 To:

RE: How tocheck the dir existence on a remote server

Srinivas - how about this? #!/bin/ksh if rsh srvr27 'ls /export/home/oracle' then echo existing else echo not existing fi -Original Message- Sent: Monday, August 12, 2002 5:53 AM To: Multiple recipients of list ORACLE-L Hello All, Solaris: 2.8 Can somebody tell me how find whether

Re: Unix Solaris forum.

I looked for www.sunmangers.org but it doesnt work? Can you please re-check the reference. Thanks. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, August 11, 2002 9:18 PM www.sunmangers.org will do it for you Cheers --

RE: DB Link Error - More Info

Thanks Jared. Looks like I will have to use some other method besides copy. It would have been good since it had the auto-commit on it. Oh well. -Original Message- Sent: Friday, August 09, 2002 8:18 PM To: Multiple recipients of list ORACLE-L SQL set arraysize 1 SQL set copycommit

Re: Transferring data from one table to another

Did you check out the SQL*Plus COPY command? Specifically in conjunction with SET ARRAYSIZE and SET COPYCOMMIT settings... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 12, 2002 1:23 AM Thank you, Amjad, The problem is that then

RE: Transferring data from one table to another

Iam planning to copy 18-40Million rows thru CTAS!! My question is which one is efficient, CTAS or using cursor in pl/sql Procedure!! thanks peter. From: Abdul Aleem [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE:

Re: interMedia Text

As you are running 8.1.7 you should not need the extproc_connection_data entry. What you need is that the LD_LIBRARY_PATH includes $ORACLE_HOME/ctx/lib in the environment *before* you start the Listener. The listener.ora entries are the regular entries for the database SIDs. Hemant At 03:48

RE: process size limitation on HP-UX

Title: process size limitation on HP-UX maxdsiz kernel parameter (default 64 Meg). Regards -Original Message-From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: segunda-feira, 12 de Agosto de 2002 15:48To: Multiple recipients of list ORACLE-LSubject:

RMAN: How to restore backup to a different box

Title: RMAN: How to restore backup to a different box Hi! I need to restore a RMAN backup (full db backup) of our production database to a test machine, which has a different file system layout. Production box: /u01, /u02, /u03, /u04, /u05 On the test box, all the data

RE: Transferring data from one table to another

How about turn off logging and drop indexes on the target table. Do insert with the APPEND hint. Re-create index. -Original Message- Sent: Monday, August 12, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Iam planning to copy 18-40Million rows thru CTAS!! My question is

Re: SQL*Loader : How can I load the Line Feed as part of data

check the utilities documentation, specifically the Field List section and the terminated by clause.. you can override the default terminator of line feed. You can also concatenate multiple lines together --- Mandal, Ashoke [EMAIL PROTECTED] wrote: Greetings, We have one column in a table

Error while invoking Email from PL/SQL

Hi All, I am trying to send an Email using PL/SQL. (Oracle 8.1.7 and Solaris 5.8). I tried to run the initplsj.sql and got the following error. Can you guys tell me what should I do to correct this? SQL @initplsj.sql call dbms_java.set_output(1) * ERROR at line 1:

Re: RMAN: How to restore backup to a different box

Check the RMAN docs; the process for doing this is well described there. Basically, you either use a parameter in the init file (when you can do wildcard path changes) or use set commands in the rman recover script. Glenn Stauffer On Monday 12 August 2002 11:48 am, you wrote: Hi! I need

RE: Transferring data from one table to another

Title: RE: Transferring data from one table to another CTAS with nologging. Could create a simple script to do this. -Original Message- From: Peter R [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Subject: RE: Transferring

RE: Transferring data from one table to another

Do you want to copy or move ? If move then partition the target table and do an exchange partition, is the faster way to move data. --- Ji, Richard [EMAIL PROTECTED] a écrit : How about turn off logging and drop indexes on the target table. Do insert with the APPEND hint. Re-create

RE: RMAN: How to restore backup to a different box

Helmut - I am struggling with this myself. What is your goal? Are you just trying to create a test database, or trying to perform a disaster recovery test? For creating a test database, take a look at the RMAN DUPLICATE command. As to your specific question of changing the file path, the RMAN

RE: Houston, do I have a problem?

Joe, This was just a 'review' of the top waits in the database. I can not draw any conclusions as to what the problem is, yet. But, the I/O subsystem appears to be stressed a bit. Why, who, when and how will not be visible at this level. Thanks. - Kirti -Original Message- Sent:

RE: RMAN: How to restore backup to a different box

Helmut, Check out the newname command that can be used when duplicating a database set newname for datafile 1 TO '$ORACLE_HOME/dbs/newdb_data_01.f'; set newname for datafile 2 TO '$ORACLE_HOME/dbs/newdb_data_02.f'; set newname for datafile 3 TO '$ORACLE_HOME/dbs/newdb_data_11.f';

RE: Transferring data from one table to another

Peter, CTAS is the way to go with large datasets - CTAS in parallel (assuming multiple CPUs) and you will be good to go. Jack --- [EMAIL PROTECTED] wrote: CTAS with nologging. Could create a simple script to do this. -Original Message- Sent: Monday, August 12, 2002 11:18 AM

RE: SQL*Loader : How can I load the Line Feed as part of data

Hi Rachel, I have attached the sample data and controlfile, which we are using to load the data. It is loading the line feed characters('\x0d\x0a') as it is. Oracle should store it as Line Feed while loading through SQL*Loader. When I select this column it should displays something like this.

OPS 7.3.4 - how to ?

Dear gurus ! I have to create an OPS 7.3.4 database (yes, there are still Oracle7 installations out there). Actually we are migrating our current OPS DB to another storage (EMC). So , the software is installed , i just need to create the DB. I can not find which scripts to run after the create

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

All documentation, including trm info, is in the CD pack (UD$40), orderable from oraclestore.oracle.com. (click on CD packs, choose platform, choose the product (oracle apps r11i 7 cd pack) Venkat Somusetty Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ:

[no subject]

Oracle releasing clustered file system code The move is designed to allow better management of databases on Linux server clusters. http://computerworld.com/newsletter/0%2C4902%2C73404%2C0.html?nlid=AM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL

RE: OPS 7.3.4 - how to ?

What platform? What OS? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, August 12, 2002 1:08 PM To: Multiple recipients of list

Case Statements, Distributed Queries, ORA-22804 Errors

When one tries to use a case statement, okay it's really a function, over a database link Oracle objects: ORA-22804 remote operations not permitted on object tables or user-defined

odbc/jdbc question

We are running Oracle 8.1.7 on AIX. Our users want to use ODBC JDBC products to connect to the database. Are there any security issues we should know about? Any other issues? Thanks. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Armstrong-Champ INET:

set sql*trace VB/Crystal

List: We have a crystal report performing badly. (No! ,you say. You're shocked!) The report has a visual basic front end. Our developer wants to set sql trace in the VB code. It's not working. When I tkprof her trace file, all that's in there is the ALTER SESSION SET SQL_TRACE TRUE command.

Re:set sql*trace VB/Crystal

Barb, More than likely VB is spawning Crystal in a separate database session, therefore the alter session command will not work. You could have her start the report then use top sessions to extract the sql and explain plan from the DB. Or you could extract the sql from the crystal report

RE: set sql*trace VB/Crystal

Title: RE: set sql*trace VB/Crystal I don't know vb either. However the trace file is likely generated on the server-side. She would not see the output. She might want to try alter session set autotrace on; instead. That way she should see the results. That is how it works in SQL*PLUS.

Explain Plan Question

Hello: I have to looking through Metalink but am unable to find the following. Does running Explain Plan take into Account the Cost Generated By using PL/SQL Functions? For example Select * from EMP where EMPID=FUNCTION_GET_ID; I do not believe that it does since the Function SQL does not

RE: set sql*trace VB/Crystal

Title: RE: set sql*trace VB/Crystal If you want to see the trace do the following connected to the appropriate database: SQL show parameters dump; NAME TYPE VALUE --- -- background_core_dump string partial

Re: set sql*trace VB/Crystal

You can see the sql generated by the report in Crystal, so take that sql and run it in sqlplus to see the access plan. You can also check in v$sqltext the select run by the report. --- Baker, Barbara [EMAIL PROTECTED] a écrit : List: We have a crystal report performing badly. (No! ,you

RE: set sql*trace VB/Crystal

What connection are they using? If they are using Oracle Object Of OLE I think there is a parameter that can be set. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: set sql*trace VB/Crystal Date: Mon, 12 Aug 2002

RE: Brain cramp on analytical functions and grouping.

I pivoted the result set on the WO column. This example works for up to 12 distinct values for the CP column. I don't know if you need to pivot it again to get back to the original result set but at least it gives you the sort order you described. HTH Tony Aponte Home Shopping Network,

RE: Houston, do I have a problem?

Cary, Thank you very much for a wonderful response. I have not yet talked to any users or developers regarding the performance of this database. I just shared with my boss (and with the list) what I found in my brief 'review' of the database. There are no reported performance related problems

RE: Delete performance

Title: RE: Delete performance I would use your method to CTAS but combine it with partitioning in order to overcome the unavailability issue. The new table would be a single-partition (MAXVALUE) object that would enable the use of EXCHANGE feature. I posted a nugget a while back describing

Re: set sql*trace VB/Crystal

Try to find out the sid and serial# of her session. From a dba user use exec dbms_system.set_sql_trace_in_session(sid, serial#,true); Babu Baker, Barbara [EMAIL PROTECTED]@fatcity.com on 08/12/2002 03:23:23 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:

Oracle vs. DB2

Hi Everyone! Well, there's been a lot of Oracle vs. Microsoft traffic on the list, but now my Manglement wants a similar comparison to IBM's DB2. Does anyone know of web sites or locations where there are documented objective comparisons between Oracle and DB2? I'm faced with answering

[no subject]

Hello, I have a question regarding method of index access(full vs. range) that oracle uses when I use different join methods (Hash vs. Nested loop). Here are the some details about the environment. Server : Oracle Server EE ver 8.1.7.2 OS :

Re: Oracle vs. DB2

For what I've read, globally the 2 databases are equal in performance, reliability and functionnalities. Larryh E as many times said that it's only competition in the database market is DB2. I guess it really depends on your environment. Of course Oracle works on more OS (used to be anyway),

Re: Houston, do I have a problem?

control file parallel write 143933 0 4080356626 28349.0001 Well, this is the top wait. Isn't 283 seconds to finish writing to all the control files a little much? How many control files are there, anyway? -- Please see the official ORACLE-L FAQ:

Re: Oracle vs. DB2

-- Vergara, Michael (TEM) [EMAIL PROTECTED] on 08/12/02 14:38:19 -0800 Hi Everyone! Well, there's been a lot of Oracle vs. Microsoft traffic on the list, but now my Manglement wants a similar comparison to IBM's DB2. Does anyone know of web sites or locations where there are

Re: SAN issues

Babu, Nice comprehensive list of things to consider with a SAN, Just a couple of thoughts. ® Oracle requests DBWR-1 for IDX1 and waits. DBWR-1 makes a Unix IO call and waits for Unix to return data. Unix talks to SAN and SAN starts reading from the disk. Assume that it takes 3 seconds

RE: set sql*trace VB/Crystal

Barb, To get all the data you might need for the session, use the 10046 level 8 tracing attribute available through the various means described at www.hotsos.com/dnloads/1/10046a. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San

RE: Houston, do I have a problem?

Cary, Thank you very much for a wonderful response. I have not yet talked to any users or developers regarding the performance of this database. I just shared with my boss (and with the list) what I found in my brief 'review' of the database. There are no reported performance related problems

RE: Houston, do I have a problem?

Greg, That's exactly the problem--you can't tell whether it's a problem or not! If the instance has been up for a couple of days, then it's probably a big deal. If the instance has been up for several months, then it's probably far less of a big deal. ...Unless a disproportionate amount of all

RE: Houston, do I have a problem?

Greg, Yes, it's way too much. There are three control files. - Kirti -Original Message- Sent: Monday, August 12, 2002 6:23 PM To: Multiple recipients of list ORACLE-L control file parallel write 143933 0 4080356626 28349.0001 Well, this is the top wait.

RE: SAN issues

Babu, If you have not already done so, please also review a paper by James Morle : Sane SAN http://www.scaleabilities.com/whitepapers.shtml - Kirti -Original Message- Sent: Monday, August 12, 2002 6:45 PM To: Multiple recipients of list ORACLE-L Babu, Nice comprehensive list of

RE: Houston, do I have a problem?

Rachel, This has not gotten to the level of getting it in 'black white' or to the 'beating' level, yet. That's why my boss wanted to just review the database and see if this thing will scale when we add more Applications and of course, hundreds of more users. More digging will be required to

Testing

Gene Sais [EMAIL PROTECTED] wrote: another suggestion:disable default roles.grant create session to all users.use application to enable roles with password.hth,gene [EMAIL PROTECTED] 08/09/02 01:58PM Why to find who and when. the best thing is to restrict the access.-Original

T3's, NetApps, Tuning, Wife's Opinion and other fun

Hi All, Well after 6 wekks of testing here is the basic way to operate SUN T3's as efficiently as possible. Be prepared for arguments with High priests from the cult of SAME. SUN T3's are fiber attached hardware RAID 5 arrays with a modern cache. The

Re: LMT and what is the Bitmap Header Size?

Rajesh.Rao£¬ hi, you can dump the file header and look at its contents, it can be easily found out. 2002-08-08 10:36:00 You wrote: I have been struggling to find the right answer to the question: What is the bitmap header size for a uniform extents LMT? 64K, 1 block, 2 blocks I

Use Raw partition or LVM in rac installation?

hi, I am trying to setup a RAC database with two DELL 6650 and a disk array, with two eth card, one for public network and the other for heart beating message and sga data transfer. I have two questions: 1. For oracle ceritified combinations, there should be 2 gigabytes

EMC and AIX resources

I'll be starting a new job next month and consequently startingat the beginning of a learning curve for some products. Just wondering if anyone has any good resources or comments for what to watch for with AIX (most of my experience so far has been with Sun Solaris. I do know about

Re: Explain Plan Question

No, it isn't correct. Explain plan gives you precisely what it should, and that is the access plan. Here is an excerpt from the documentation: The EXPLAIN PLAN statement displays

SAN

All I have a meeting tomorrow where I am going to point out why SAN and Oracle does not go very well together. Here are my thoughts. Can you pick holes in this argument, modify it or suggest any changes TIA Babu SAN and Oracle ? Conflicting IO behavior * There are four types of IO in

ORA-12571 error while EXPORT

Guys, i am on 816/win2k. while exporting a table with 6.5 lac records,i found the error below in my TRC file.The EXP process did not end. it was going on and on ksedmp: internal or fatal error ORA-12571: TNS:packet writer failure why is it so ? what causes this problem and how do i