recovery during refresh
Hi lists, I need to refresh a test database from production. (test1 from prod1 db) I took the hotbackup files and online redo logs. I created the controlfile using these files. After that I performed recovery. Here I applied online logs instead of archive logs. (There are 7 grous of online redo logs each contains 3 members). When I tried to open the db, it asked that datafile needs recovery. I applied online redo log instead of archive log. The next day I observed that indexes got corrupted (This msg is from another dba group who are working with this new test database) My doubt is : applying online redo logs instead of archive logs lead to this index corruption? can anybody come across such any situation. Now I need to do refresh again in another way applying archive logs. Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: recovery during refresh
Hi Gerardo, Thnq for responding. My doubt is , if I apply online logs , will it cause index corruptions. (ora - 600 error). In my last refresh , I applied online redo log. I got the message when I apply this log is Media recovery completed. After that I opened the db with resetlogs. Everything went fine. But later when the team is working that some indexes got corrupted and returning ora-600 errors. But in production db they are ok. Can you explain why this happened.? Srinivas -Original Message- Sent: Wednesday, December 19, 2001 3:50 AM To: Multiple recipients of list ORACLE-L Run the following via svrmgrl or sqlplus alter database backup controlfile to trace; This generates a trace file in udump directory. edit trace file: 1) strip out all lines prior to STARTUP NOMOUNT... 2) change all references to SID to test instance. 3) change all reference to file names to appropriate names for test instance. 4) make appropriate changes if there are any differences in number and size of online redo logs. 5) Remove these lines from end of trace file RECOVER DATABASE ALTER SYSTEM ARCHIVE LOG ALL; ALTER DATABASE OPEN; 6) copy hotbackup files only (do not copy online redo logs) to test file directories. 7) remove all online redo logs and control files for test instance. 8) make sure number of rollback segments in init.ora for test instance matches number of rollback segments in prod. 9) from svrmgrl or sqlplus @edited trace_file 10) issue following command: recover using backup controlfile until cancel; 11) when prompted for archive redo log, ftp it over from production to test (renaming it appropriately). 12) apply as many arhive redo logs that you feel you want 13) CANCEL (this ends recovery) if you get error, then you need apply more logs (see 10). 14) alter database open resetlogs; This will recreate online redo logs and startup the database; This is a proven procedure. HTH, Gerardo -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 9:35 PM To: Multiple recipients of list ORACLE-L Hi lists, I need to refresh a test database from production. (test1 from prod1 db) I took the hotbackup files and online redo logs. I created the controlfile using these files. After that I performed recovery. Here I applied online logs instead of archive logs. (There are 7 grous of online redo logs each contains 3 members). When I tried to open the db, it asked that datafile needs recovery. I applied online redo log instead of archive log. The next day I observed that indexes got corrupted (This msg is from another dba group who are working with this new test database) My doubt is : applying online redo logs instead of archive logs lead to this index corruption? can anybody come across such any situation. Now I need to do refresh again in another way applying archive logs. Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
update database trigger
Hi lists, DB:Oracle 8i I need to write a db trigger on table T1. It has to update T2 when ever T1 is updated. (Both T1 and T2 tables have identical structure.) The following query is doing wrong update. can anybody tell me what is wrong in this code: create or replace trigger trg_on_T1 before update on T1 for each row begin if updating then update T2 set a=:new.a, b=:new.b, c=:new.c; -- how to add the where clause..? end if; end trg_on_T1; I dont know how to use where clause in this. b'coz all columns can be updated by users. Can anybody give any hints. Thnx in advance Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: select data using trigger
Hi Thnq for responding. I am mistaken, in understanding the request. I am supposed to create a trigger that will do update onto a target table con2 whenever the contract is updated. 15 indexes on a table: There are several tables that have 15 indexes. All such tables will have 10-20,000 rows and are majorly used for querying. They have around 10-30 columns. But we never got a complaint, that the accessing is slow. Is this a harmful situation, having 15 indexes on a table. (The table data almost never grow) Thnx and regards, Srinvias -Original Message- Sent: Tuesday, December 11, 2001 11:56 AM To: [EMAIL PROTECTED]; Tatireddy, Shrinivas (MED, Keane) Hope I'm not being blunt here, ( I will admit to being frank, but not Frank ) What you're suggesting here is to put a patch on a bad design. 15 indexes? That's too many. Your table is undoubtedly highly denormalized and has too many columns. How many columns does this table have? You really need to take a step back and look at the design of the data you are querying. If this is really critical data ( Contracts? Sounds critical ) then strongly consider bringing in a consultant with strong data modeling and database design experience to help you put this data in a manageable form. Or maybe you need to build a data mart and use partitioning? This sounds to me like you need more consulting that you can get from a few emails on a list server. Jared On Monday 10 December 2001 19:50, Tatireddy, Shrinivas (MED, Keane) wrote: Hi lists, Can anybody help me...? Table CONTRACTS is accessed by many applications and has many selects hit this table. This table has 15 indexes. Still It needs some more indexes. But we were instructed to stop creating indexes. We have another table CONT2 in another schema. This table is copy of CONTRACTS. Is there a way to write a trigger on CONT2 for the following issue: if a particular select / select statement issued against CONTRACTS table, that query should select data from CONT2. (There is only one particular select statement that is more resource intensive. We need to divert that query to CONT2. As the applications are already tuned, we were not permitted to modify that code.) Thnx in advance, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
excel data into oracle through sql loader
Hi lists, I need to load the excel sheet data to oracle tables. A date column is improperly entered by users. In the excel sheet the date column was filled up without using hyphens or slashes the data is like this todays date: 10th Dec 2001 (it is supposed to be 10/12/2001 or 10-Dec-2001 etc...) But it was entered in the cells as 101201 When I formatted the data using the excel option cells - format The data it is displaying in a strage format: 1/27/2177 All the date values are displayed improperly. Does anybody come across such a situation. How to format the date cells in excelsheet. (should I change any options for the sheet) Thnx in advance, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Database strange behaviour
Hi lists has anybody come across this situation? solaris:2.6 DB: 8i db in NOARCHIVELOG mode , but ARCH background process is running. (LOG_ARCHIVE_START=TRUE) The database is up and running. But we were unable to issue any query even desc table just the statement desc table got hung. I checked whether the db has anyproblem. All background processes are running (v$session). But at O/S level no thread is existing for this processes. ps -ef |grep smon (This resulted count Zero) and ps -ef |grep dev2 (dbname dev2) (This resulted that there are live connections to database. Checked for alert log. In that I have a last message. ARC0: Media recovery disabled on Dec 7th (today Dec 12th). As it is a test db I issued shutdown immediate. against statement hung. Nothing is updated in alert log. I issued switch log to do a shutdown abort. Again the same situaion. At last I issued abort and restarted. DB started without any problems. Even after taking the db down, I found some local connections existing at os level that are connected to this database. I manually killed them (kill -9 pid.) Why background processes are not displayed at OS level? and is there any problem is the db is running in NOARCHIVE mode and ARCH process is started. Thnx in advance Srinvias -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Out put in a single line
Hi lists, Solaris: 2.6 Oracle 8i I am trying to extract insert statements from archive log files using log miner. All the statements are collected into a spool file. We ran them against another database (test schema). But the insert statement taken from this arch logs is split into multiple lines. I have to manually open the spool file in vi and remove unwanted spaces and I am making it into single line. Then only the insert is successful. There are around 20,000 insert statements in that spool file. You know how much time it will take to modify each statement. Does anybody throw some light how can I make the insert statements into a single line...? or is there a way to get the data in a single line from archive log. select sql_redo from v$logmnr_contents; If this is finished, we can move to production. Hope u can understand it is urgent. Thnx in advance, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
select data using trigger
Hi lists, Can anybody help me...? Table CONTRACTS is accessed by many applications and has many selects hit this table. This table has 15 indexes. Still It needs some more indexes. But we were instructed to stop creating indexes. We have another table CONT2 in another schema. This table is copy of CONTRACTS. Is there a way to write a trigger on CONT2 for the following issue: if a particular select / select statement issued against CONTRACTS table, that query should select data from CONT2. (There is only one particular select statement that is more resource intensive. We need to divert that query to CONT2. As the applications are already tuned, we were not permitted to modify that code.) Thnx in advance, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Out put in a single line
Hi guys, set linesize solved my problems. Thnaks to all who replied to this. Srinivas -Original Message- Sent: Tuesday, December 11, 2001 12:40 AM To: Multiple recipients of list ORACLE-L Not knowing exactly how the SQL Looks in v$logmnr_contents, I hazard a guess that because the sql_redo column is VARCHAR2(4000), it contains the entire SQL statement? (ie, the SQL statement is not split over multiple rows in the table as it is in, say, USER_SOURCE? If that's the case, then I'd guess that your problem is that the line length in SQL*Plus is too short. If you issue a set linesize 4000 and rerun your query to spool the statements out, each statement should be on a single line. hth -arn [EMAIL PROTECTED] 11/12/2001 13:50:19 This message has been scanned by MAILSweeper. Hi lists, Solaris: 2.6 Oracle 8i I am trying to extract insert statements from archive log files using log miner. All the statements are collected into a spool file. We ran them against another database (test schema). But the insert statement taken from this arch logs is split into multiple lines. I have to manually open the spool file in vi and remove unwanted spaces and I am making it into single line. Then only the insert is successful. There are around 20,000 insert statements in that spool file. You know how much time it will take to modify each statement. Does anybody throw some light how can I make the insert statements into a single line...? or is there a way to get the data in a single line from archive log. select sql_redo from v$logmnr_contents; If this is finished, we can move to production. Hope u can understand it is urgent. Thnx in advance, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
parallel import
Hi lists, Is there a parallel import into table / schema . ? (The table/tables have primary keys as well as indexes ) (need to finish the import in less time, than traditional import ) Thnx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Redo sql from archive log
HI lists, Can anybody tell me how to generate the sql s from archive log? what query do I user? Thnx in adv. Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Installing Oracle on Linux
Hi root.sh will update the env files (located under /usr/local/bin). I think it is a good idea to take them backup before applying root.sh (Solaris 2.7) Earlier in one installation, we got this same situation. We were to restore them from a different server that has the same environment and version. I think the files to be backedup are: oraenv, corenv Srinivas -Original Message- Sent: Saturday, December 08, 2001 5:05 PM To: Multiple recipients of list ORACLE-L Sorry, sorry, sorry. Our admin didn't run root.sh during install process. Everything goes well. :-) Thanks. JP On Sat 8. December 2001 20:25, you wrote: Hello, a little problem during installing Oracle 8.1.7 on Linux. I was installing 817 and I didn't let the installer create database. So, I'd let dbassist create scripts and I'm trying run it. When I start svrmgrl, I get ORA-12545: TNS:name lookup failure error = I cannot connect internal to create database. Tnsnames.ora and listener.ora are all right. Have I missed something? Thanks JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: parallel import
Hi Paul thnq for responding. It is oracle 8.1.7 on solaris box (2.7) The database is small ( 16 Gig), and used for majorly querying. No massive inserts/updates for these databases. The table was exported without parallel degree clause. THe whole data is in a single dmp file. It is a 700M file and normally taking 12-15 hrs to do imp. I dropped my indexes and disabled triggers on that table. (Had I enabled all these the import would be 2 days :-) ) I exported the table using DIRECT=Y for fast export. It took 1 hr 30 minutes. Is it required to set PARALLEL_MIN_SERVERS and MAX_SERVERS in init for doing parallel executions.? And can you post me the syntax for paralle exp / imp ? srinivas -Original Message- Sent: Saturday, December 08, 2001 1:30 PM To: Multiple recipients of list ORACLE-L Tatireddy, Shrinivas (MED, Keane) wrote: Hi lists, Is there a parallel import into table / schema . ? no. (The table/tables have primary keys as well as indexes ) (need to finish the import in less time, than traditional import ) Thnx in advance srinivas you did not specify a version of Oracle server. bad practice. if the table was created as having a parallel degree, then the create statement in the dump file should likely reflect that - however - if the data is in a single dump file, the import will likely be limited by the read rate of the dump and by the fact that the data is being read, parsed and executed in a non-direct fashion. create a dump file for one table that has a parallel degree, import it with a show=Y and examine the DDL/DML. Kirti posted tips for import/export that was quite good. I would suggest examining the list archives for postings by Kirti with export and import. Unfortunately, I don't have my Performance 101 book here at home - I think he covered this in there also. Import is import.exe - the only other ways are to unload the data (by various methods) and reload via SQL Loader, or copy across a db_link (not recommended). 0. C:\ imp help=y 1. can you break up the export into multiple schemas? (owner=schema1) that is the easiest way to parallelize the import, where each schema gets it own tablespace with datafiles on independent storage volumes, reading from a dump file on independent storage volumes. 2. can you break the export up by table (owner=schema1, tables = (table_name1,...,table_namen) and execute those simultaneously? 3. don't have the indexes created by import - alter the DDL used to create them such that they are created with a parallel degree that you desire. This could be accomplished with the INDEXFILE parameter. Also create them as nologging. 4. only have a small number of large rollback segments online, as you can't specify a rollback segment to be used during import. 5. what are you wait events during import - redo and archived redo log? - rollback segment allocation? - checkpoints? - recursive sql? 6. are your extents properly sized? are you using locally managed tablespaces check out AskTom at ttp://asktom.oracle.com e.g.: http://asktom.oracle.com/pls/ask/f?p=4950:8:317629::NO::F4950_P8_DISPLAY ID,F4950_P8_CRITERIA:1574966483719,%7Bimport%7D hth, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: statspack interpretations
Hi Williams, Thnq for responding. 1) I need to tune the sql statemnet that have the queries using high load %. 2) and need to look into the other issues too. like instance details etc. One of the list member Raj sent the documents. I am looking into them. I think they will help for me. If not , I will go for the books that you suggested. Thanx and Regards, Srinivas -Original Message- Sent: Thursday, December 06, 2001 3:29 PM To: Multiple recipients of list ORACLE-L Srinivas - - I assume that you have the Oracle Magazine articles. If not, they are available on-line. - I'm confused (easily done). You say that you are tuning SQL statements that statspack has identified and you want more information on statspack report interpretation. To me that is two separate issues. - How statspack identifies the top SQL statement offenders is pretty straightforward. There are good books on SQL statement tuning. I don't have a favorite at the moment, perhaps someone will - I haven't seen many resources on interpreting the rest of the statspack report. - Take a look at Don Burleson's book Oracle High-Performance Tuning with Statspack. He offers many scripts to present Statspack results in different forms. His main thesis is that Statspack should be run over a period of time and the results reviewed to see what are the critical performance periods for your system. I didn't find his tuning advice as strong, but then I haven't found anyone that discusses server tuning well. There is a new movement to go from examining ratios (like the statspack report) to examining waits. Hope this helps. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 9:20 PM To: Multiple recipients of list ORACLE-L Hi lists, I have a request to tune the sql statements that are generated in the statspack report. I have a puff document on statspack. But it is of only 7 pages and explains only how to install and run statspack. Does anybody have any document / link for statspack report intepretations. if yes, can you please forward. Thnx and Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
rollback for temp tablespace
Hi lists, Can anybody clarify this: Do the sort/idx rebuild etc.,(tasks that use temp tablespace), use rollback segments? I need to rebuild indexes of 20 Gig to a new tablespace. Do I need to verify the RBS free space for this.? Thnx and Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rollback for temp tablespace
By the way Does this process (rebuilding of indexes) generate redo? Srinivas -Original Message- Sent: Wednesday, December 05, 2001 6:30 AM To: Multiple recipients of list ORACLE-L They do use some rollback but not the volumes you'd typically need to worry about. The rollback space is for mods to the data dictionary as your segments are created. hth connor --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists, Can anybody clarify this: Do the sort/idx rebuild etc.,(tasks that use temp tablespace), use rollback segments? I need to rebuild indexes of 20 Gig to a new tablespace. Do I need to verify the RBS free space for this.? Thnx and Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Nokia 5510 looks weird sounds great. Go to http://uk.promotions.yahoo.com/nokia/ discover and win it! The competition ends 16 th of December 2001. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
statspack interpretations
Hi lists, I have a request to tune the sql statements that are generated in the statspack report. I have a puff document on statspack. But it is of only 7 pages and explains only how to install and run statspack. Does anybody have any document / link for statspack report intepretations. if yes, can you please forward. Thnx and Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: simple sql problem
b'coz you have to type select * from v\$instance;
you are passing arguments from shell. You have to escape $ like \$
HTH
-Original Message-
Sent: Tuesday, December 04, 2001 3:50 AM
To: Multiple recipients of list ORACLE-L
Even using like this:-
echo select * from v$instance; | sqlplus system/manager
gives me the error :-
SQL select * from v
*
ERROR at line 1:
ORA-00942: table or view does not exist
Though I can do the same sql statement from inside sqlplus with ease, so
why does it give table or view does not exist?
I am confused ..
rgds,
--
On Mon, 03 Dec 2001 21:50:17
Ross Collado wrote:
I don't believe SQLPlus will let you run a SQL statement in the command
line
itself. As you can see in Usage:, it doesn't have an option for this.
However, if you insist on running SQL statements in the command line
itself,
you can probably do something like (only in Unix):
sqlplus -s scott/tiger !
select * from emp;
!
or
save your select * from emp; to a sql file and do :
sqlplus -s scott/tiger @myfile.sql
hth
Ross
-Original Message-
From: Viraj Luthra [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 4 December 2001 16:11
To: Multiple recipients of list ORACLE-L
Subject: simple sql problem
Hello all,
Why cannot I do :-
sqlplus -s scott/tiger select * from emp;
or sqlplus -s scott/tiger select * from emp;
Both the cases I get :-
Usage: SQLPLUS [option] [user[/password] [@host]]
[@startfile [parm1] [parm2] ...]
where option ::= { -s | -? }
-s for silent mode and -? to obtain version number
What is wrong above? I need to run the query from command
line. How do I modify this :-
sqlplus -s scott/tiger select * from emp;
Rgds,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
background processes
Hi lists, Can anybody guess the following background processes? ora_s000_ora8 ora_s001_ora8 ora_s002_ora8 ora_p000_ora8 ora_p001_ora8 ora8 is instance. Thnx and Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: space used by pinned objects
try this:
select sum(sharable_mem)
from v$db_object_cache
where type in ('PACKAGE')and kept='YES';
srinivas
-Original Message-
Sent: Wednesday, December 05, 2001 1:55 AM
To: Multiple recipients of list ORACLE-L
I've pinned some procs that were being loaded very frequently.
How can I determine how much space they are using in the shared pool and
that I
have plenty of space left in the shared pool? I like pinning objects,
but I
don't want to end up with a shared pool contiguous memory problem.
Thanks.
Doug
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Doug C
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: simple sql problem
try this
$ echo select * from emp; | sqlplus scott/tiger
srinivas
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 2:31 AM
To: Multiple recipients of list ORACLE-L
You can't have the SQL statements on the command line. You must put
them
in
a script file (eg myscript.sql) and execute it with the @ sign.
Thus,
sqlplus -s scott/tiger @myscript[note the SPACE between the tiger
and
the @].
Hemant
Viraj Luthra [EMAIL PROTECTED] 04/12/2001 01:10 PM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)
Subject: simple sql problem
Hello all,
Why cannot I do :-
sqlplus -s scott/tiger select * from emp;
or sqlplus -s scott/tiger select * from emp;
Both the cases I get :-
Usage: SQLPLUS [option] [user[/password] [@host]]
[@startfile [parm1] [parm2] ...]
where option ::= { -s | -? }
-s for silent mode and -? to obtain version number
What is wrong above? I need to run the query from command line. How do I
modify this :-
sqlplus -s scott/tiger select * from emp;
Rgds,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
[This e-mail is confidential and may also be privileged. If you are not
the
intended recipient, please delete it and notify us immediately; you
should
not copy or use it for any purpose, nor disclose its contents to any
other
person. Thank you.]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
killing system user
Hi lists, Solaris 2.7 oracle 8i I have a session SYSTEM doing import into a table. (logged into server thru telnet from win 98 PC) Suddenly the power outage occurred to my PC. When I logged into the server thru telnet, I found that the session is active. By mistake, I killed the process at o/s level. For somereasons,I tried to drop the table. But I failed to do it, as it is locked by import process. I tried to kill the user SYSTEM. But the oracle is giving error that there is not user with such sid and serial number. The serial# number is often getting changed when I query from v$session. Is there a way to kill this user, without shutting down the database. And why different serial# number each time, I query v$SESSION.? Any clues? Thnx and Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
total tranx ran
Hi lists, Does anybody have a query to find , how many transactions ran since the instance started. v$transaction will have only the current trnx running. is there any other views that will show the total trnx since instance startup. Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: total tranx ran
Is there any column related to this in v$resource_limt ? -Original Message- Sent: Friday, November 30, 2001 7:05 AM To: Multiple recipients of list ORACLE-L Hi lists, Does anybody have a query to find , how many transactions ran since the instance started. v$transaction will have only the current trnx running. is there any other views that will show the total trnx since instance startup. Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Deleting files on w2k
Title: Deleting files on w2k Hi I got this problem many times,when I wokred on win95/98. To resolve this, I used to take the TS offline, shutdown db and windows and restart them and did rename. This worked for me. Srinivas -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 6:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Deleting files on w2k Lisa, you can take it offline, and it may release it. on NT, it does not release the file unless it is not in use. W2k might be different. Tom Mercadante Oracle Certified Professional -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 3:40 PMTo: Multiple recipients of list ORACLE-LSubject: Deleting files on w2k I'm trying to test out backup and recovery on w2k. However, I can't remove or rename a file while the database is running! It says "file in use". Am I missing something or is there a way to force this? Thanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117
RE: total tranx ran
This will give the peak usage of the transactions, since instance started, but not the cumulative. -Original Message- Sent: Friday, November 30, 2001 1:41 PM To: Multiple recipients of list ORACLE-L if you're using Oracle 8 check v$resource_limit.transactions view HTH Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 30, 2001 7:05 AM Hi lists, Does anybody have a query to find , how many transactions ran since the instance started. v$transaction will have only the current trnx running. is there any other views that will show the total trnx since instance startup. Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Not able to view table
In oracle what ever the case we use while creating object name, the data dict willbe updated in upper case. eg: emp/Emp/EMP are all same for oracle. (if table is created without double quotes. eg: create table emp (col1 , col2 ..) But in any case if we want to create any object with specific case we have to put them in double quotes. Next time when you query the object you have to use the same convention. eg: emp / Emp / EMP are different one from the other. create table emp (col1 col2 ) if you select select * from emp; you cant see anything. you have to select selecdt * from emp; HTH Srinivas -Original Message- Sent: Friday, November 30, 2001 3:26 PM To: Multiple recipients of list ORACLE-L Mark, I am a really confused with your last statement. Have you tried either of the following: select * from tblBundleCon; select * from 'tblBundleCon'; If you really did create them in lower and upper case, this could be your problem. Enclosing the table names in double quotes usually solves this.. Would you or someone else elaborate on this, pleeaassee? Are we still talking Oracle here -Original Message- Sent: Friday, November 30, 2001 7:25 AM To: Multiple recipients of list ORACLE-L Jyoti, Did you create the tables as SYSTEM? One thing I will say is that *YOU SHOULD NOT DO THIS*. When creating objects as SYSTEM, these objects will be stored in the SYSTEM tablespace - which is not a good idea. As system, create another tablespace (if one does not already exist), create a new user, with a default tablespace of the new tablespace, and use this user (with the appropriate system/object privileges) to create your tables/indexes/objects. On to another point about your mail - the password for SYSTEM is actually the default. How about changing that for security reasons? This may just be a test box, but there's nothing like good safe practice. Back to the original question: Who were you logged on as when you created the tables? Where did you create them? (tablespace). Have you tried either of the following: select * from tblBundleCon; select * from 'tblBundleCon'; If you really did create them in lower and upper case, this could be your problem. Enclosing the table names in double quotes usually solves this.. HTH Mark -Original Message- Sent: 30 November 2001 06:50 To: Multiple recipients of list ORACLE-L Hi all, I have created with the following details: Global DB name: manu.ifpjyo SID:manu Username: SYSTEM Password:manager Tables:tblBundleCon, tblTextCon, tblFinalImage I am able to connect to the database: SQL connect system@manu password: *** Connected. But I am unable to view the tables that I have created: SQLselect * from tblBundleCon; * ERROR at line 1: ORA-00942: table or view does not exist I get the above error. Where am I going wrong, Thanx a lot in advance. Jyoti. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Doubts reg :Export and import
If we use compress=y in export, it will compress the whole table table data into a single extent. if not, the table will be exported as is with same extent sizes. you must be carefule to use compress=y. 'coz in the target, while doing import, your import may fail,if it doesnt find contiguous space to allocate such a big extent for that table.(if the source table is very big) eg: exported table size is 2 gig. Can your system find 2 Gig contiguous space in the target.? (as this is a single extent) HTH Srinivas -Original Message- Sent: Saturday, December 01, 2001 12:45 AM To: Multiple recipients of list ORACLE-L The compress=y compesses your brain while it exports, if you dont want you brain compressed then do compress=n. But if your brain is all ready in a compressed state, then they work the opposite. joe Alex Hillman wrote: Another one that apparently has access to e-mail but not to the internet to RTFM :-) . Or maybe s/he knows how to write but cannot read or maybe can read e-mails but cannot read FM etc. Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of sangeetha Sent: Wednesday, November 28, 2001 12:16 PM To: Multiple recipients of list ORACLE-L Subject: Doubts reg :Export and import hi list, what is the exact use of mentioning 'compress' yes or no while exportingwill this store the .dmp file in compressed format in system,if given 'yes'. while importing the dumpfile why is it necessary to give 'fromuser',is 'touser' not enough. sangeetha __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sangeetha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing) -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Determinants of control file
Title: Determinants of control file Hi Nirmal, Use alter database backup controlfile to trace; You can find these details in the trace file, that will be dumped to your udump destination. HTH Srinivas. -Original Message-From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 29, 2001 7:52 AMTo: Multiple recipients of list ORACLE-LSubject: Determinants of control file Hi all, The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., But after creation of control files, where should i get details about these parameter values?... i checked in v$controlfile and v$database... i didn't get enough info on it. And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files. Where will i get the sequence# of other control files then... Nirmal,
RE: backup unix script
should we say the ! is a tag like EOF(what we normally use). srinivas -Original Message- Sent: Thursday, November 29, 2001 4:37 PM To: Multiple recipients of list ORACLE-L Hi grace it basically means that log in to sql*plus and execute whatever is below this line till you hit bang(!) .. literally. Deepak --- grace [EMAIL PROTECTED] wrote: hi gurus, I found this unix script ... can any tell me what this means? sqlplus - sys/msd filename.dat ! does anyone have a unix script to perform a database backups? Best Regards, Grace Lim Suy Sing Comm'l Corp. (632)-2474134 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analyze only latest partition
Hi Connor
Thanq for responding.
In dba_tab_partitions there is no such column like partition_id, and I
would like to generate a list at schema level for each table.
That means, this script should capture the latest (last) partitions for
each table (if it is partitioned) for a given schema.
Is there a way?
I tried with the following query. But there is some bug in that. It is
not capturing the last partition (in a whole database):
select object_name,owner ,subobject_name from dba_objects
where data_object_id in (select data_object_id from
dba_objects where created in(select max(created)
from dba_objects ) and data_object_id is not null);
Can anybody debug this.?
Thnx and Regards,
Srinivas
-Original Message-
Sent: Wednesday, November 28, 2001 7:30 AM
To: Multiple recipients of list ORACLE-L
declare
pname varchar2(100);
begin
select partition_name
into pname
from user_tab_partitions
where table_name = ...
and partition_id =
( select max(partition_id)
from user_tab_partitions
where table_name = ... );
execute immediate 'analyze table ... partition
('||pname||')';
end;
or something similar to that..
hth
connor
--- Tatireddy, Shrinivas (MED, Keane)
[EMAIL PROTECTED] wrote: Hi lists,
Is there a script/command to analyze only the latest
partition of my
table. It has several partitions. For every month
1(one) partititon gets
created to store that months data.
Can anybody throw some script.?
Thnx and Regards,
Srinivas
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
(858) 538-5051
San Diego, California-- Public Internet
access / Mailing Lists
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(or the name of mailing list you want to be removed
from). You may
also send the HELP command for other information
(like subscribing).
=
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
Some days you're the pigeon, some days you're the statue
__
Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email
and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Virtual NC on Solaris box
Hi lists, Does anybody using VNC (Virtual network computing) provided by ATT. Platform : Server solaris 5.6 Client : win 98 Can it be used instead of Xwindows? Does this work in a low speed networks? any ideas ? pros ? cons? Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Listener problems
Hi lists, I have some problem with my listener. That is resolved with the help of metalink. But I have a doubt in this regard. When I try to see the status, lsnrctl status 816LISTENER the statement hung for 10 minutes. I checked metalink and found the solution was, probably the size of listener.log is very big. So archive/remove it. In the mean time , this was resolved by another group of DBAs. In such a situations how to create another listener.log. If I stop/start the listener, this will affect the clients who are running trnx. how do i create another log. And how to know the size of listener.log (There is no parameter for this) is is o/s dependent? Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
aps_data_files
Hi lists, In what way aps_data_files differ from dba_data_file? what this aps_data_files view store in data dictionary? can anybody throw some light? Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Repairing corrupt datablocks
Hi lists,
I tried execting the dbms_repair with the following steps:
sql variable x number;
sql exec dbms_repair.check_object('SCOTT','EMP',:x);
it is giving the error:
PLS-00306: wrong number or types of arguments in call to 'CHECK_OBJECT'
can anybody tell me how to execute this procedure.
Thnx and Regards,
Srinivas
+
Hello
By using DBMS_REPAIR.CHECK_OBJECT I have found 3 corrupt datablocks in
our
database, all with error: Block Checking: DBA = 184607007, Block Type =
KTB-managed data block
kdbchk: the amount of space used is not equal to block size
used=8169 fsc=0 avsp=112 dtl=8120
My plan now is to fix these data blocks. I have never done this before,
so I
consulted my Oracle manual and the manual recomends the following:
First run DBMS_REPAIR.CHECK_OBJECT on the object to find out if the
object
contains any corrupt blocks. Then I run DBMS_REPAIR.FIX_CORRUPT_BLOCKS
to
mark the block as corrupt. After that run DBMS_REPAIR.DUMP_ORPHAN_KEYS
to
dump all the index references to these blocks. Then run
DBMS_REPAIR.SKIP_CORRUPT_BLOCKS on the object, and after that recreate
the
table.
By doing this the corrupt blocks are removed from the object.
Now I have some questions about this. (My environments is a Oracle 8.1.7
on
a Windows 2000 Advanced Server):
Is this a good way, or is there a better way?
Can I access the data in the corrupt blocks in anyway so I can se whats
in
the blocks? I'm afraid that i will loose some data by doing it this way.
Regards Jonas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonas A Wetterberg
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
hide password
Hi lists,
We can see users password using
ps -ef |grep sqlplus
(if we run a job using sqlplus scott/tiger @${runfile} ).
To prevent this we can run our code
sqlplus -s EOF
scott/tiger
@${runfile}
EOF
Is there a similar way in export hiding the password (preventing users
to see the password) . I tried it with EOF. But its not working.
I need to setup the export in cron.
can anybody through some light on this.
Thnx and regards,
Srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: hide password
Can you explain in detail how to use a controlfile in exports?
thnx and regards,
Srinvias
-Original Message-
Sent: Thursday, November 15, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L
Hi,
Use a controlfile.
Jack
Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED]
@fatcity.com on 15-11-2001 14:10:26
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Hi lists,
We can see users password using
ps -ef |grep sqlplus
(if we run a job using sqlplus scott/tiger @${runfile} ).
To prevent this we can run our code
sqlplus -s EOF
scott/tiger
@${runfile}
EOF
Is there a similar way in export hiding the password (preventing users
to see the password) . I tried it with EOF. But its not working.
I need to setup the export in cron.
can anybody through some light on this.
Thnx and regards,
Srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie
aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst
Young, niet toegestaan. Ernst Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht,
noch
voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat
een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de
verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.
Ernst Young hanteert bij de uitoefening van haar werkzaamheden
algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this
communication
without the authority of Ernst Young. Ernst Young is neither liable
for
the proper and complete transmission of the information contained in
this
communication nor for any delay in its receipt. Ernst Young does not
guarantee that the integrity of this communication has been maintained
nor
that the communication is free of viruses, interceptions or
interference.
If you are not the intended recipient of this communication please
return
the communication to the sender and delete and destroy all copies.
In carrying out its engagements, Ernst Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY
RE: hide password
But (while performing exp) when we grep from os it will display like
ps -ef |grep exp
result: exp parfile=/ora8/par1
so, somebody can do a more and find the password from the par1 file.
Is there any better alternative?
Thnx and regards,
Srinivas
-Original Message-
Sent: Thursday, November 15, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L
Jack,
I think you are referring to PARFILE...
Suren
-Original Message-
Sent: Thursday, November 15, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L
Hi,
Use a controlfile.
Jack
Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED]
@fatcity.com on 15-11-2001 14:10:26
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Hi lists,
We can see users password using
ps -ef |grep sqlplus
(if we run a job using sqlplus scott/tiger @${runfile} ).
To prevent this we can run our code
sqlplus -s EOF
scott/tiger
@${runfile}
EOF
Is there a similar way in export hiding the password (preventing users
to see the password) . I tried it with EOF. But its not working.
I need to setup the export in cron.
can anybody through some light on this.
Thnx and regards,
Srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie
aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst
Young, niet toegestaan. Ernst Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht,
noch
voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat
een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de
verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.
Ernst Young hanteert bij de uitoefening van haar werkzaamheden
algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this
communication
without the authority of Ernst Young. Ernst Young is neither liable
for
the proper and complete transmission of the information contained in
this
communication nor for any delay in its receipt. Ernst Young does not
guarantee that the integrity of this communication has been maintained
nor
that the communication is free of viruses, interceptions or
interference.
If you are not the intended recipient of this communication please
return
the communication to the sender and delete and destroy all copies.
In carrying out its engagements, Ernst Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tirumala, Surendra
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
RE: hide password
Only system schema will run our exports.
srinivas
-Original Message-
Sent: Friday, November 16, 2001 2:00 AM
To: Multiple recipients of list ORACLE-L
how about os authentication ...
create user ops$oracle identified externally;
grant dba to ops$oracle;
exp / blah blah blah
hth
Deepak
--- Tatireddy, Shrinivas (MED, Keane)
[EMAIL PROTECTED] wrote:
But (while performing exp) when we grep from os it
will display like
ps -ef |grep exp
result: exp parfile=/ora8/par1
so, somebody can do a more and find the password
from the par1 file.
Is there any better alternative?
Thnx and regards,
Srinivas
-Original Message-
Sent: Thursday, November 15, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L
Jack,
I think you are referring to PARFILE...
Suren
-Original Message-
Sent: Thursday, November 15, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L
Hi,
Use a controlfile.
Jack
Tatireddy, Shrinivas (MED, Keane)
[EMAIL PROTECTED]
@fatcity.com on 15-11-2001 14:10:26
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:(bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
Hi lists,
We can see users password using
ps -ef |grep sqlplus
(if we run a job using sqlplus scott/tiger
@${runfile} ).
To prevent this we can run our code
sqlplus -s EOF
scott/tiger
@${runfile}
EOF
Is there a similar way in export hiding the password
(preventing users
to see the password) . I tried it with EOF. But its
not working.
I need to setup the export in cron.
can anybody through some light on this.
Thnx and regards,
Srinivas
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
(858) 538-5051
San Diego, California-- Public Internet
access / Mailing Lists
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(or the name of mailing list you want to be removed
from). You may
also send the HELP command for other information
(like subscribing).
=
De informatie verzonden in dit e-mailbericht is
vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde.
Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking
van deze informatie
aan
derden is, behoudens voorafgaande schriftelijke
toestemming van Ernst
Young, niet toegestaan. Ernst Young staat niet in
voor de juiste en
volledige overbrenging van de inhoud van een
verzonden e-mailbericht,
noch
voor tijdige ontvangst daarvan. Ernst Young kan
niet garanderen dat
een
verzonden e-mailbericht vrij is van virussen, noch
dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst
van onbevoegde derden.
Indien bovenstaand e-mailbericht niet aan u is
gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te
retourneren aan de
verzender
en het origineel en eventuele kopieën te verwijderen
en te vernietigen.
Ernst Young hanteert bij de uitoefening van haar
werkzaamheden
algemene
voorwaarden, waarin een beperking van
aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos
toegezonden.
=
The information contained in this communication is
confidential and is
intended solely for the use of the individual or
entity to whom it is
addressed. You should not copy, disclose or
distribute this
communication
without the authority of Ernst Young. Ernst
Young is neither liable
for
the proper and complete transmission of the
information contained in
this
communication nor for any delay in its receipt.
Ernst Young does not
guarantee that the integrity of this communication
has been maintained
nor
that the communication is free of viruses,
interceptions or
interference.
If you are not the intended recipient of this
communication please
return
the communication to the sender and delete and
destroy all copies.
In carrying out its engagements, Ernst Young
applies general terms and
conditions, which contain a clause that limits its
liability. A copy of
these terms and conditions is available on request
free of charge.
=
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
(858) 538-5051
San Diego, California-- Public Internet
access
select from dual?
Hi lists
Whats wrong with the following statement:-
select 30,'where name in ('NAME1','NAME2')' || ' ;' from dual;
where as the following is working fine:
select 30, 'where id in (10,20)' || ' ;' from dual;
can anybody throw some light?
thanx in adv
srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: how to find files that are generated on a particular date
sorry forgot to mention that it is Solaris. -Original Message- Sent: Monday, November 12, 2001 2:35 AM To: Multiple recipients of list ORACLE-L Hi lists does anybody can post me a command In unix how can I find files generated on a particulat date example files generated on Nov 10 regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: V$PWFILE_USERS
The v$pwfile_users generates an internal error if the client process fetched from it directly more than once. If only a single fetch is done that retrieves all the rows needed, then it works fine. An order by clause will allow the sort step to fetch all rows in a single call, and then it does not matter how many fetches the client process does, the sort already completed the fetch from v$pwfile_users. ora-600 [1113] SELECTING FROM V$PWFILE_USERS IF MORE THAN 14 SYSDBA USERS 1: Use SVRMGRL 2: When SQL*Plus must be used, use an order by clause: SQL select * from v$pwfile_users order by 1; . HTH Srinivas -Original Message-From: Riswandi [mailto:[EMAIL PROTECTED]]Sent: Friday, November 09, 2001 1:40 AMTo: Multiple recipients of list ORACLE-LSubject: V$PWFILE_USERS Hi, Does anybody knows what the error below means or how te solve the problem? 007 select * from V$PWFILE_USERS;ERROR:ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], [] no rows selected 007 SELECT * FROM SYS.V_$PWFILE_USERS;ERROR:ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], [] no rows selected 007 brgrds, Risc
tablespace not turning into read only mode
Hi lists, I am trying to put my tablespace into read only mode(This is to take the transport tablespace export). When i typed alter tablespace xyz read only; it is just getting hung. Even after an hour the command is not being executed. There are no users accessing the objects in that tablespace. But there are users, using someother objects in other tablespaces. why oracle cannot turn the tablespace into read only mode? Thnx and regards srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
inactive sessions
Hi can anybody tell me when a sessions status becomes INACTIVE in v$session? thnx and regards, srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
column comments for v$ and x$ tables
Hi lists Is there a way to see the description of the column,means what value the column stores for v$, x$ tables. eg: desc v$session we will see the column like... SADDR SID SERIAL# AUDSID PADDR USER# USERNAME COMMAND OWNERID TADDR SQL_ADDRESS SQL_HASH_VALUE PREV_SQL_ADDR PREV_HASH_VALUE MODULE MODULE_HASH how to find out what the column is and what value it stores. i cannot find anything in dba_col_comments. thanx in advance, srinvias -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Dead locks
Hi lists, If a dead lock occurs , will the statements be rolledback by oracle ? will oracle do anything other than dumping trace? I tried. But both session never comeout. Just they hung. Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
recreate controlfile
Hi lists, Can anybody tell explain me this: We would re-create a controlfile to make a new copy of the database with another name. I tried to create a new db from existing database coldbackup . But I tried to recrete with only one datafile i.e. system datafile. I skipped all the remaining datafiles. I tried it twice. It is saying recover the datafile using backup controlfile. when I tried to recover it, it returning that the file is not restored from a sufficient backup. (But the datafile backup is taken from cold backup) is there a way to just re-create a controlfile (using a single datafile system. if not, at least how many minimum of datafiles i need to recreate a controlfile from the backup set.) Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Find out export from remote locations
But the client database is 8.1.5 and the server is 8.1.7 srinivas -Original Message- Sent: Monday, October 22, 2001 7:55 AM To: Multiple recipients of list ORACLE-L If you're using a 8.1.7 version of the database with a 8.0.5 version of the Client, it's normal. You've to apply the patch. -Message d'origine- De : Tatireddy, Shrinivas (MED, Keane) [mailto:[EMAIL PROTECTED]] Envoyé : lundi 22 octobre 2001 12:20 À : Multiple recipients of list ORACLE-L Objet : RE: Find out export from remote locations In V$session I am able to find only the session that is connected. But it is not showing anything in program column. Can I find the program, that is being executed(here it is export) from any table? srinivas -Original Message- Sent: Monday, October 22, 2001 6:31 AM To: Multiple recipients of list ORACLE-L Query the V$session table in Server2. -- On Mon, 22 Oct 2001 00:50:18 Tatireddy, Shrinivas (MED, Keane) wrote: Hi lists, Is there any way to find out if any session is doing export from a remote shell. eg: I am performing this from SERVER1 exp userid=sys/pwd@connect_str_ON_SERVER2 file=/tmp/file.dmp log=/tmp/file.log tables=scott.emp this I am doing from my local database to a remote server. I am able to do perform export. Is there any table to find the above information(IN EITHER SERVER1 OR SERVER2), means a user is performing export on the database. Thnx and regards srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Find out export from remote locations
In V$session I am able to find only the session that is connected. But it is not showing anything in program column. Can I find the program, that is being executed(here it is export) from any table? srinivas -Original Message- Sent: Monday, October 22, 2001 6:31 AM To: Multiple recipients of list ORACLE-L Query the V$session table in Server2. -- On Mon, 22 Oct 2001 00:50:18 Tatireddy, Shrinivas (MED, Keane) wrote: Hi lists, Is there any way to find out if any session is doing export from a remote shell. eg: I am performing this from SERVER1 exp userid=sys/pwd@connect_str_ON_SERVER2 file=/tmp/file.dmp log=/tmp/file.log tables=scott.emp this I am doing from my local database to a remote server. I am able to do perform export. Is there any table to find the above information(IN EITHER SERVER1 OR SERVER2), means a user is performing export on the database. Thnx and regards srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Transportable tablesapce export on remote server
Hi lists can anybody shed light on this: I have a situation, doing mirroring the schemas from one server to another server. both databases on the servers are same version 8.1.7 I need to perform export (of server2) from server1 using transportable tablespace I am issuing the flwng command: exp userid=\'sys/password@remotedb as sysdba\' file=/tmp/abc log=/tmp/abc transport_tablespace=y tablespaces=users Prior to this I put the users tablespace in read only mode. Both databases have set remote_login_passwordfile=exclusive But when I do export usiing the above command, is is asking username and password. when I type correect password also, it is not getting exported. But I am able to connect as connect internal@remotedb password:* Now I am able to connect to remote server as sysdba. But cannot perform the export of transportable tablespace. Os: Solaris DB: 8.1.7 Can anybody post me the solution. regards, srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
schema refreshes (transport tablespace)
Hi lists, Can anybody post me the command to run the following: I need to perform rcp at shell (Solaris) for 50 files. This is part of schema refreshes/mirrorings using transport tablespace utility. I am submitting a file that has 50 rcp commands like rcp srvr1:/u01/f1 srvr2:/u01/f1 rcp srvr1:/u01/f2 srvr2:/u01/f2 rcp srvr1:/u01/f3 srvr2:/u01/f3 rcp srvr1:/u01/f4 srvr2:/u01/f4 .upto 50 lines. when I submit this, system is executing only 1 rcp at a time. But I need to do rcp 2 files at a time. So I chose another alternative. rcp srvr1:/u01/f1 srvr2:/u01/f1 rcp srvr1:/u01/f2 srvr2:/u01/f2 rcp srvr1:/u01/f3 srvr2:/u01/f3 rcp srvr1:/u01/f4 srvr2:/u01/f4 ...upt0 50 lines. But in this , the system is not doing rcp 2 at a time. It is taking 3 or 4 or 1 at a time. Is there a way to execute 2 rcp's at any time. using any shell command. thnx in advance. srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
orapwd utility
Hi lists, Can anynbody tell me this orapwd utility. is there any relation tothis password utility and grant a user SYSDBA/SYSOPER? if i need to grant to user SYSDBA , do i need to create password file. regards sriniva -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Restricted mode
Youcan issue a command svrmgrlalter system enable restricted session; - this moves the db into restricted mode. - but this will not affect the existing logged users. svrmgrlalter system disable restricted session; -- removes the disable mode and allows the users to log in srinivas -Original Message- Sent: Friday, October 05, 2001 10:35 AM To: Multiple recipients of list ORACLE-L Is there a way to change a database from being up in restricted mode to open for all without shutting down and restarting? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe LaCascio INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
date diff at os level
Hi lists can anybody post me this: I need to find out the date at O/s level between 2 dates. i.e. 01-jan-99:10:22:45 and 02-jan-99:09:23:50 O/s : Solaris thnx in adv srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: export problems in transportable tablespace
yes, it is working I have one more doubt. Is a password file required to use sysdba privilege. means creating a password file using orapwd utily. orapwd file=/tmp/xyz password=abc entries=n -Original Message- Sent: Thursday, October 04, 2001 10:25 AM To: Multiple recipients of list ORACLE-L The command must be: exp userid=\'system/password@remotelink as sysdba\'.. The sysdba priv has to be after the connection link. Regards. --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists, O/s: Solaris Oracle : 8.1.6 can anybody post the solution for this: I need to perform an export on a remote server for transportable tablespace option: I used this: exp userid=\'system/password as sysdba@remotedblink\' file=/tmp/abc.dmp log=/tmp/kvn.log transport_tablespace=y tablespaces=abcdef the following error occured : LRM-00112: multiple values not allowed for parameter 'userid' I tried : exp userid=\'system/password as sysdba\'@remotedblink file=/tmp/abc.dmp log=/tmp/kvn.log transport_tablespace=y tablespaces=abcdef now giving error wrong username and password. I must use the sysdba option becoz , need to do exp of transportable tablespace option, and I must use @dblink to perform the export on a remote server. can anybody tell me the solution for the above? or anyother alternatives. srinivas. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
running catlog,catproc
Hi lists Is it mandatory that catlog.sql, catproc.sql should be run while database is in restricted mode. should I run them while db is running in normal mode (users are logged in )? any problems!!! errors !!! regards, srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
log file size change
Hi lists, I need to do a refresh of the database (different servers) in the source my logfile size is 25 Meg and I want to change it to 5 Meg in the target and recreate the db using controlfile. I copied all files to target server, what should I change in the trace dump of controlfile. should I use logfile 'file1','file2' size 5 M reuse. ( Note: I use reset logs) regards, srinivas. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix Cron Job
see this * 1 * * * /mydir/myfile put the above line in your crontab with your filename. and that will run everyday 1.00 am. srinivas -Original Message- Sent: Wednesday, October 03, 2001 1:55 PM To: Multiple recipients of list ORACLE-L man cron Regards Lee -Original Message- Sent: 03 October 2001 17:21 To: Multiple recipients of list ORACLE-L Hi List, I am not a Unix person and want to scheduled a batch job to run on Unix machine every night at 1:00 AM, if you have any script for this or similar really appreciate. Thanks in Advance Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Background jobs inUnix
Hi Suhen, I guess the flwng is the syntax: $ mknod -p /mydir/pipe_file 200m $ exp user/passwd file=pipe_file tables=abc correct me if I am wrong thanq srinvias -Original Message- Sent: Tuesday, October 02, 2001 3:25 AM To: Multiple recipients of list ORACLE-L Srinivas, Try using nohup compress /u01/dmps/zvr_dd.dmp It should not be a problem to close your Unix session. I have not had any problems with the Unix compress utility on Oracle Dump files. You could also compress while you export using names pipes. Let me know if you want the syntax. Regards Suhen Hi Lists, Shall I close the unix session after submitting my job (compressing the dmp file after importing) in the background on solaris. $ compress /u01/dmps/zvr_dd.dmp is this harmful ? (like killing the running jobs) thnx in adv srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
find out ip
Hi lists How to find out a server (solaris) IP address, that I logged in . Any command ? thanx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: find out ip
Thanks a lot -Original Message- Sent: Tuesday, October 02, 2001 5:15 AM To: Multiple recipients of list ORACLE-L $ who am i root pts/12 obre 2 09:11 (192.168.11.33) Regards. --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists How to find out a server (solaris) IP address, that I logged in . Any command ? thanx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Background jobs inUnix
Thnx everybody, this will help me in future. -Original Message- Sent: Tuesday, October 02, 2001 10:25 AM To: Multiple recipients of list ORACLE-L that will kill the job... if you want it to continue after you log out, you should run: nohup compress /u01/dmps/zvr_dd.dmp this will allow it to run disconnected from a terminal and will continue after you log out. You will get the message you have running jobs when you type exit, just type exit again. --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi Lists, Shall I close the unix session after submitting my job (compressing the dmp file after importing) in the background on solaris. $ compress /u01/dmps/zvr_dd.dmp is this harmful ? (like killing the running jobs) thnx in adv srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: please help me to unlock a table
I tried using the folloiwng command (tested manually locking a table in a sesion and tried from other session) the result is ORA-00054: resource busy and acquire with NOWAIT specified I had to manually issue rollback/commit from the session where I applied manual lock. any other solutions. srinivas -Original Message- Sent: Tuesday, October 02, 2001 7:20 AM To: Multiple recipients of list ORACLE-L Try this: Alter table table_name disable table lock; --- Ha Duy Thien [EMAIL PROTECTED] wrote: Hi all Does anyone know how to unlock a locked table? Thanks in advance Ha Duy Thien __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ha Duy Thien INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
count rows that are being imported
Hi lists, I have a tablespace that is 600 M size, has 4 million rows. It is taking nearly 2 hrs to finish the import. In the meantime, I tried selecting howmany rows imported(from another session), but every time I issue query,the result is zero. But after finishing the import I got the total count. Is there anyway to see how may rows imported in that table(in the middle or import process, from another session) ? thnx in adv. srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Background jobs inUnix
Hi Lists, Shall I close the unix session after submitting my job (compressing the dmp file after importing) in the background on solaris. $ compress /u01/dmps/zvr_dd.dmp is this harmful ? (like killing the running jobs) thnx in adv srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PL/SQL stment
Hi lists the flwng DECLARE V_sal emp.sal%type; BEGIN SELECT sal INTO v_sal FROM emp WHERE empno=p_empno; IF v_sal2000 then UPDATE emp SET sal=sal*1.2 WHERE empno=p_empno; END IF; END; When I run the above, the first time the is asking the empno. But the next time I run it is taking the same old value what I previously gave. I need to find out, where my old value is actually stored. and I need it to ask again for another value. where my old value is actually stored? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
find out the rollback
!! Please do not post Off Topic to this List !! Hi lists can anybody post me how much rollback (approx in bytes/kb/mb) will be generated if I delete my table that has 2 lakh rows. the avg row len is 50. often The query is getting failed due to the error unable to extend the rollback segment. If I have this query, at least I will use a rollback segment that has enough extents. thnx in advance. Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
alternative rows
Hi lists can anybody post me to find alternative rows in a table. 1,3,5 ... or 2,4,6 srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
shutdown trigger
HI lists can anybody throw this sql statement I need to create a trigger that will fire on shutdown (just before shutdown) of the database. It has to collect the flwng infm into a table called free_mem_prc 1. The time in minutes the system has been up( means my instance is running since 200 minuts) 2. Max no.of processes utilized by that instance (Can I get from V$resource_limit??) 3. The free memory (Can I get from v$sgastat??) the table is free_mem_prc ( anumber- this stores 1 bnumber- this stores 2 cnumber ) - this stores 3 Are there any possible bugs with shutdown triggers... ? thanx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
octal form
HI lists
when I do select
select dump('k',1010) from dual (decimal)
i get 107 as the ascii value
to get an octal we substitute 1008
in the place of 1010 and the result is 153 for 'k'.
andselect chr(107) from dual (decimal)
value is ''k'
if i use
select chr(153) from dual, giving some wrong value...
how do i convert this octal to decimal
srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
insert into table .... values....
Hi lists how to do the folloiwng inserts into a table? table xyz has col1,col2, col3. I need to populate the values to col1 from table dummy1 (cola) col2 table dummy2(colb) col3 table dummy3(colc). there is no relation between dummy1 , dummy2, dummy3. We cannot join these tables. can I insert data into xyz in a single shot. is there anything like insert into xyz values((select cola from dummy1 where), (select colb from dummy2 where), (select colc from dummy3 where ) ); srinivas. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
processes, free mem
Hi lists where can i find the 1)maximum number of processes that have connected at one time to the database. 2)the database free memory...lowest available since startup. If anybody have ideas about the above, kly reply. thanx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: FYI - another good Oracle list
earlier there was another list [EMAIL PROTECTED] -Original Message- Sent: Sunday, August 26, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Write to [EMAIL PROTECTED] and, in the text of your message (not the subject line), write: SUBSCRIBE ORACLE-L DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
tab ascii value
Hi lists how to find out the ascii value of tab, new line for new line it is 10 for tab it is 9 but how to get from the following statement. select ascii(??) from dual; srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
pl/sql examples
hi can anybody post me some sites that have example queries of pl/sql thnx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
v$sgastat
Hi lists what is the precision of the number datatype, if not in a table. is it 1 or 32. (in v$sgastat the column bytes doesn't have precision,scale mentioned. this column values should be stored in our routine tables.) If I take the maximum ,I may be wasting the space. can anybody advise how much precision do I take? and is there any way to find from what x$ tables this is (v$sgastat) built . I didnt find it is dependencies table. thnx in advance srinivas. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
compare two tables.
Hi lists while doing export import, often I need to check whether the target table has any excess columns or does the column have different datatypes/sizes from source table. as our tables have many columns it has become tedious to check every time. can anybody post me any sql or pl/sql script that will perform the above task. the query needs to perform the check on 2 tables. the tables will have same name in different schemas. but the columns in them may vary or the datatypes/sizes to same columns may vary in source and target. it has to pick out the differed columns, sizes. thanx in advance. srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
any body come across, decreasing db_block_size.
Hi lists have any body come across, decreasing db_block_size. we know that the db_block_size can be increased. to do this, usual way is export full db. create new db with new increased db_block_size and import the data into it. will this work for decrease db_block_size. my present size is 8 k now that should be decreased to 4K srinvias -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
finding free memory
Hi lists can anybody throw some light on this: when a process (bkgd/user ) starts, does it reserve memory (the memory it really requires+additional buffer) If yes, how to find out the free memory the process is not using. thnx in adv. reg srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dyn sql
Hi lists can anybody post me this query: I need to generate a dynamic sql that will create a statement to add a constraint of composite primary key . alter table xyz add constriant xyz_comp_pk (col1,col2,col3); when I generated this from dba_cons_columns i am getting the flwng: alter table xyz add constriant xyz_comp_pk (col1); alter table xyz add constriant xyz_comp_pk (col2); alter table xyz add constriant xyz_comp_pk (col3); so 2,3 will automatically fail. only first will be generated as a table should have only 1 PK. srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Duplicate rows.
hi lists can anybody tell me how to delete duplicate rows in the table. my table has 10 rows (5 sets of each 2 records) all are identical. how to delete 1 full set. I need the rows value should be distinct. I tried create table xyz as select distinct and finished the task. but this is a lengthy process. any short way? srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
No Subject
UNCUT ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
rollback tables
HI dba's can anybody tell me from which tables can i find whether my statement is generating rollback. post queries if you have.. thnx srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
is there any way to see when my table data updated?
Hi lists from where can i see when my table data is last updated? srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
avoid duplicate sql
Hi lists i need help in writing a sql query: i am trying to capture the session information from v$session and inserting the same into someother table xyz with columns username, logon_time. (scott logged in at 10:30 hrs) i put this script in cron. it runs every 30 minutes. but i need the values shoudld not be duplicated. Every time the shell script runs, it inserts values into XYZ. table. Here i need your help. The values should not be duplicated that are being insreted into xyz. since username,logon_time are composite primary key, system will not accept duplicates. Because, in the v$session, if the user stays more than 30 minutes, his values will be sent to xyz table and as already xyz has that row (inserted before 30 minutes by shell), system will deny to insert the duplicate the value into xyz. any scripts? scripts? thanx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to locate who dropped a view using log miner?
Title: RE: How to locate who dropped a view using log miner? Hi I dont find any records in v$logmnr_contents even if i dropped tables /views. Should i enable any parameter and restart db to get records. srinivas -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 07, 2001 9:06 PMTo: Multiple recipients of list ORACLE-LSubject: RE: How to locate who dropped a view using log miner? take a look at the sys.ind$ table for indexes sys.view$ for views sys.source$ for stored procedures HTH Nick Wagner Quest Software www.quest.com -Original Message- From: Mario Alberto Ramos Arellano [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: How to locate who dropped a view using log miner? Hi listers, I know most of you will advice me to turn audit on, but I like the hard way better. I've been able to locate who drops tables based on the dml operations on fixed tables. According to note 93370.1 from Oracle, the hint for locating who dropped a table is to look for a DELETE operation on SYS.COL$, SYS.OBJ$ and SYS.TAB$. I.e, SQL select scn from v$logmnr_contens 2 where operation = 'DELETE' and seg_name = 'COL$' 3 intersect 4 select scn from v$logmnr_contents 5 where operation = 'DELETE' and seg_name = 'OBJ$' 6 intersect 7 select scn from v$logmnr_contents 8 where operation = 'DELETE' and seg_name = 'TAB$'; After this, I will get the SCN that holds drop table statements. ** Challenge Question, how can I identify DROP VIEW, DROP INDEX, DROP PROCEDURE and alike, from DROP TABLE statements? ** I know this is a question related to oracle internal values so any help would be greatly appreciated. Salu2 Mario Alberto Ramos -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mario Alberto Ramos Arellano INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
killing bkground processes
can anybody tell me how to kill the background processes (SNP) that are currently running/sleep mode. alter system kill session is not working. saying user session id does not exist. srinvas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
divide with decode
hi lists
can anybody help me for the flwng :
i need to do calculation dividing phy reads value/db block gets
i am following the principle
select decode(name,'physical reads',value)/decode(name,'db block
gets',value)
from v$sysstat
where name in ('db block gets','physical reads')
just this query is returning notthing.
i tried with to_number function also, that is not also returning
anything.
is there any trick to solve this.
srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
part of the table export (incremental?)
Hi dba's can anybody tell me how to do export part of the table.. i.e. incremental data. when i exported at 10 am it has 1000 rows ( i did full exp) 100 rows newly added in the 2 hrs when i do exported at 12 am ( incremental) it exporting all the rows(1100) of the table but i need only the rows, that are newly inserted. is there any way to do such export? thnx in adv srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
