Moving data between tablespaces

Hi All, Some of my tables are accidentally created in the SYSTEM tablespace. Is there any way to move the records and the table to some other tablespace? regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S INET: [EMAIL PROTECTED] Fat C

RE: Moving data between tablespaces

Title: RE: Moving data between tablespaces alter table move ; rgds amar http://amzone.netfirms.com -Original Message- From: Karthikeyan S [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 12:58 PM To: Multiple recipients of list ORACLE-L Subject: Moving data between ta

RE: Executing a Unix command from database trigger

Check some back emails, I've posted a solution to running Unix commands from pl/sql procedures a number of times. Cheers, Kev. "my computer beat me at chess but i won when it came to kick boxing." __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor E

RE: Oracle Installer not launching in NT

Is the problem that the OUI does not launch or that it launches, does some installing and then suddenly stops?? Dave -Original Message- Sent: Monday, September 16, 2002 9:58 PM To: Multiple recipients of list ORACLE-L I have s similar problem (Oracle Installer 8.1.6 / 8.1.7 not launch

OT - for you , UNIX lovers

Hi ! Just got this URL from an acquaintance : the guy wrote a web server in bash. Sick but interesting : http://linux.umbc.edu/~mabzug1/bash-httpd.html DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Auth

RE: Moving data between tablespaces

Karthik, Look at the ALTER TABLE {table_name} MOVE {tablespace}; command. It will do exactly what you want. You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, Sep

TSOUG meeting

TriState Oracle User Group First Meeting DateLocation Thursday September 26, 2002 5:30 PM1200 Ross St Amarillo Texas 79102 Tentative Schedule 5:30Registration 5:45Welcome 6:00Lester Wells, Oracle 9ias

Re:

It seems that you send long sql requests or receive large amounts of data from the database. These parameters increase the blocksize so sqlnet will send and receive larger block, minimizing the time the server waits for data or waits for the client to request more data. Check the documents for im

RE: Moving data between tablespaces[Scanned]

Amar / Thomas, Thanks a lot for your help. As you said, "ALTER TABLE {table_name} MOVE {tablespace}", solved the problem. regards, Karthik -Original Message- Sent: Tuesday, September 17, 2002 5:10 PM To: [EMAIL PROTECTED] Cc: Karthikeyan S Karthik, Look at the ALTER TABLE {table_

Re: Another Character Set Problem

To change the character set to another that is not recognized as a superset use: Alter database character set INTERNAL_USE This parameter is active for oracle 8.1 and above. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thur

Re: ORACLE-L Digest -- Volume 2002, Number 260

Hi Rajesh. Try to use large rollback segments in your transactions. Best regards ED > Hi All, >I am running a pro*c program which has a cursor which fetches data f= > rom > a table which is constantly being updated by front-end, so I am getting= > > "snapshot too old error". My requirement

RE: Moving data between tablespaces[Scanned]

Thomas / Amar, I moved the tables from SYSTEM to the DATA tablespace. But now I am getting the following error. "ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such index is in unusable state" Is it because of moving the table to a different tablespace or is it something else? TIA

Re: Nasty bug in 9.2.0.1 (was: Oracle and Cache Hit Ratio based t

If you will search Metalink you will see that this bug is generic and not specific to a certain system. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, September 16, 2002 7:58 PM > Guys, the 2429929 apply for Sun Solari

RE: Oracle Installer not launching in NT

The OUI does not launch at all. I also tried what the note 131299.1 suggests, still not working. After I download the copy of symcjit.dll described by Mark http://www.cool-tools.co.uk/products/downloads/symcjit.dll, I receive the following error message: jvm.dll could not be found. Any ideas ar

RE: Moving data between tablespaces[Scanned]

Title: RE: Moving data between tablespaces[Scanned] Please rebuild the indexes for the move tables. Once a table is moved indexes, if any, on it become invalid. rgds amar http://amzone.netfirms.com -Original Message- From: Karthikeyan S [mailto:[EMAIL PROTECTED]] Sent: Tuesday, Se

RE: Moving data between tablespaces[Scanned]

Indexes store the rowids. Right? When the table row moved to a different place, the internal 'rowid' for it changed, making the rowid in indexes useless (or unusable). Since the 'alter table move' command does not automatically rebuild the indexes with new rowids, the DBA has to do it (at least

RE: Moving data between tablespaces[Scanned]

Karthik Lesson #2 on moving tablespaces. Afterward, you must perform ALTER INDEX REBUILD This corrects the problem you are experiencing.   Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September

RMAN restore to another node

Hi all, I am stuck on this restore for two days and Oracle support seems to offering little help. I seem to be doing everything according to manuals and metalink notes but am not able to do the restore. The case is I am restoring a database to another node. I have successfully restore the con

Tracking Temp Segment Usage and Event 10046

Title: Tracking Temp Segment Usage and Event 10046 I have a problem with a process and its temp segment usage. Previously, in RBO (8161) we used to run 8 reports with slightly different parameters in parallel and it used to work fine with all other load on the system and the total TEMP space

RE: Moving data between tablespaces

try this. Is my reorganization script. It don´t work if the table has LONG or LONG RAW. You must change the value of owner and tablespace. You can change the values of INITIAL, NEXT, etc. set serveroutput on size 100 set feedback off set echo off set trimspool on spool c:\move_tables.sql

RE: Moving data between tablespaces[Scanned]

rebuild the index. -Original Message- Sent: Tuesday, September 17, 2002 10:04 AM To: Multiple recipients of list ORACLE-L Thomas / Amar, I moved the tables from SYSTEM to the DATA tablespace. But now I am getting the following error. "ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or part

RE: Moving data between tablespaces[Scanned]

You now need to rebuild the index -Original Message- Sent: 17 September 2002 15:04 To: Multiple recipients of list ORACLE-L Thomas / Amar, I moved the tables from SYSTEM to the DATA tablespace. But now I am getting the following error. "ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or pa

RE: RMAN restore to another node

Johnson From what I read of your trace file, the channels are being released, presumably just before you need them. Do you have that explicitly coded in your RMAN recovery script, or are they being released for another reason. My immediate response is that maybe the problem lies in why those ch

RE: Tracking Temp Segment Usage and Event 10046

Title: Tracking Temp Segment Usage and Event 10046 Raj:   You will be able to identify the processes (along with the SQLs and number of extents) using the 10046 level 8 trace. If you use the temp files you see the file# ( in the direct path read/write events) as db_files+1 or MAXDBFILES+1 o

RE: Moving data between tablespaces[Scanned]

Karthik, It's because you moved the table. Think about it - the index is nothing more than a list of ROWID's. The ROWID's in the index are pointing to the old location of the table. Thus, the index is invalid. Run the second part of my suggestion - either move the index to a new tablesspace,

RE: RMAN restore to another node

Johnson - Did Oracle Support offer any theories on why the RMAN channels were being spontaneously released? Is Oracle Support looking into this as a possible bug, and you are just checking to see whether anyone else has experienced this behavior?   Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTEC

Re: Moving data between tablespaces[Scanned]

Karthik, You need to rebuild your indexes after moving your table as they are invalidated with the move. HTH, -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 9/17/2002 10:03 AM, Karthikeyan S <[EMAIL PROTECTED]> wrote: >Thomas / Amar, > >I moved the tables from SYSTEM to the DATA tabl

RE: RMAN restore to another node

I tried that too. But did it not help. here is the ouput. executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing comma

Fw: Moving data between tablespaces

Hi, If you have Oracle 8i, you can do: alter table OWNER.TABLE_NAME move tablespace TABLESPACE_NAME; and after you have to do: Alter index OWNER.INDEX_NAME rebuild tablespaces TABLESPACE_NAME; Natalia Lorena Laracca - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMA

RE: Moving data between tablespaces[Scanned]

Hi That's what "alter table move" does to your indexes. (that sucks, and bit me in the behind the other day as well) just rebuild your indexes and you'll be fine. Jack

RE: Oracle Installer not launching in NT

Try installing Java VM and retry. Download Java from www.java.sun.com. I ever got such a problem on TRU64 Unix. I installed Java, also changed the parameters used to mount CD ROM. This SHOULD NOT BE the case with NT. -Original Message- Sent: Tuesday, September 17, 2002 5:13 PM To: Multip

RE: Tracking Temp Segment Usage and Event 10046

Title: RE: Tracking Temp Segment Usage and Event 10046 Dennis, I did, but the problem is this is a SQR report, and it ain't one sql. SQR reports are like giant cursor loops but un structured. There are about 100 different sql statements (not including the recursive ones). In RBO, eight suc

RE: Rule Vs Cost

John, Yes, it is surprising no one responded.. Thanks for your reply. I just downloaded your paper and going through it. After I have posted this question, I tried to use CHOOSE mode with my query. Generated stats on the tables of interest, and forced one of the biggest tables to go for Index sca

RE: RMAN restore to another node

They are alluding it to a possibilty that RMAN cannot find the backup piece and just before showing the error it realeasing channels and that releasing channels per se does not point to any problem. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Johnson - Did Oracle Support offer any theories o

How to get all the SQL statements executed by a user !!!!

Hello All, How to get all the SQL statements executed by a user , when he logs  back in next time ( I do not wanted miss even single SQL statement) Can somebody help me in this.   Thanks, Madhu   Upgrade Outlook® - Add COLOR to your Emails   Outlo

Re: Moving data between tablespaces[Scanned]

Hi Karthik, When you moved the table it caused any indexes on this table to be marked as unusable. This is because the rows in the table now have different rowid's. You will need to rebuild the indexes as well. They don't have to be moved to a different tablespace but they will have to be

RE: Oracle Installer not launching in NT[Scanned]

This is NOT a bug with Pentium-III . I have Ver 8.1.5 - 8.1.6 - 8.1.7 on NT & W2K PIIIs , with NO Installer Problems. They are all Dell or ComPAQ systems. -Original Message- Sent: Tuesday, September 17, 2002 01:33 To: Multiple recipients of list ORACLE-L Hi, It is an Oracle bug. The

Listener load balance

Hi list,   Scenario Win2000 server, 8.1.7.   I added a network card to my DB Server.  I want the listener to accept connections for the 2 IP address to make load balance.  I just added a line to the listener file with a different port.   How can I assure that the port 1521 is listening for the

Re: Another Character Set Problem

This command is NOT supported by Oracle and Oracle would not guarantee that your data is not corrupted -- particularly if you have not run the character-set-scanner to verify it. Hemant At 05:33 AM 17-09-02 -0800, you wrote: >To change the character set to another that is not recognized as a sup

RE: SNP uses 60% of CPU on Windows2000 - please help

I have had times on Win NT boxes when the CPU went to 100%. My experience is that this happens when the OS is thrashing the swapfile (writing it into and out of memory on a continuous basis). If the disk I/O is also very high then that may be what's happening. However, 800M free out of 2G do

RE: RMAN restore to another node

Oracle support too pointed to that. I tested with allocating 3 more channnels after 'set newname'. But no change. They were released. and same error followed. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Johnson >From what I read of your trace file, the channels > are being released, > pr

RE: RMAN restore to another node

I am restoring the whole database. regarding RMAN-06026 I think RMAN is not able to find where my backup piece is. For the controlfile I could specify 'restore from' whereas that is not allowed for database or datfiles. --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > My other questio

RE: RMAN restore to another node

My other question is, why are you getting this error: > RMAN-06026: some targets not found - aborting restore Are you trying to restore all of the files, are just some of them? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 17, 2002 10:20 AM

RE: RMAN restore to another node

Testing a duplicate of 9.2.0.1.0, I had that problem of channels releasing and then getting an error about no channel, and it turned out I needed a new MML library for 9i. Now I have a problem that I can't restore the database unless I first delete all old datafiles. This behavior is differen

RE: Oracle Installer not launching in NT[Scanned]

No, I don't believe it is the bug either (just seen references to problems with P4's). It's obviously something to do with Java - I have had problems like this with dbassist when memory has been short. If reinstalling Java does not do it for you try stopping all necessary background processes and

RE: RMAN restore to another node

Joni, It looks like you are releasing the channels before you are finished with them. Can you add another ALLOCATE CHANNEL command before you attempt the RESTORE command? You did not provide the rman commands, so I am only guessing here - but that is what the error is telling you. You do not h

_spin_count Revealed

I have learned that my information was incorrect. A negative value for spin count is not to be used for reversing transactions. It is to be used for those systems in the southern hemisphere to insure that the disks spin counter-clockwise.   I sincerely apologize for this mistake and hope the

RE: Tracking Temp Segment Usage and Event 10046

Raj - I personally favor using the simpler diagnostics first. Why not run your SQL through EXPLAIN PLAN and see which SQL is performing sorts? My immediate guess is that under RBO an index was being used that isn't now. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED]

How to create a directory alias on Suse Linux7.3 to insert an external PDF file into BFILE column.

Hi, I just wanted to create a directory alias on SuSe Linux7.3 in order to insert an external PDF file into BFILE column.  Anyone please show me how to do so. On Window: CREATE or REPLACE DIRECTORY TEST as 'c:\images' ; On Linux: I issues this below command CREATE or REPLACE DIRECTORY TEST as '/Dis

Profile

Good Morning, Is there much/any overhead associated with turning the resource_limit on and enacting profiles to limit user resources? Thanks, Joe Frohne UW-Milwaukee, DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Frohne INET: [EMAIL PROTECTED] Fat City

RE: bug number 2429929

The bug is generic. And a quick create of a 9.2.0.1 DB on Winders for me seems to support that. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, September 16, 2002 7

RE: RMAN restore to another node

my RMAN script is the following I have not released any channels explicitly. run { allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; set newname for datafile 1 to '/extracts1/DB01_temp/system_01a.dbf'; set newname for datafile 2 to '/extracts1/DB01_tem

How to Call C Routine from PL/SQL

Hi Everybody, I want to call C Program routine from PL/SQL. What all things I need to do. Thanks Suman DISCLAIMER: Information contained and transmitted by this E-MAIL is proprietary to Mascot Systems Limited and is intended for use only by the individual or

bug number 2429929

  Hi Guys ,   Do you guys have any update on bug number 2429929 , which is "SID values in v$session and v$session_event does not match " .  Do you see this bug on solaris also , cuz metalink says this is on digital unix.   Thanks , Bp  

RE: SNP uses 60% of CPU on Windows2000 - please help

Thanks, my problem is that I hardly know how to spell Windows. Performance monitor shows Paging file usage at zero. On Oracle side I altered system and set job_queue _process = 1. when I run select vb.name NOME, vp.program PROCESSNAME, vp.spid THREADID, vs.sid SID, vs.program from v$session

RE: How to get all the SQL statements executed by a user !!!!

alter session set sql_trace=true;   Make this the first statement the user executes upon login. If you don’t have control over the user’s source code, you can put the alter session command into a trigger that fires when he logs in.   Cary Millsap Hotsos Enterprises, Ltd. http://www.h

migration to oracle 9i

Hi Guys , I know this question might have apperaed in this many times and I just neglected it cuz I was not interested in it. But now I am asking same question . We are runnning oracle bi ( 8.1.7) database , since recently it has been decided to move our iplanet LDAP server to oracle 9i LDAP

RE: Listener load balance

Your HOSTNAME of 'myserver' would tell you which.   Since you have the same hostname on the listener, both ports would currently be using the same IP address.   Did you setup DNS so that the cards share a Hostname ? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTEC

Re: How to Call C Routine from PL/SQL

Read up in the standard "PL/SQL Reference" manual on "external procedures". It will explain everything very well... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 17, 2002 10:23 AM > Hi Everybody, > > > I want to call C Progr

RE: RMAN restore to another node

Johnson Their explanation doesn't make sense to me. I have had RMAN fail to get the backup piece, and the error message is very clear. Just in case the SET NEWNAME is somehow affecting the recovery, you might take them out just to see what happens. I would also have moved the ALLOCATE CHANNE

RE: RMAN restore to another node

You are allocating an auxilliary channel? connect catalog rman/manager@rcat connect target system/manager@db1 connect auxiliary "system/manager as sysdba" run { set until time '17-SEP-2002 08:30:39'; allocate auxiliary channel disk1 type disk; set newname for datafile 1 to '/ot2_01/oradata/db1/

Re: Shutdown and startup processes

Hello Willie We are using startup trigger that calls a Java function that sends an MQSeries message to the mainframe. Maybe you could use a Java function that will close and open the scheduler. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROT

RE: bug number 2429929

Title: RE: bug number 2429929 This will be fixed in 9203, I learned this AM, dev rejected our request for exception patch. Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed he

RE: RMAN restore to another node

OK. I'll ask. Where is the backup piece? Is it in a same named directory as in the other machine? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 17, 2002 12:48 PM To: Multiple recipients of list ORACLE-L I am restoring the whole database

Unable to down Oracle 9.2 for Linux or Tru64

Can anybody else, would like to know if this is a problem with download.oracle.com or my site. Thanks Darren -- Darren Browett P.Eng

RE: How to Call C Routine from PL/SQL

H... My shop used it once and caused memory shortage because the external process frequently did not terminate. Application team removed the logic. Bing Wong Open Systems Database Administrator x25721 This e-mail may contain material that is confidential. Any review, reliance or distrib

Re: SYSDBA privilege with ORAPWD utility

Sorry for the late post. I did some research some time ago and found that when connecting as sysdba you are working under user SYS no matter what user you used to logon. So, connect system as sysdba and you are sys. problem solved. Yechiel Adar Mehish - Original Message - To: Multiple rec

backup controlfile to trace

8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231

RE: How to get all the SQL statements executed by a user !!!!

Hi Cary,   I have hi-jacked this reply to one of our list members. May I please ask of you to explain what happens next ?   I understand (I think ) that you mean to capture all of some ones  activity during a logged in session by setting sql_trace

RE: SNP uses 60% of CPU on Windows2000 - please help

Go to your Task Manager again and pick the "processes" tab. Click on 'CPU' to sort the processes by CPU usage or 'CPU Time" to get who has run up the most CPU usage since you last booted the system. All of your Oracle treads run in one process, ORACLE.EXE. The dllhost.exe should be there as a

Re: RMAN restore to another node

Do you have your backup restored to the box you are trying to restore from? I Have you build a database to hold the restored data? If so, are all of the tablespaces and datafiles the same name on the box you are restoring to? We need more information to help you further. Regards, Ruth - Ori

RE: backup controlfile to trace

Title: RE: backup controlfile to trace a non-full proof method that I use is T_FILE=$(ls -1rt /$ORACLE_HOME/admin/udump | tail -1) this will assign $T_FILE to the newest file existing in UDUMP. -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, Sept

Permanent Position Available-Oracle Clinical Systems Analyst/NJ

Interested candidates, reply to: [EMAIL PROTECTED] * Position Title: Oracle Clinical Systems Analyst/Permanent position The Clinical Systems Analyst is responsible for a broad range of systems-related activities within the Clinical Research Department.

Re: backup controlfile to trace

Not pretty, but this is how I do it: —- snippet of my hot backup script —- sqlplus / <>> [EMAIL PROTECTED] 09/17/02 02:13PM >>> 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able

Re: migration to oracle 9i

Hello Bp   Make sure that you upgrade the databases and the clients to 9i before you move the LDAP. I do not know about client 8.1.7, but client 8.1.6 can not talk to 9i LDAP.   Yechiel AdarMehish - Original Message - From: BigP To: Multiple recipients of list ORACLE-L S

Consulting Position Available-Oracle DBA/Developer/NYC

Interested candidates reply to: [EMAIL PROTECTED] * Consulting Position Title: Oracle DBA/Developer Duties and Responsibilities: This position is a conversion to an Oracle Data warehouse. Excellent verbal skills are needed to obtain technical speci

RE: backup controlfile to trace

The way we do it is not 100% but it seems close enough. We run the backup command and then do a descending order listing by date from the trace directory. The first file is the one containing the trace. If anyone has a beter idea, I am all ears. Kevin -Original Message- Sent: Tuesday

Re: 9ir2 install on linux(removal)

beats me but its one of those things that happens during the first time you run "root.sh". joe Peter Barnett wrote: >Did it, it worked. Now, why the heck do they put it >in /etc? > > >--- JOE TESTA <[EMAIL PROTECTED]> wrote: > >>try removing the /etc/oraInst.loc and the >>oraInventory file(t

Replication script

Hello One of you guy asked for a simple replication script. Here is a script that build synchronous replication (two phase commit). The first script does all the ground work: build users, dblinks, admin jobs etc.. The second scripts build a file with commands to activate replication for all tabl

Re: Consulting Position Available-Oracle DBA/Developer/NYC

well the market must be picking up some, been definitely more reqs posted here a/o recent. joe Bill Christison wrote: >Interested candidates reply to: [EMAIL PROTECTED] >* >Consulting Position Title: >Oracle DBA/Developer > >Duties and Responsib

RE: SNP uses 60% of CPU on Windows2000 - please help

That was the starting point of entire problem. An IIS administrator came to me complaining that Oracle.exe uses 99% of CPU. Indeed, it does. What is actually wrong with oracle.exe using 99% of CPU? Every other process shows 00 under CPU and small numbers under time. I am getting to think that I

RE: backup controlfile to trace

Snippet of code I use: ls -t ${UDUMP} | while read line ; do ${GREP} -q 'CREATE CONTROLFILE' ${UDUMP}/${line} if [ $? -eq 0 ] ; then echo " Processing file ${ORACLE_SID}.ccf" cp "${UDUMP}/${line}" "${ORACLE_SID}.ccf" break fi done Ron Thomas Hypercom, Inc [EMAIL PROTECTED] I

RE: migration to oracle 9i

We attempted to use OID 3.0.1 for our LDAP implementation, but OID cannot accept all v3LDAP-compliant LDIFs, despite what their marketing says. When we filed a TAR, Oracle Support's solution was to have us Oracleize the industry-standard LDIF. Wrong! This same LDIF file has since been imported

RE: 9ir2 install on linux(removal)

On Solaris, the location is /var/opt/oracle. It is slightly better place then /etc. > -Original Message- > From: Joe Testa [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 3:21 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: 9ir2 install on linux(removal) > >

RE: backup controlfile to trace

Here is a snippet from one of our scripts: - Kirti ($SQLPLUS -s / < /dev/null TRCFILE=`cat /tmp/$$trace_name.lst` rm /tmp/$$trace_name.lst cp ${TRCFILE} ${CR_CONTROL_FILE_SQL} -Original Message- Sent: Tuesday, September 17, 2002 2:15 PM To: Multiple recipients of list ORACLE-L T

RE: SNP uses 60% of CPU on Windows2000 - please help

Could you have a "lost" thread.  We have experienced, on multiple servers, running 8.1.7.3.2.  We put a patch on Oracle Applications 11i and only during the very large patches, CPU goes to 100% and stays there.  If look at the threads, the one using cpu is not known to Oracle.  Have had a ta

Re: Listener load balance

Tks Kevin,   I didn't setup the DNS to do that.  I ping myserver and is using the new address.  Don't know how to do it either.   What I am planning to do is to set the manually the ip address to the both port.  I am using local names.       (ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.

RE: backup controlfile to trace

Cool idea, Kirti, but wouldn't it be better to filter the results with AND s.audsid = USERENV('SESSIONID') instead of running thru v$mystat? USERENV is available at least as far back as 8.0.5. Not that it matters greatly for this particular purpose, but I know that code around here ten

RE: SNP uses 60% of CPU on Windows2000 - please help

If the end users are not complaining about response time then ORACLE using 99% of the CPU is not an issue. However, I can't help but think that 99% usage indicates some problem, even if it's not having a critical impact. I'm supporting a Win2K machine that has 7 instances on it. We're using 11

RE: Recreating database from hot backup but only 1 tablespace - U

Thanks to everyone who helped, I finally got the files restored to a new box (1 week later!) and the recovery and export took about a half hour. Jay Miller -Original Message- Sent: Monday, September 09, 2002 6:53 PM To: Multiple recipients of list ORACLE-L U Jay - Here is a link to the

RE: 9ir2 install on linux(removal)

/var/opt/oracle Same location on HP-UX 11 also... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 17 Sep 2002 11:48:38 -0800 On Solaris, the location is /var/opt/oracle. It is slightly better place then /etc. > -Original

Invitation: OOUG Meeting: October 24th, 2002. Dual Track Meeting

Oracle Developers, DBAs, Managers You are cordially invited to attend the first Dual Track meeting of the Ohio Oracle Users Group When:Thursday, October 24, 2002 8:00am - 4:00pm. Happy Hour following the meeting Where: Dublin Community Recreation

RE: backup controlfile to trace

SQL> oradebug setmypid Statement processed. SQL> alter database backup controlfile to trace; Database altered. SQL> oradebug tracefile_name /webstat/oracle/admin/wbs2/udump/wbs2_ora_22958.trc Waleed -Original Message- Sent: Tuesday, September 17, 2002 2:13 PM To: Multiple recipients of

RE: backup controlfile to trace

Arg. There's at least one caveat in that "AUDSID" won't work if you're logged in as SYSDBA, since it'll be 0, just like the background processes (I did my testing on 9iR2). Oh well... :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech

Followup: Apache core dumps after IP address change (solution)

Thanks to everyone who suggested ideas for my "emergency" yesterday. The problem only became obvious after a complete reinstall of Oracle on my server. I took this approach after finding a thread on the ODTUG-JAVA-L mailing list that talked about how 9iAS Rel 2 has hardcoded values for the IP

Re: backup controlfile to trace

Wow. I had no idea it was so easy! I just tried it out on 8.0.5.1 (svrmgrl) and 8.1.7.2 (SQL*Plus) and it worked like a charm! Only problem is I can't figure out an elegant way to capture that information in a variable so that I can (for example) do: host mv &trcfile /backups/ -- Philip - O

RE: backup controlfile to trace

Dependent on platform, but it almost always contains the OS process id which you can get from v$process. So something like select c.value || '/' || 'appropriate_format_string'|| a.spid || '.trc' from v$process a, v$session b, v$parameter c where a.addr = b.paddr and b.sid = (

RE: How to get all the SQL statements executed by a user !!!!

Ron,   Setting this parameter causes the Oracle kernel to write data to a trace file in the directory whose name is the value of the Oracle user_dump_dest parameter. There are detailed instructions on how to find the right file in section 5 of www.hotsos.com/dnloads/1/10046a.   Cary

Re: Followup: Apache core dumps after IP address change (solution)

The one thing to learn from all of this is to always bounce your services before performing an upgrade. It's the one thing we tend to forget about in a unix env since this services can be up for extended periods of time. Of course, those on a windows env bounce more routinely and would have

RE: Followup: Apache core dumps after IP address change (solution)

Bruce- Glad you worked it out. Actually, this problem can be worse than you saw. Apparently 9iAS V2 contains some sort of hardware dependency (somewhere in the JDK encryption algorithms). The net result is that you can have a full, good backup of your Apache server but if that physical hard

  1   2   >