Skip to main content.

Job Scheduling < Architecture < Databases

comp.databases.oracle.server Google Group

Oracle database administration/server topics.

comp.databases.oracle.server Google Group

HOT GIRLS TOP AND BOTTOM SEXY MOVIE: HOT GIRLS TOP AND BOTTOM SEXY MOVIE [link] [link]
3 July 2009
Usage of double quotes: Hi All, I have an insert statement that is embedded in a PHP code. It basically inserts a JS string. We have lots of single quotes inside the string which we replace by double single quotes. It works fine, but strangely now, the dev team wants to enclose the whole string in double (...)
3 July 2009
Problem installing Oracle Unbreakable Linux on HP DL160G5: Here's my situation: 1. HP DL160G5 hardware RAID configured (striped). 2. Installing Oracle Unbreakable Linux (recent version). 3. Installation not a problem and system reboots. 4. Get the following messages (approximate): USB 1-1: device not accepting address 2, error -71 ... (...)
2 July 2009
Install of Oracle on 2003 now, can u upgrade to 2008 later.: Wanting to install 10G or 11 onto a windows 2003 server now with a view to upgrading to 2008 server by year end. Will I need to re install oracle if I upgrade the server? Can I get away with an OS upgrade?
2 July 2009
Automatic checkpoint tuning on RAC: I recently talked about the automatic checkpoint tuning with a colleague of mine and we considered setting fast_start_mttr_target to a decent non- zero value like 300 on a RAC database. I am aware of the recommendation not to set it and the argument for that recommendation is the fact (...)
1 July 2009
ASM disk to physical disk mapping: Does anyone know how to map an ASM disk that I can see in OEM to its physical drive? I have a disk that is throwing errors via my hardware diagnostic (but no errors yet in Oracle). I would like to identify it in ASM, remove it and rebalance off of it. I know and can see the exact (...)
1 July 2009
Stale statistics: Hi, We have OLTP system on 10gR2 with RAC (3 nodes) with lot of active tables. Means deletes, inserts and updates. We are only gathering 1% sample statistcs. After bringing the system for couple of hours all the statistics are becoming stale. All our queries use bind varaibles and (...)
1 July 2009
Determing requested parallel slaves: I'm on 10.2.0.2 EE As part of some capacity management work I'm trying to ensure I have enough parallel slaves free at certain times to run my big ETL processes without any downgrades. I determine how much I have been using from ASH - yes I know it's not perfect, but (...)
1 July 2009
oracle application server 10.1.3 redirect problem: Hello! I have redirection like this : Redirect / [link] So every one how enter the page : [link] automaticly will be redirect to [link] but if i add second redirect like : Redirect /test [link] second redirect wont work. I trying to create second redirect, (...)
1 July 2009
Stopping a Query taking more time to execute in runtime in Oracle Forms.: Hi, In the present application one of the oracle form screen is taking long time to execute a query, user wanted an option to stop the query in between and browse the result (whatever has been fetched before stopping the query). We have tried three approach. 1. set max fetch record (...)
30 June 2009
Anyone using nagios?: If so what do you think about it? Are you using it only on linux systems or across multiple unix systems or ... ??? How useable is the alerting and monitoring? How long have you been using it and is it something that your IT operations area is able to work with? Thanks in (...)
30 June 2009
physical standby database on other platfrom??: Hello! I need to know there is any possible way to create standby database on other system platform than production database. example : prodaction is on linux and standby will be on windows Reagrds - MJ
29 June 2009
rman duplicate maxsize archivelog: Hi, I want to duplicate a database using rman with set until time clause. It fails on recovery because there is not enough space to hold all the archivelog needed for the recovery. Is is possible to set a maxsize for archivelog like in the recover command (recover database delelte (...)
29 June 2009
The Special Coupons and Offers This Week: A virtual PBX system with voicemail and Internet Fax. Try it free today. [link] A Special $10 off "moo"pon -- Just for you! [link] Dictate to your Mac [link]
29 June 2009
Luxury Living: Luxury Living celeberties living style you want to know This site contain information about luxury living includs (houses,cars,hotels) video and informative knowledge see it Luxury Hotels * Al Faisaliah Hotel> Saudi Arabia > Riyadh * Germany > Berlin > Hotel Adlon Kempinski * (...)
27 June 2009
initial value on create table/index statement: Is there a way to change the value of "inital" in "create table" or "create index" during imp? Pre-creating table is not an option here. I am taking a export dump with rows=n from production and importing it into dev/QA and since the production tables/indexes have larger values for (...)
27 June 2009
driving_site hint in Materialized View definition: Is there any restrinction on using DRIVING_SITE hint in materialized view definition ? It seems to be ignoring the hint and is transferring the remote EMP table data (which is huge compared to the local DEPT table) to the local server for the join. The hint works perfectly fine if I (...)
27 June 2009
UNDO Issue: Hi, We're receiving this message: . . importing table "DAILY_CONSENSUS_HST" IMP-00058: ORACLE error 30036 encountered ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS_1' The undo tablespace has auto extend turned on and the file system is only 50% (...)
25 June 2009
"How to find a job that makes you over 300K in software development": Attention Developers At last! Here are the (long overdue) tips and tricks you've been waiting for. Check out this new contrarian special report that reveals secrets of industry's highest paid programmers - the secrets you can use to skyrocket your compensation, trade a dull, (...)
25 June 2009
Learn oracle reports 6i in two days: Learn oracle reports 6i in two days.. WWW.ORACLEREPORTS6I.BLOGSPOT.C OM
24 June 2009
Why I cannot do select on other's tables even when I have DBA privileges: I have dba privileges; My database has users user1, user2… When I enter Select * from user1.table1 I get an error table or view does not exit, I am pretty sure table1 is in user1 schema. Is only way to see contents of table1 is to logon as user1, or user1 has to explicitly (...)
24 June 2009
Basic Scripts for Database Administration: Has anyone come across a few scripts that would make Oracle database administration easier? For example, the following command: execSql -d=DB_NAME -f=/ora/sql/chk_tspaces.sql -a=80 -e=on_output - g=DBA The above command would run the sql file (probably using sqlplus) using the (...)
24 June 2009
Strange behaviour of Cramer query: OS: Solaris 5.10 Oracle: 10.2.0.2 Application: Cramer see [link] I was ask to look at a performance issue on a database used for Cramer. A stored procedure is executed which executes a couple of queries and returns some data. Like : PL/SQL procedure successfully (...)
24 June 2009
[Oracle 9i] Is the script is the same as the interactive mode?: Hi I need to create a script exporting the database in exactly the same way as in interactive Exp in interactive mode: $ exp database_user/****** Enter array fetch buffer size: 4096 > 30720 Export file: expdat.dmp > database.dmp (1)E(ntire database), (2)U(sers), or (3)T(ables): (...)
24 June 2009
Oracle reports 6i: Learn Oracle reports in 2 days...I have described fully how to develop the reports..
24 June 2009
Problems loading data into the database using SQL Loader.: Hi all, Database Oracle 9.2.0.8 NLS_LANG=AMERICAN_AMERICA.UTF8 NLS_CHARACTERSET UTF8 NLS_NCHAR_CHARACTERSET AL16UTF16 Server Red Hat Linux 2.6.9-67.ELsmp LANG=en_US.UTF-8 I cannot figure this one out. When I try to populate a table using SQl Loader I am getting corrupt (...)
23 June 2009
satr Kidrobot hoodies ed hardy star red monkey gino green global True: et Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
23 June 2009
Remove dupes with CLOB columns involved: I've created a GLOBAL TEMPORARY TABLE where one of the columns stores the result of concatenating a variable (and unknown) number of VARCHAR2(100) cells. I didn't want to hit the 4,000 character limit when the source table has more than 40 rows so I created such temp column as (...)
23 June 2009
400 No Host matches server name: Su di un Apache/2.0.49 di test (SUSE SLES9) il mod_jk che usavo per collegarmi al JBoss 3.2.3 locale ha improvvisamente smesso di funzionare. Su tutte le applicazioni mi da un errore 400 con messaggio "No Host matches server name ", dove FQDN è il nome del server, ovviamente valido e (...)
22 June 2009
share memory fragmentation: has anyone came accross a share memory fragmentation ? We have this issue sometime with a 300G SGA instance ( non RAC )
22 June 2009
Softwear and Games: This is a site contain very much use full informations and many games for free download and also many other links help you to other free downlod see this Its contain free software and games Business Software * Accounting & Billing Software * Auction Software * Business (...)
22 June 2009
medicine: This site contain usefull informations about medical diseases ,medicine and includs usefull links see it Medical Institutions * Howard Hughes Medical Institute * Johns Hopkins Medical Institutions * PAKISTAN JOURNAL OF MEDICAL SCIENCES For more details (...)
20 June 2009
RAC: typical time to reboot a node and have it rejoin the cluster?: What's a reasonable time for a rebooted RAC node to join a cluster? If you have a RAC, how long does it usually take for you? Is 5 minutes a "reasonable" number? I realize this is a very open ended question with a very broad range of possible answers, I'm just looking to get an (...)
20 June 2009
Atom inside: Intel announces ultramobile processor brand: Intel announced the new brand under which it will market its low-power Silverthorne and Diamondville CPUs. Both will be offered under the Intel Atom brand, with a further "Centrino Atom" title available for manufacturers who meet certain specifications. for more info visit (...)
20 June 2009
Mlatestlaptop.blogspot.com: Hi get information about latest laptop and pc and also free download latest games software and beautifull screen saver and get more fun,,,,,,,,,,,,,GOD bless u
20 June 2009
oracle jobs: oracle jobs [link] oracle jobs [link]
20 June 2009
non Oracle cluster resources: All, a) Can we use CRS( CLuster Ready Services) to manage non Oracle cluster resources? b) we have oracle client installed in a cluster which is currently managed by VCS, can we use CRS to replace VCS?
19 June 2009
Airlines: Site contain very much information about airlines inclouds coutry wise airlines companies informations and video see this for more details [link]
19 June 2009
Re: All SQL QUERYES WITH DEFINATION: kash schreef: Your side is bad, full of errors (both spelling and technical) and adds NO VALUE to this community. You are just fishing for Google Ads Clicks! Shakespeare
19 June 2009
problem with listener: Hi, I was having some problems with DNS and I had to restart listener. And from that time, database (10.2.0.4) can not register to default listener. Listener is running from different oracle_home (11g) on port 1521 and everything looks fine. Local_listener parameter in db is not set. (...)
19 June 2009
The VUE, Downtown Orlando's: Top class living houses and places,cars,hotels for more details [link]
19 June 2009
create table space for media(mp3) files: Hello! I need to know there is any special function when creating new tablespace for table that will be hold mp3 files? Regards -MJ
19 June 2009
Oracle Enterprise Linux installation problem: Hello, I followed instructions in [link]. After clicking on "next" in step 5, I got the following error message: "Could not allocate requested partitions: Partitioning failed: Could not allocate partitions as primary (...)
18 June 2009
Accesses News Group: I just received an email informing me that my internet provider is not going to support newsgroups starting the middle of next month though they said some would be "for a fee". I think these groups can also be accessed from the web but I'm not familiar with the URL. Can anybody (...)
18 June 2009
Issue with Oracle install on Virtual machine: Folks, Need some quick help in resolving the issue with Oracle 10g r2 install on a virtual machine ( vmware). Its goes pretty smooth until we run into Enterprise manager install step. Below is the error message.. SEVERE: Error starting Database Control Refer to the log file at (...)
17 June 2009
So Many Ways of Online Earning: [link] [link] [link] [link] [link] [link]
17 June 2009
Q: Using less space for XE install?: Hello I am installing XE. It says it needs 1.5 gigs of space. I know from running the install some time ago on another computer that almost all that space is actually the data files, not the application itself, and I can't imagine requring even a tenth of that space for my data so I (...)
17 June 2009
Mlatestlaptop.blogspot.com: Hi get information about latest laptop and pc and also free download latest software games and beautifull screen savar ,,,,,, and many more ,,,, get some fun......... God bless u
16 June 2009
oracle 11g web service question: I am looking into migrating to Oracle 11g. I am currently using Oracle 9.2.0.8 and use utl_http to call a Web Service (developed in Microsoft .NET outside of Oracle). I have not developed a Web Service; I simply call this Web Service from a PL/SQL block using utl_http calls. Will my (...)
16 June 2009
Oracle 11g Secure Lob Licensing Question: I read following link: [link] It shows under LOB (large object) support that it is part of Enterprise Edition without any options - Advanced Compresison) but then under SecureFiles it says it needs Advanaced Compresison (...)
16 June 2009
The Newest Special Offers/Discount/Coupons This Week: Save 20% on powerspeaK12 Online Foreign Language Programs for the Summer [link] Luxury Kitchen & Bathroom Fixtures [link]
16 June 2009
Debug ORA-03113 on Oracle XE: I have a web application written in PHP that's failing on one computer (and only that computer): a laptop that runs the Oracle 10g Express Edition. It fails when it executes a specific SELECT query: I get a "ORA-03113 end-of-file on communication channel" error and the connection (...)
16 June 2009
oracle notes: oracle basic information 1 [link] oracle information 2 [link] oracle information 3 [link] orcle information 4 [link]
15 June 2009
same sequence as primary key in more than one table: Hello, For example, I have 'sellers' and 'buyers' both need to authenticate from a database table 'users' with sequence as primary key which is also as primary key in tables 'sellers' and 'buyers' (both have one-to- one relationship with (...)
15 June 2009
Application and Database Connection pooling: Dear All, We have a J2EE app and are considering the connection pooling options from the Oracle 10g R2 and the J2EE app itself. I've come across posts which warn against using this feature on the application side and letting the connection pool to be managed from the Oracle end only (...)
15 June 2009
Re: Fastunload utilit for oracle - Unloading a huge table(partitioned) to a file - concatenating columns: On Sun, 14 Jun 2009 07:26:57 -0700 (PDT), poojam Are you sure you actually did search at all? I Googled and came up with [link] without problem. Please stop dumping your 'very very very urgent' work in a forum of volunteers if you are not prepared to do anything to resolve (...)
15 June 2009
Mix Oracle(OLAP, Data Mining-SVM) and Ruby With ETF Price Data: Hello, I just wrote up some notes about my efforts to use Data Mining-SVM to pick optimal times for an ETF trader to act in the market. [link] The only attributes I fed to SVM were slopes of moving averages of ETF prices. Result: SVM did not find slopes of moving averages of ETF (...)
15 June 2009
Indexes: This is a concept that I'm trying to grasp. It happened to us as we had a corrupted index that was throwing an ORA-600 and the index needed to be rebuilt. The index was tied to a primary key. Rebuilding the index did not help. So, I decided to drop the index and rebuild it. But it (...)
13 June 2009
paypal payment)(www.niketrade08.cn paypal wholesale Prada: (paypal payment)([link] paypal wholesale Prada (paypal payment)([link] paypal wholesale Puma (paypal payment)([link] paypal wholesale Sand (paypal payment)([link] paypal wholesale Shox (paypal payment)([link] paypal wholesale soccer (paypal payment)([link] paypal wholesale (...)
13 June 2009
paypal payment)( www.niketrade08.cn ) cheap ADIDAS jeans wholesale: (paypal payment)( [link] ) cheap EVISU jeans wholesale (paypal payment)( [link] ) cheap ED hardy jeans wholesale (paypal payment)( [link] ) cheap COOGI jeans wholesale (paypal payment)( [link] ) cheap GINO GREEN GLOBAL jeans wholesale (paypal payment)( [link] ) cheap LACOSTE jeans (...)
13 June 2009
about setting connection to local database from EM DBControl configure program through IPC: hi, I'm new in oralce world. I tried to setup Oracle EM DB Control. it seems I had problem to connect to local database by TCP...so I set IPC in my tnsnames.ora, and I could tnsping my service name, and I could sqlplus to connect to my local database by IPC. I hope EM DB control (...)
13 June 2009
Nested Materialized View Refresh: Hi I have the following nested materialized view (MV based on another MV)...... SERVER1 --------------- create table TEST (a number(5) primary key not null, b varchar2(30)) SERVER2 ---------------- create materialized view TEST_MV1 refresh complete on demand with primary key (...)
12 June 2009
I installed Oracle 11g in my home PC. I am trying to open the Oracle SQL developer. It's asking for Java.exe file. (Enter the full pathname for java.exe ) What I need to do? Please advice.: Hi, I am new to Oracle. I installed Oracle 11g in my home PC. I am trying to open the Oracle SQL developer. It's asking for Java.exe file. (Enter the full pathname for java.exe ) What I need to do? Please advice. Thanks, (...)
12 June 2009
Special Characters in Tables and Views: Greetings All, Just wondering about the significance of table names and views with a dollar sign $. Is there a special case in where you would want to build a table with a '$' Sorry if this seems elementary, I tried to find the answer on metalink and online but to no avail. (...)
12 June 2009
Script to run the broken job: Anyone has a readily availiable script to capture the broken job id and run it again. Thanks, Naga
12 June 2009
Table differences: I'm sure there is a way to do this. Have not found it yet. But, I have 2 tables, different structures. Both have a date column. I want to get the rows from table A which do not exist in table B, based on the date: TABLE A: COL1, DATE_COL TABLE B: COL1, COL2, COL3, DATE_COL I (...)
11 June 2009
EM creation hangs on OEL 5.3: Hi, I wonder if anyone can give some pointers as to how to resolve this issue we are experiencing. We are creating databases for various environment on our Oracle Enterprise Linux 5.3. The kernel parameters are set as per Oracle's recommendations: $ cat /etc/sysctl.conf (...)
11 June 2009
Oracle Stat DBA---------------NYC-----------18 Months: Position: Oracle Stat DBA Location: NYC Duration: 18 Months NOTE: CANDIDATES WHO DO NOT MEET ALL MANDATORY REQUIREMENTS WILL NOT BE CONSIDERED FOR FURTHER EVALUATION 1. A minimum of 7 years Oracle Apps 11i (Financials) DBA experience; 2. A minimum 6 years of experience in Oracle (...)
11 June 2009
popular hublot watches,fashion hublot watches http://www.bestcopywatch.com: 2009 Fashion Hublot Watches Collection - Hublot Watch Discount Watches Collection : [link] Hublot Watches Collection : [link] Hublot was born out of a desire to transcend contemporary watch design and produce a unique watch line. Hublot fitted with the first (...)
10 June 2009
Buffer Busy wait event: All, All, We noticed in 20 Mins duration statspack report( Oracle 9.2.0.6) Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 11,147.18 16,392.91 Logical reads: (...)
10 June 2009
Interesting addition in 11G: Once upon a midnight dreary, while I pondered weak and waery, I was browsing the SQL reference, looking for something about the ALTER SYSTEM command when I suddenly looked at the "KILL SESSION" option: [link] Now, everybody knows what alter system kill session does: ALTER SYSTEM KILL (...)
10 June 2009
VCS/VxFS Vs ASM/CRS: Hi All, We ar at Oracle 9.2.0.6 ( 02 Node RAC) VCS,VXFs 4.1 HP Ux 11.23 and aiming Oracle 10.2.0.4 CRS replacing VCS,VxFS Could you please provide the details on CRS. Questions 1. Do we need ASM also as that will be the replacement for VxVM? 2. Licensing cost etc ( extra (...)
10 June 2009
cursor loop and continue statement : unexpected behaviour: Hi all, I might be overlooking something due to deadline stress. But this behaviour amazes me. It looks as if the cursor caches 100 rows and the continue statement flushes the cache and begins with the first record of a new cache fetch. I narrowed it down to the following script: (...)
10 June 2009
Calculating Average Row Length in Oracle 10g: All, We can get this by analyzing the tables in a schema and looking at the column avg_row_len. But, is there a sql so that I can calculate manually. In out environment, we gather statistics once and use them all the time. Thanks, (...)
10 June 2009
Deferred contraints - DDL: Hi, following on from the thread earlier about deferred constraints. We are on 10gR2. I was not aware of the feature and have realised this could be very useful for us for some data-load type activities. As I understand it, in order to be able to alter the sesion and make constrainst (...)
10 June 2009
Initially deferred constraints: Can anyone explain to me when a constraint can be deferred, but not initially deferred? My understanding is that initially deferred does not do its check until the close of a transaction, but I am not sure what NOT initially deferred means. (...)
9 June 2009
ORA-1691, yet a few bytes are written in the LOB of the table: Hi, For a little more than 24 hours we've been having - "ORA-1691: unable to extend lobsegment XX by 64 intablespace - ..." in our alert log file (tablespace autoextend clause has been modified now), but we noticed that in this table the insert statements that took place after (...)
8 June 2009
Embed a string in a string: Hi, I have a stored procedure that builds a query string as it goes through its code. So I pass in a where statement as a long string with a few criteria in it. Then I build some temporary tables and build other parts of the where statement as I go along. At one point I need to build (...)
8 June 2009
Luxuriescars: Do you want to know about luxuries cars? i think it is easy to you people to get information about luxuries cars. for more info visit [link]
8 June 2009
JOB_ID in V$SCHEDULER_RUNNING_JOBS = OBJECT_ID in DBA_OBJECTS: I was just awaken by the system administrator who was, in turn, awaken by a nagios beep about the CPU that was running amok on one of my database servers. The "top" command (platform is 10.2.0.4 on RH EL 4.2/ x86-64) identified the process as J003 and V$SCHEDULER_RUNNING_JOBS gave me (...)
8 June 2009
oracle apex: Hello! I need to create to items "select list" but when i choice filde in first select list item then need to creste select with clause where in second select list item depend from what i take in first select item. So in shortcut - when i chice in 1 select then i will be able do choice (...)
8 June 2009
Question about redo size in dump file and view: Hi Friends, I have a question about redo size generated by insert statement. Here I want to get redo size of insert/update statement, but the size from redo dump is different from view. Below is my test case. 1. create test table create table t4 ( a number) tablespace users; 2. (...)
8 June 2009
cheap new style coogi men t-shirts for 2009.: welcome to visit our website [link] to shop more cheap name brand clothing on-line. We’ll provide the fast shiping for you by express mail. Hope to eastblish a long-term cooperation with you in the near future.
8 June 2009
Anyone know RMAN?: Hi, Hope someone can help us. Been all over and cannot find the answer. We are running 10G R2. We just set up RMAN on a new database. We are already running RMAN on a different database and all is good. After a backup on the new database we get this: "specification does not match (...)
8 June 2009
ENTERTAINMENT LIFE: HELLO, Do u know about the SHILPA SHEETY hot news if u want to watch this so clix this web [link]
6 June 2009
Rumour is 11.2 out or at least announced on Sept 1 2009: You saw it first on cdos ... Wonder if 11.1.0.8 patchset also comes out then?
5 June 2009
Version blues: Oracle and HP have recently performed some benchmark testing of blade server RAC, in combination with Exadata storage servers. The combination, of course, topped the chart, as can be seen here: [link] The funy thing here is that the database used was Oracle RDBMS 11g RELEASE (...)
5 June 2009
Apologies to Oracle Corp.: It seems that I owe an apology to the Oracle Corp., their ODBC driver works fine: [mgogala@centos trace]$ /usr/local/bin/isql -v OracleODBC-11g scott/tiger +----------------------------- ----------+ +----------------------------- ----------+ SQL> select * from emp; (...)
5 June 2009
How to set module name in oci: hi all, My oracle version is 9i. there is not OCI_ATTR_MODULE in oci.h. how to set module name? thanks.
5 June 2009
Solaris x86 & Oracle: I am following Oracle patches for Solaris x86. Oracle 10g is being barely touched while patches for Oracle 11g (32 bit version) are starting to show up regularly. There is 11.1.0.7 for Solaris x86, there is even CPU APR '09 for it. Now, the question: given the low quality of Linux (...)
5 June 2009
pl/sql conditional cursor?: hi, Oracle 10g. In a procedure I have some code like declare cursor c1 is select x,y from tab1,tab2 where and and ; begin for r1 in c1 loop end loop; end; Now I want to turn condition 3 on/off depending on one of the procedure's parameters - without having (...)
5 June 2009
ORA-01090: shutdown in progress - connection is not permitted: Hi After command shutdown immediate in sqlplus on database Oracle9i I look error message: SQL> ORA-24324: service handle not initialized ORA-24323: value not allowed ORA-01090: shutdown in progress - connection is not permitted SQL> Disconnected But in Enterprise Manager database (...)
5 June 2009
manual dbms_mv.refresh taking longer than scheduled: All, Our manual refresh taking much longer than scheduled refresh through dba_jobs. Why is this behaviour? We are using 10gR2 with RAC with three nodes. We cannot use fast refresh because, our DBA don't want to turn on the logs and we have the following in our queries: - start (...)
5 June 2009
Oracle configuration related weird behaviour?: I want to replicate some schemas from a Oracle 9.2.0.8 to a 9.2.0.1. The export/import process was OK and now I've objects replicated and data loaded. A function is not working properly, and an example of what's the problem can be reproduced with this example: declare cursor (...)
5 June 2009
How to select a random row from each sub table after "group by"?: After "group by", the big table is grouped into many sub tables. I want to select a random row from each sub table. That's what I want. How can I realize/implement it?
4 June 2009
FreeTDS & Oracle11g: I have properly configured UnixODBC which used to work with Oracle10.2.0.4 and hsodbc: mgogala@centos ~]$ isql -v mstest ccmview ccmview +----------------------------- ----------+ +----------------------------- ----------+ SQL> select table_name from information_schema.tables; (...)
4 June 2009
Refresh Materialized view manually: Hi, We have a materialized view which was scheduled through dbms_jobs. At the same time, we want to have capability to refresh manually when some event happens. Is is it possible to do this? Do we have any issues with this? We are on 10gR2 RAC with three nodes. Your input will be (...)
3 June 2009
How to remove out-of-the-box policy violation from Database Control: Hi, I just installed a new Oracle 11g box with a new database created using DBCA with all the out-of-box settings. Using database control, I can see a lot of "policy violation" warning etcs. For example, one warning is "Control File Permission (Windows)". Apparently, it is complaining (...)
2 June 2009
oracle database 10g and odbc to mssql 2005: Hello! Any idea??? Free ODBC driver for linux ?? Need create database link to mssql 2005. Regards -MJ
2 June 2009
Marinzo online community: Dear all, Now you can join Marinzo.com, it’s a new online community where you can find new friends, dating, lovers, and partners. Join marinzo.com to be one of its pioneers, it is new and can be customized due to your preferences, join now and feel free to give your feedback in (...)
1 June 2009
starting up a rac node via sqlplus?: oops, accidentally posted this to .misc... In sqlplus you can shutdown a node in a rac cluster via connect sys@node3 shutdown immediate Is there a way to start up a node as well? I am scripting some regression tests related to node failover and it would be great if I did not have to (...)
31 May 2009
and i thought we had some disfunctional postings on this newsgroup?: Take a brief look at this one ... [link] Those dang lispers can sure express themselves rationally eh? Maybe we should start up the old varchar versus varchar2 thing and get a grudge match going ...
31 May 2009
Using Joins: All, I have tables a and b as follows, SQL> select * from a 2 / X Y ---------- ------------------------------ 1 A1 2 A2 3 A3 4 A4 A99 SQL> select * from b; X Y ---------- ------------------------------ 3 B3 4 B4 5 (...)
31 May 2009
PGA_AGGREGATE_TARGET sizing of work areas and HJ cost: Hi, I'm doing some investigations because of query plan changing in the same session (from NL Index RS to HJ FTS), and got question about Hash_Join_Area_Size when work_area_policy=auto. Is that possible that the same session can have different HJAS for same query ? When auto (...)
30 May 2009
Work at Home - Make $ 50 Per Hour , 100% Guaranteed: Work at Home - Make $ 50 Per Hour , 100% Guaranteed for more details please logon http//:[link]
30 May 2009
A Question: Dear All: I have a question on Oracle. Basically I have a file with each row is an ID to a row in the database. I need to retrieve all the rows with the ID in that file. What will be the best way to do that? I'm wondering if Oracle have a tool that could possibly help the process (...)
30 May 2009
never ending chain: Hi, I've got simple scheduler chain with 4 steps: start step_1, after some time start step_2 when step_1 and step2 are 'succeeded' then start step_3 when step_3 'succeeded' then start step_4 when all steps are 'completed' then END. Yesterday step_3 has (...)
30 May 2009
Clustering OAS servers: I know very little about Oracle Application Server 10g. Our App Server expert just quit unexpectedly. We have a very basic OAS application, nothing fancy. Senior management asked about the complexity of clustering the OAS server with another identical server that we just acquired by (...)
29 May 2009
Installing and Uninstalling Oracle 11g: Hi, I installed a standalone Oracle 11g on Solaris 10, sparc. How do I, completely uninstall it. My aim is to install clusterware, and I am running out of disk space, so, how do I install clusteware, do I first uninstall the Oracle 11g installation, and then start a fresh installation (...)
29 May 2009
10g Grid Control - migrate data: Hi, Current:Grid Control 10.2.0.4 Proposed: HA Grid Control 10.2.0.5 on new servers (using Load Balancer) We have historical data in our current grid db repository. Anyone know how to migrate the data from a 10.2.0.4 grid db repository to 10.2.0.5 grid db repository? I searched (...)
29 May 2009
New Disk Setup: I've got to shift our OLTP production database onto a new server which has 8 disks. The layout I've got at the moment is the following. Please feel free to flame me if you like but I was wondering if I'm being overly cautious with mirroring and should use striping/ (...)
29 May 2009
10g NF just @ 8000*/-: Dear All Greetings from SQLSTAR!!!!! We are happy to Announce that SQLSTAR in now authorised by Oracle to conduct 10g New Features just @ Rs:8000/- *
28 May 2009
Time zones calculation - browser apps: Hi, this question pertains to 10.2.0.1 + Say we have a database which runs on a server which is ALWAYS set to GMT. We have users of a web application in two timezones - say today this is GMT+1 and GMT+2. In the winter, these will be GMT and GMT+1. The application is browser based (...)
28 May 2009
Table Function error: wrong number or types of arguments: Hi All, I am developing an application in Oracle 10.2.0.3.0. This is my first attempt at using Table functions. The code below is giving me the error Errors for FUNCTION TABLEFUNCTION: LINE/COL ERROR -------- ------------------------------ ------------------------------ ----- (...)
27 May 2009
Help: Oracle does not take @ sign in password: All, I have an issue and i hope somebody here will be able to help me. We have a password manage system which will push all the password into oracle database by using the command alter user test1 identified by "xx@xx" And most user can connect by doing $ sqlplus test1@testdb (...)
27 May 2009
Implementing Table Functions Without Declaring Types at Schema Level: Hi All, All of the examples for table functions I have come across use an object type declared at schema level. Is it possible to use table functions within a package using types declared in pl/sql only. My attempts have drawn blanks, possibly due to misunderstanding/misuse of (...)
27 May 2009
export error: hi , iam getting the following error while importing the dump in 10204. illegal lob length marker 65279 bytesread = 00000000000 TABLE = CHK_RSLT IMP-00098: INTERNAL ERROR: impgst2 IMP-00008: unrecognized statement in the export file: ÿþÿþÿ Regards, Mohammed (...)
26 May 2009
Intel Ships 1.66GHz Atom N280 Processor: ntel may be placing its quad-core Itanium server chip back in the oven, but it's having no issues whatsoever shipping the latest iteration of its white-hot Atom CPU for more info visit [link]
26 May 2009
get free visitor to web only free: harry up get free visitor for our site its for you more visit [link]
26 May 2009
Marterialised View Problem: Hi All, We are developing an application in Oracle 10.2.0.3.0. For the sake of performance we are using a materialized view which contains denormalised data for Items. There is a Comment table to keep a history of all comments for Items. I have been asked to add the comments for each (...)
26 May 2009
orana.info is junk: I used to use orana.info blog aggregator to remain of top ever increasing number of interesting blogs. I first noticed that it skipped the recent interesting notes by Jonathan, like "Hints on Hints" or "One SQL". Also Tanel's note about free DBA_HIST AWR views in 11g wasn't (...)
25 May 2009
Oracle 11g ans Active directory: Hi ! I'm trying to install oraclle 11 server on a windows 2003 r2 member of domain. I have difficulties to integrate in oracle in the domain and i notice that some groups build by oracle installation are on the server and not on the DC. So i ask me if the oracle server should (...)
24 May 2009
Memorial Day Specials, 2 Days Only: Sunday - Monday (5/24-5/25).: [link] COMPUTING & HOME OFFICE Sunday – Monday Only: Select Monitors 23" and Up On Sale. Valid 5/24-5/25 Sunday – Monday Only: $50 Off D-Link Xtreme N Wireless–N Gigabit Gaming Router with 4–Port Switch. Valid 5/24-5/25 Sunday – Monday Only: Free (...)
24 May 2009
Corruption in update statement with dml error logging 10gR2/Solaris: update a_table set xyz = ( SELECT distinct FROM ... ) log errors into err_xyz reject limit unlimited ; There are rows where it can possibly select upwards of 1000 rows and distinct will return about 5 different rows. When I update only a set of rows, I see that nothing gets updated to (...)
24 May 2009
Oracle 11 in Active DIrectory: Hi ! I try again to install oracle 11g in my active directory domain, i finally arrive to create the oracle context with netca, but inscriptions dont have the oracle icons just th simple directory icons. In active directory users and computers mmc i don't have the options "test" and (...)
24 May 2009
Removing a diskgroup from a corrupt ASM database: I had a disk failure so that the databases (ASM and actual database) cannot see the disks. Therefore the diskgroup DATA is unmounted and cannot be remounted. I'm ready to start over from scratch, I dropped the non-ASM database, but still have an ASM database that knows about an (...)
23 May 2009
More than one listener process: I'm running Oracle 10.2.0.3.0 Enterprise Server on RHEL 4. I notice after a couple days a second listener process gets created. Client can't connect when this happens and I need to stop and restart the listener then only 1 listener process is running. Does anyone know why this (...)
23 May 2009
Errors on Duplicate for stanby: Hi All, I'm having some trouble to duplicate a database (standby) to other node. I understood by this error messages that the archivelogs being asked were not backup by rman on the primary node, so I'm doing this and sending to stanby node. They were already in the stanby (...)
23 May 2009
Black & Decker JS700K 5.5 Amp Top Handle Jigsaw: Price:$121.65 Image: [link] Best deal: [link] I've not use extensivly yet, but it seems to be a very good product. All in all this a very good saw. The orbital cutting action with the variable speed is a big improvement over my old straight cutting jig saw. I got this tool about six (...)
22 May 2009
18ga. Finish Nail 1" Long 2500/ Box (593-FN16100) Category: Pneumatic Nailer Parts: Price:$12.50 Image: [link] Best deal: [link] Porter Cable FN16100 1" 16-Gauge Finish Nails 2500 per Box SIMILAR PRODUCTS: Porter Cable FN16150 1-1/2" 16-Gauge Finish Nails 2500 per Box:[link]
22 May 2009
Bostitch CPACK1850BN 2-Inch Brad Nailer and Compressor Combo Kit: Price:$259.99 Image: [link] Best deal: [link] Combination Bostitch Compressor & 2" Brad Nailer Kit, Kit Includes: 2HP Peak, 6 Gallon Oil-Free Compressor, Bostitch SB-1850BN 2" Brad Nailer Kit, 40' Hose With Fittings, 1000 18 Gauge 2" Brads, Tool Lubricant & Tool Carry (...)
22 May 2009
Calculated Industries 4060 Construction Master Pro: Price:$79.15 Image: [link] Best deal: [link] I am blown away by this device. I first tried the free download from the Calculated Industries web site. ... It is a full blown version, without any restrictions, but stops working after 30 days. After about day 5 I knew I had to have it. By (...)
22 May 2009
Leatherman Expanse e55Bx Combo Straight/Serrated Blade Knife: Price:$77.00 Image: [link] Best deal: [link] Lightweight yet sturdy enough for demanding jobs, the Leatherman 8614240 e55Bx Combo Straight/Serrated Blade Knife is a versatile tool that's easy to store in your pocket, pack, or toolbox. A slim, folding knife with a reinforced handle and (...)
22 May 2009
Klein Tools Nut Driver 632 - Cushn-Grip - Drive-A-Matic - Adj. 1/4in.-7/16in. Hex: Price:$35.20 Image: [link] Best deal: [link] If you imagine carrying a light tool bag because this is a multi-diameter tool, think twice. This tool is not for very tight nuts (it cannot hold them if the nuts are very tight), in general is way better than your own fingers but again, if the (...)
22 May 2009
Stanley 60-060 Standard Fluted Screwdriver Set, 6-Piece: Price:$7.36 Image: [link] Best deal: [link] Not the top of the line but for the price an exceleent value to have around the house for the odd job.. Nothing spectacular. The grips are plastic, but they're wide enough to keep your hand from cramping. The holder isn't so great, (...)
22 May 2009
DeLonghi D650UX Cool Touch Deluxe Deep Fryer: List Price:$59.99 Image: [link] Best price found: [link] I bought this fryer because my sister-in-law had one and she was raving about it. I bought it and it took too long to fry couple of drumsticks and too much oil was needed. I am a little (...)
22 May 2009
Invicta Men's Slim Collection Square Brown Leather Watch #5132: Price:$245.00 Image: [link] Best deal: [link] Thin is in with this stainless steel men's watch from Invicta's Slim Collection, which is a great choice for everyday casual wear. But with its amazingly svelte 5.5mm (0.22 inches) profile, it can also be perfectly tucked under the (...)
21 May 2009
Setting up OS authentication: Hi, I'm trying to setup Oracle 10g to use OS authentication but are getting the following errors. SQL*Loader-951: Error calling once/load initialization ORA-00604: error occurred at recursive SQL level 1 ORA-01738: missing IN keyword Oracle IDs are working fine it's just (...)
21 May 2009
Fossil Watch - White Dial: Price:$85.00 Image: [link] Best deal: [link] White dial with silver indexes Shiny silver case and bracelet Three hand movement 10 ATM Case size: 44mm 11 year limited warranty SIMILAR PRODUCTS: Street Fighter IV:[link]
21 May 2009
Seiko Women's Diamond Gold-Tone Watch #SXDA44: Price:$395.00 Image: [link] Best deal: [link] I got this watch as a christmas gift for my mom. She loved it. It is casual or dressy watch. Nice quality, pretty watch. I agree with the other poster - don't but this watch for the miniscule diamonds on it. They are diamond dust at best (...)
21 May 2009
Tissot T-Race Moto GP Mens Watch T027.417.17.201.02: Price:$625.00 Image: [link] Best deal: [link] It a very sport and elegant watchTissot hs really good quality you will not be disapointedPerfect delivery Lo compré para un amigo, al verlo decidí comprar uno para mi.creo que lo unico negativo que veo es el tipo de banda que utiliza (que (...)
21 May 2009
Dads & Grads Superstore: National Lampoon's Animal House (Double Secret Probation Edition) (Widescreen) (1978) FREE BUDGET SHIPPING SAVE 29% [link] Revenge of the Nerds (Special Edition) (1984) SAVE 25% [link]
21 May 2009
Oracle 10g RAC - Cannot set IS_RECOVERY_DEST_FILE to YES: Hello, Problem: I cannot set IS_RECOVERY_DEST_FILE to YES for log files of an Oracle 10g 2 node RAC. Description: I am setting a Flash Recovery Area (FRA) to be used for RMAN backup. I have database set to ArchiveLog and set flashback on database. Don't know how to change (...)
21 May 2009
oracle service restart: I installed Oracle 10G enterprise edition but when I tried : [link] for first time I got the database login. But when for second time when I tried : [link] I did not get the database login. In windows I restart the oracle services but what should I do about (...)
21 May 2009
New dirty tricks in Red Hat 5.x: 1) CFS and ionice Kernels newer then 2.6.13 come with the "CFS" (Completely Fair Scheduler) I/O scheduler which can assign I/O priorities to processes. ionice -c 1 -n 0 -p `pgrep -f lgwr` will assign the highest real-time priority to the oracle log writer. If two or more processes have (...)
20 May 2009
Big icons in OAS 10g: Hello. Now I can see icons in execution-time, in a Forms application with OAS 10g rel. 2; but I have realized that these icons are... too big. I mean: in developing-time, that icons are seen correctly. But, when executing at OAS, they are about 2x the original size, so I can only see (...)
20 May 2009
WWW.IOFFERKICKS.COM sell:nike jordan shoes$32,ed hardy /polo /lacoste tshirt$13,jean$30,handbag$35,nike shox$34,air max$32.lv.gucc.coach..free shipping: Get Nike Shoes at Super Cheap Prices Discount Nike air jordans (WWW.IOFFERKICKS.COM) Discount Nike Air Max 90 Sneakers (WWW.IOFFERKICKS.COM) Discount Nike Air Max 91 Supplier (WWW.IOFFERKICKS.COM) Discount Nike Air Max 95 Shoes Supplier (WWW.IOFFERKICKS.COM) Discount Nike Air Max 97 (...)
20 May 2009
RMAN DUPLICATE failed at recovery time.: Hello, I am trying to duplicate a 10gR2 Oracle database into a new host using different directory structure for datafiles and log files. The duplicated database is also 10gR2. Both Hosts use RHEL4 OS. I had successfully duplicated the target database in the past and therefore I assume (...)
20 May 2009
Using RMAN on two node Solaris x86 with Oracle RAC 10g Enterprise Edition Release 10.2.0.3.0: Hello, Maybe you can help me (new on RMAN backup) in doing this. I have configured a single Oracle 10g database to have backup with RMAN with following steps: 1. $ mkdir $ORACLE_BASE/rman_scripts 2. $ mkdir $ORACLE_BASE/logs 3. $ mkdir $ORACLE_BASE/tracking 4. $ mkdir (...)
20 May 2009
how can i eliminate burleson's stuff from google search results?: All, posts from dba-oracle.com tend to rank relatively high in google search. is there some setting I can use to eliminate those from the result set? thanks!
20 May 2009
How to Install ASM on a Linux single HDD PC?: Hi all Is there any tutorials about install Oracle 10g ASM on a Redhat Linux PC with only one harddisk. I want the details with installation commands. Thank you. Jia Lu
19 May 2009
Lens For Canon Slr Camera: Canon Digital Rebel XSi 12.2 MP Digital SLR Camera with EF-S 18-55mm f/3.5-5.6 IS Lens (Black) Price:$749.99 Image: [link] Best deal: [link] Canon EF-S 55-250mm f/4.0-5.6 IS Telephoto Zoom Lens for Canon Digital SLR Cameras
18 May 2009
Archive logs removal question: This should be fairly common question I hope. I like to know if it is safe to remove these old archive log files. Oracle is 9i RAC (2 nodes dr_1,dr_2). It seems to tell me oldest log is 1086. So I can remove anything up to and including "....1086.arc" ? It also has 2 directory (...)
18 May 2009
DBMS_STATS gives wrong stats for some columns/indexes: Hi all, I noticed that DBMS_STATS gives wrong statistics for some columns/ indexes - it looks like they forgot the multiplier to compensate for sample size. Example: a table has approx 3.8 million rows. This is what I get for a certain column: 5% sample size - 80,000 distinct values (...)
18 May 2009
27 Inch Lcd Hdtv: Philips 19PFL3403D/27 19-Inch LCD HDTV Price:$399.99 Image: [link] Best deal: [link] Philips 42PFL7403D/27 42-Inch 1080p 120Hz LCD HDTV Price:$1,299.99 Image: [link] Best deal: [link]
18 May 2009
Canon Pixma Mp630: Canon MP620 Wireless All-in-One Photo Printer, 2921B002 Price:$189.00 Image: [link] Best deal: [link]
17 May 2009
Asus Eee 2g: HQRP AC Power Supply for ASUS Eee PC 700 / 701 ; Asus AD59930 Replacement plus HQRP Mousepad Price:$19.91 Image: [link] Best deal: [link] HQRP Charger / Power Cord for ASUS Eee PC 700 / 701 ; Asus AD59930 Replacement plus HQRP (...)
17 May 2009
ILM: Hi, I have some questions about oracle's ILM: 1. Can the storage tiers be spread over different database servers or is it always in the same database and I have to scale my hardware power with oracle cluster? 2. The offline tier - how is this managed in concerns of export/delete (...)
16 May 2009
nike clothing,nike shoes,online store,http://www.maidi2008.net air Jordan Shoes,Nike Air Jordans, Air Force Ones,Retro Air Jordan, Bape Hoodies,Bape shoes-Tencent Traveler|Jordan Shoes,Nike Air Jordans, Air Force Ones,Retro Air Jordan, Bape Hood: nike clothing,nike shoes,online store,[link] air Jordan Shoes,Nike Air Jordans, Air Force Ones,Retro Air Jordan, Bape Hoodies,Bape shoes-Tencent Traveler|Jordan Shoes,Nike Air Jordans, Air Force Ones,Retro Air Jordan, Bape Hoodies,Bape shoes-Tencent Traveler|Jordan Shoes,Nike Air (...)
16 May 2009
SVR4 Error: 28: No space left on device: /u01 got 100% full, I think from user tablespaces in autoextend and stuffs got built in default user tablespace in /u01. The immediate problem is I as oracle admin can't even login to sqlplus to clean up. This I got from sqlplus '/ as sysdba': ERROR: ORA-09817: Write to (...)
15 May 2009
dbms_shared_pool.keep: Today, I noticed a performance problem on one of my databases. Statspack was showing quite a few of library cache waits. Most of the waiting sessions were trying to execute the same procedure and the problem was alleviated to significant degree by pinning the the package that contains (...)
15 May 2009
ODBC from Windows to Oracle 7 on UNIX: Hi, I am very new with Oracle. This company has Oracle 7 on UNIX and I want to establish ODBC from Windows. The vendor who set up this system made themselves pretty clear that they don't want to help us set up ODBC. So, I need your help. One scenario I found was installing (...)
15 May 2009
Oracle Stats: Hi, We're basically running some Oracle utility: awrrpt. It gives us the largest report we've even seen. At any rate, most of the stats are basically hard to understand. Is there someplace that explains what all these items are? We do not understand all these stats and if a (...)
15 May 2009
How can we query Oracle OLAP cube from .NET?: Hi, Is there a library or provider for querying an OLAP cube from a .NET application? Does it support MDX? Thanks, Yash
15 May 2009
sql developer not showing table names: Hi All, I have created a new user and granted it resource and connect privileges. I have created a few tables this new user's schema but I am not able to see those in SQL Developer. However when I issue - "select * from tab", I am able to see the table list. Do I need any other (...)
15 May 2009
Partitioning Question: Oracle 10.2.0.3 We have a number a tables partitioned by year. Each ends up with: PARTITION_2009 VALUES LESS THAN (TO_DATE('01-JAN-2010','DD-MON -YYYY') ) PARTITION_2010 VALUES LESS THAN (MAXVALUE) I'm not too familiar with modifying partitions and after doing some (...)
15 May 2009
Solaris strip LD_LIBRARY_PATH when su - oracle: Hi All, In my rc script, I have su - oracle to run /var/opt/oracle/product/10.2.0 /db_1/bin/lsnrctl However, it fails with the following: ld.so.1: /var/opt/oracle/product/10.2.0 /db_1/bin/lsnrctl: fatal: libclntsh.so.10.1: open failed: No such file or directory The cause is that the (...)
15 May 2009
bollywood hot actress: hi see this hot actress here [link]
15 May 2009
now get detail about latest computer: now watch get about latest computer laptop free more visit [link]
14 May 2009
WWW.iofferkicks.net cheaper g-satr kidrobot hoodies ed hardy star red monkey gino green global true religion ed-hardy kidrobot jeans hoodies china supplier wholesaler exporters,manufacture: Get Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
13 May 2009
just a question (virtual machines): My workplace is seriously considering going to virtual machines for most of the servers, including database servers. We are a windows shop and have several VMware servers running test env's now. I am not in favour of running production db's on vm's, but I don't have the (...)
13 May 2009
Latest Computer free At Your home: Latest Computer free at your home Totaly Free Just Click Once On PC-in-A-Keyboard Top 10 Laptops Green Desktop PC Laptop Computer Suppliers Hotel Reviews and Deals Top 10 Laptops Laptop Computer Suppliers Green Desktop PC Agfa and Scitex equipment PC-in-A-Keyboard Just (...)
13 May 2009
10g Database not starting after applying patch: Hello, I initially installed 10.2.0.1.0 version of the database and then applied the 10.2.0.3.0 patch successfully. Now i cannot get the database started. I get this error: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach) (...)
13 May 2009
earn money with your computer: read about computer how to earn money on internet plz visit [link]
13 May 2009
How To Choose A Web Hosting Service: How To Choose A Web Hosting Service [link] How To Find Cheap Web Hosting [link] Dedicated Server: Managed Or Unmanaged? [link]
13 May 2009
oracle: oracle information 10 [link] oracle information 11 [link] oracle information 12 [link] orcle information 13 [link]
13 May 2009
Regarding Database Design: Hi Faculties, Please accept my apologies if this query is out of context of the discussions in this forum. I've with me a proposed database design which is not normalized fully. There are some other tables that we plan to denormalize. The targeted database platform is Oracle (...)
13 May 2009
remote access: Oracle 11g installed on Vista. Standard port 1521. Can connect locally using sqlplus but not remotely. Is there a security setting that needs to be changed within EM to allow this in the same way that Express Edition has one? Searched settings and docs but no (...)
13 May 2009
Restoring to a different database name: In my development environment, I have two machines, each of which has a database called "C1" (that's the value we use for the SID and all those other things that identify the DB). I need to replicate one of these databases that's on the first machine onto the second machine, (...)
13 May 2009
Strange memory error during import ...: I am on Oracle 10.2.0.3 on HP UNXI 11. When doing import after all tables have been imported, I get following emmory errors. I have seen it in 2 different database instances. No clue, why this error Occurs. sh: 3127 Memory fault sh: 3300 Memory fault sh: 3441 Memory fault sh: (...)
13 May 2009
Latest computers,laptops and softwares: Get more information related about computers,laptops and softwares so plz visit on ([link])
13 May 2009
Complex Query: I am trying to make a query with virtual tables to apply 2 different sets of criteria and get 2 columns from 1 table. It almost works. But if you look at the query, the issue is that the column ORDER_DATE appears in both virtual tables, so I get an error. But it is the ORDER_DATE which (...)
13 May 2009
gc buffer busy from the same instance??: Hi All, 10.2.0.4 EE on SLES 10 We have seen fairly significant waits recently on this during a large load recently. We know which query is causing it and are submitting a fix, but my question is the following: When I select from gv$session, I see session x on instance 2 waiting on (...)
13 May 2009
Latest Computers,laptops and softwares: more information related about computers,laptops,softwares and anti security visit ([link]
13 May 2009
Wholesale, Prada, DG, Fendi, Burberry, Louis Vuitton Sunglasses, Handbags: Prada Wholesale Sunglasses | DG Wholesale Sunglasses | Fendi Wholesale Sunglasses | Burberry Wholesale Sunglasses | Chanel Wholesale Sunglasses | Louis Vuitton Wholesale Sunglasses | Dior Wholesale Sunglasses | Gucci Wholesale Sunglasses | Armani Wholesale Sunglasses | Versace (...)
8 May 2009
Computer,Software and Laptops: Get more information related about computers,laptops and software visit ([link])
8 May 2009
computers,laptops and softwares: u can get easily lot of information related about computers,laptops and softwares so visit plz ([link])
7 May 2009
Problems starting new TNS Listener: Hi folks, I've a strange problem occurring on Windows after the DBUA. I've an automated application (written with c#) which, among other things, silently launches the Oracle DBUA tool (for upgrading an Oracle XE to an Oracle SE), and then create a new listener for the newly (...)
7 May 2009
RMAN: Delete obsolete backups but not obsolete archivelogs: Hi all, I want to delete only obsolete backups and not archivelogs due to the fact that we have a 2 stage backup process, first to disk, then to tape and I have 2 archive log locations, 1 on SAN and another on local disk, so I wouldn't want to put all my eggs in one basket and keep (...)
6 May 2009
sqlldr ignores skip: Hi all, I'm invoking sqlldr from commandline: sqlldr userid=user/password@//localho st/XE control=file.ini SKIP=7 log=logfile.log Sqlldr always ignores the option and skips only one line. I've tried to set the option in the controlfile with OPTION (SKIP=7) but that is (...)
6 May 2009
How freshly installed Oracle database sounds like: Hello. Here is converted with SoX freshly created Oracle database 11g to mp3. It is probably could be noise art... [link] [link] [link] [link] ORACLE.SYM file from win32, containing all ORACLE.EXE symbols and its
6 May 2009
lookup up srv dns record in a stored procedure?: Oracle 10.2.0.4 Standard Edition I'm using the DBMS_LDAP package to do lookups against Windows Active Directory. We have multiple sites so for performance reasons I'd like to bind to the local servers, which are defined in an SRV record in DNS at: _ldap._tcp.mysite._sites.ourdo (...)
6 May 2009
Help understanding an oracle text search term: I have a varchar2 column (col2) and I've created an CTXSYS.CONTEXT index for it (using the empty stoplist). I'm running a query that has ... AND CONTAINS(col2, 'G"%') > 0 This results in an error "DRG-51030: wildcard query expansion resulted in too many terms" But if (...)
5 May 2009
RAC: why odd number of voting disks?: As per Oracle codumentation: The Oracle Clusterware enables multiple voting disks but you must have an odd number of voting disks, such as three, five, and so on. Why odd number? Thanks for any answers/pointers.
4 May 2009
Shadow Process on Dedicated Server: Hi Gurus, I have a simple question: If I have a dedicated server config on 10g & already established a session to db through a terminal (of course, I'm running something on this session), would a server spawn another shadow process if I open another session on the same machine? (...)
4 May 2009
wholesale gucci prada sneakers cheap nike max nike shox sheos,discount nike jordan 1-24 series niek zoom kobe,nike james sneakers: wholesale nike air jordan sneakers,cheap nike air jordan fusion air force one sneakers,discount buy nike max shoes,sell nike retro jordan shoes,nbacitysports Co.,Ltd(www 2009-sneakers com) cheap shipping nike dunk sneakers,china supply nike top air force one womas boot, buy aaa quality (...)
3 May 2009
discount nike air force one sneakers discount nike air jordan sneakers discount nike max series shoes: nbacitysports Co.,Ltd(www 2009-sneakers com) wholesale nike air jordan sneakers,cheap nike air jordan fusion air force one sneakers,discount buy nike max shoes,sell nike retro jordan shoes,cheap shipping nike dunk sneakers,china supply nike top air force one womas boot, buy aaa quality (...)
3 May 2009
wholesale nike jordan sneakers wholesale nike dunk shoes wholesale nike air jordan force 13 sneakers: nbacitysports Co.,Ltd(www 2009-sneakers com) wholesale nike air jordan sneakers,cheap nike air jordan fusion air force one sneakers,discount buy nike max shoes,sell nike retro jordan shoes,cheap shipping nike dunk sneakers,china supply nike top air force one womas boot, buy aaa quality (...)
3 May 2009
Flahsback archivinging questions: I am using Oracle 11.1.0.6 on Windows XP. Flahsback archive I have created a flashback archive with retention time of 1 month. Table t is in this fb archive. 1. Now if I change retention time of the fb archive to 1 day, will it apply to already inserted data, or it applies only to new (...)
3 May 2009
Oracle 11g db control always has problems: I am using oracle 11.1.0.6 on Office XP Service Pack 2 When I created a database instance using dbca, I could access db control using https://... Link. But now when I rebooted my PC, I cannot access db control any more (page cannt be displayed). In the past, I had to drop db control (...)
2 May 2009
Frits Hoogland: This annoys me to no end! Frits Hoogland wrote and article about the utility "sosreport" which is incidentally named "sysreport" -bash-3.00$ rpm -qf /usr/sbin/sysreport sysreport-1.3.15-6 -bash-3.00$ I tried writing him a comment on his weblog but, for some reason, my comments are (...)
2 May 2009
When is a stored procedure needed?: Is it suggestible to write a stored procedure for registering or sign- in?
2 May 2009
How to find partioning_type – range or interval?: I have a table which is interval partitioned. It has several range partitions and several interval partitions. Is there any way to find which partitions are range and which are interval. I looked in user_part_tables, it does not give me all partitions of the table. User_tab_partitions (...)
2 May 2009
looping cursor on a query hangs.: Is it reasonable for Oracle to hang on a query like this? Basically, it's a cursor on a query which splits csv entries, and using the splitted up values to insert into another table. Does it hang because my table is too large? what is a better way that I can accomplish what I'm (...)
1 May 2009
Re: Update with wait for lock: The facilities Oracle provides do not match directly against other vendors implementations of locking. You can cover your update by using pessimistic locking ( get the locks up front ) by doing the SELECT FOR UPDATE WAIT X prior to your UPDATE. Tom Kyte has a good book "Expert Oracle (...)
1 May 2009
webmail user mailbox schema design?: Hi Folks, Does anyone have any insight into what user mailbox stores look like for yahoo, gmail, hotmail, etc? I am curious if they have, e.g. a mailbox table for each user that contains all their email or whether they have a single large table with email for all users or whether they (...)
1 May 2009
sqlplus v. OCI v. OCCI connect: this command connects to oracle: $ sqlplus smiller/mill99@oradev A OTL based program which uses smiller/mill99@oradev as a connection string connects to Oracle. A working OCI program here which was gutted to use user=smiller, password=mill99, db=oradev connects to Oracle. But an (...)
1 May 2009
Log files tuning: Hi All, By using Oracle Enterprise Manager I can tune my database..I have been using it on Windows, however not yet on Unix, I am looking for some advise....do you think recommendable installing EM on Unix or WISE product, I was hearing about it, but honestly I don't know how much (...)
30 April 2009
Get The World's Strongest Cars & Bikes In Cheapest Price: Get The World's Strongest Cars & Bikes In Cheapest Price ''Used Motorcycles in Dubai'' ''Export used cars from USA '' ''Crystal Motorcycle Helmet'' ''Fantastic Touch-Up Paint '' ''Body & Exterior (...)
30 April 2009
Get Latest Mobile In Cheapest Rs.. With 50% discount: Get Latest Mobile In Cheapest Rs.. With 50% discount Well If you are A mobile Lover Let's Have a Mobile ''Japanese Mobile Phones'' 'Mobile Affiliate Program'' ''Venture Capital Directory'' '' pcmonde '' '' Bluetooth (...)
30 April 2009
dba_extents slow workaround: On some large 10.2.0... databases dba_extents can be very slow. Like select * from dba_extents where file_id = 87 and 253384 between block_id and block_id + blocks - 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- (...)
29 April 2009
cheap wholesale dreamgirl underwear: 0) wholeslae dreamgirl underwear in: [link] 1)wholesale jerseys in : [link] 2)wholesale ugg shoes in: [link] 3)wholesale jordan shoes and air force one shoes in: [link]
28 April 2009
Completely unsupported, I know (RAC 11g on a laptop): I am trying (for self educational purposes) to install RAC (11g) on a laptop using VMware with two guest clients (CentOS5 masquerading as RHEL5) in a cluster. Does anyone have an idea what the minimum physical RAM is on the host? I have 2GB, so when I try to allocate 1GB each to the (...)
28 April 2009
dbms_lob.fileopen hangs/won't return: Every time I run the code below, it just hangs. If I run it in SQL Developer it just sits there waiting on a response. Any one have any ideas why? This is a short version code I have in an application that opens a file/indexes the text, and it is causing the application to freeze up (...)
27 April 2009
Configuring icons with OAS 10g (Forms application): Hello, I'm getting desperate with the OAS 10g configuration. I'm tring to install a Forms & Reports 10g application, and I'm having no problems with the forms & reports. But, I'm not able to see the icons (gif format) in runtime. I haven't got any problem to (...)
27 April 2009
0,08 secs + 0,12 secs = 2 minutes when joined: Hi, I have a query that looks like: select ... from tab1, tab2, tab3, tab4, view where <+ many other clauses...> and view.xx = tab1.xx and view.yy = tab2.yy and view.zz = tab2.zz If I remove (comment out) the view and the where clauses (...)
27 April 2009
informations about physical file layout: Hello, i am looking for details about internal structure of the redolog files, tablespace files and controlfiles. Does anyone know a book or website to start. Best regards Thomas
27 April 2009
Best Oracle Intervew Topics resource: Visit this site to check all latest and complicated Oracle Interview questions. Good site which describes most of the Frequently asked and searched Topics explained. Good and simple tutorial. [link] Also visit this link to post your Oracle queries and get answered. (...)
27 April 2009
Where to write a transaction? Where to save it and how to invoke it?: How to tell the transaction to execute?
27 April 2009
Increasing Size of SGA_MAX in Oracle 10G: Hi People, I am running an Oracle 10G clustered database with ASM hosted on a SAM system. There are two instances accessing the DB from two different machines at any given point of time. Now my question is how do we change the parameter value of SGA_MAX_SIZE in such an environment. I (...)
27 April 2009
ORA-01113_ file 1 needs media recovery: Hi, Please find below an error screenshot. The system failed last week and we did recovery from the tape backup. Initially, there was error Message 4505 then Control_File mismatch errors but we managed to bypass all. Now, the database can be mounted but with this error as indicated (...)
26 April 2009
OEM GRID 10.2.0.4: Hi all, I am trying to do a ENTERPRISE MANAGER GRID CONTROL 10.2.0.4 installation on HPUX PARISC 64BIT [link] I am doing the software only approach using existing DB usign GUI method. So I have database 10.2.0.4.
26 April 2009
The Latest ::SOFTWARES::: This site has the best information about the best and the latest softwares from all over the world and of all types. It also provides their direct download links. for more info Visit [link]
25 April 2009
www.29usd.com Cheap replica fendi marc jacobs designer hermes handbag, women's coach juicy purses wholesale on (www.29usd.com): [link] wholesale and retail accept,dropship accept We Import & Export & Trading & Retail & sell & buy &sale & Distribution nfl team replica jerseys new china cheap authentic discount replica sell buy paypal wholesale manufacturing supplier sneaker,trainer (...)
25 April 2009
Download 100% free flash files: Free Flash files Download free flash templates/intros/animations and many more free fla files. 100% free [link] Free learning resource and download php/flash contact form [link] Download free flash buttons [link]
25 April 2009
Seeking Oracle Applications Developer (Seattle Contract to hire): Oracle Applications Developer Contract to hire _______________________Seattle _________________US Citezenship or Permanent residence required My Client downtown Seattle has an opening in their Technology Services Department for an experienced Oracle Applications Developer. The (...)
25 April 2009
Best and the Latest >>--:->(SOFTWARES)<-:--<: This site has the best information about the best and the latest softwares from all over the world and of all types. It also provides their direct download links. for more info Visit [link]
24 April 2009
comp softwares: SEXY GIRL hai.....friends and lovers....am priya.... your favorite softwares and any can take my website.... chat russian girls,,,love and romance girl...SEXY GIRLS ....for contact....MY WEBSITE.... ..love is true....and love make a life is beautiful....and enjoy the life!!!!!!1 (...)
24 April 2009
PLS-00801: internal error [phdcsql_canonical_sql]: Hi again Using a query like this: INSERT INTO OM_DB.CDRS_VALIDOS_TMP ( SELECT FROM ( SELECT FROM ( SELECT FROM ( ..... ) ) FULL OUTER JOIN ( SELECT .... ) ) ) I receive this errors: ORA-06550: line 0, column 0: PLS-00801: internal error (...)
23 April 2009
Database Size Limit with Oracle 10g Standard Edition: I haven't been able to find anything other than 11g specifications yet ... I remember once seeimg 10g specifications saying the maximum database size for the Oracle 10g Standard Edition was 500GB. Is that correct? Thanks.
23 April 2009
Mutating triggers & autonomous transactions: Hi all, I have an application that uses the pragma autonomous transactions inside trigger code to prevent the mutating triggers problem. I do not think you can use pragma autonomous transactions do this. Because an autonomous transactions is a new transaction with a new SCN. To me (...)
22 April 2009
identify an update transaction: Hi, what are the tables or views to usage to identify a session that is doing massive updates to the database and what is the query to use ? Thank's
22 April 2009
error handling using stored procedure: Hello everyone, Question: Is it possible to catch the error of duplicate key using an "insert into table select ...." inside of an stored procedure? Target: Execute my stored procedure each 15 minutes and insert all the non-duplicate records from a source table, and if its (...)
21 April 2009
my apologies for the misposted (now canceled) message.. wrong group: 21 April 2009
Generic procedure to produce INSERT scripts from table data.: Second attempt (apologies to those who got the first post before I canceled it) Folks, Below a procedure I wrote upon request which I figure may be useful for more people. This procedure fills a table with INSERT statements derived from the data of an arbitrary table, view, alias, or (...)
21 April 2009
Speculations on oracle buying sun: Certainly the java software may have been part of the appeal. How about the operating system ... will that mean anything at all? Perhaps there is actually a chance that oracle will now ship 10.2.0.4 patchset and 10.2.0.5 for Solaris x86 64 ... maybe. That was supposed to be here (...)
21 April 2009
Solaris 10/Oracle 9 memory problems - but I can't see why ...: Hello, Solaris sparc 5.10 running Oracle 9.2.0.764 bit EE. The server has 2Gb physical memory. The (offshore) unix monitors are telling me the server is running out of memory. They won't tell me anything else. I guess they think that'd take the fun out of it. There is one (...)
20 April 2009
Unbreakable Solaris: Oracle buys SUN! Some time ago, Oracle was a servant of the sun-god. Times are changing. [link] [link] [link]
20 April 2009
how to set seconds-precision for systimestamp: On Oracle 10g (10.2) installed on my home PC with vista premium: I tried the following to have systimestamp return 9 digits of precision - it returns 9, but the last 6 are all always 0. How can I see those missing 6 digits of precision? Thanks for any help. ken set serveroutput on (...)
20 April 2009
installation error: have downloaded all necessary packages needed for Oracle installation but with failure in installation as below : oracle @ inhome /opt/oracle/database>echo $DISPLAY 192.168.1.8:0.0 oracle @ inhome /opt/oracle/database>./chk_pkg .sh system SUNWbtool CCS tools bundled with SunOS (...)
19 April 2009
dba_hist_log and log switch history: anyone with a nice select for displaying log switch history from dba_hist_log thank u patrick
19 April 2009
add column to many tables at once: Could someone show me how I can add a column to many tables that have names starting with some similar characters? TIA.
19 April 2009
server managed backup on XE: Hi, ran into this document which says server managed backup is not available on oracle XE. But am able to run RMAN. Will that be a compliance issue, or did I miss something technically [link] Thanks Suri
18 April 2009
consistent read and LIO question: Hi Friends, I have one quesiton about consistent read and LIO. Are they same? But from my test, they are different. Below are my test case SELECT * FROM test_case1 WHERE id = 1000 ; There is primary key on ID column. Cost = 1 root + 1 branch + 1 leaf + 1 table = 4 LIOs But from (...)
18 April 2009
HTTP://WWW.GHOSTFASHION.COM NIKE AIR JORDAN FORCE FUSION SHOES AJF 5 V JORDANs 5 FUSION NIKE: shoes on AIR Jordan 1 (paypal payment)(HTTP://WWW.GHOSTFASHI ON.COM ) AIR Jordan 2 AIR Jordan 3 AIR Jordan 4 AIR Jordan 5 (paypal payment)(HTTP://WWW.GHOSTFASHI ON.COM ) AIR Jordan 6 Rings AIR Jordan 6 AIR Jordan 7 AIR Jordan 8 AIR Jordan 9 (paypal (...)
17 April 2009
Check for no more than two entries of each value in a column?: Hi, I need to create an app where any given employee may nominate up to TWO other employees per year for an award. This number could change. Now I could create a table like this: PK, U1 nominator (varchar2(12)) PK, U1 year (int) U1 nomination1_id (int) U1 nomination2_id (...)
17 April 2009
www.dudes-mall.com china cheap wholesale nike shoes,air jordan shoes,ed hardy,(jean,handbag,cap,sunglass,shoes,t-shirt)air force one shoes,lv,gucci,D&G,bbc,coach.free shipping !: Get Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
17 April 2009
Advanced SQL statements writing: I wrote this SQL statement: SELECT * FROM ((SELECT piecework_id,1+count(*) FROM view GROUP BY piecework_id) AS view1 LEFT OUTER JOIN (SELECT piecework_id, sum(status) FROM submission GROUP BY piecework_id) AS submission1 on view1.piecework_id=submission1 .piecework_id); It (...)
16 April 2009
utl_compress zip file: Hello, The following piece of code produces an ora-29294. If I save the contents of the variable uj after the base64 decode to a file, the file is a perfectly valid zip that can be unzipped. What am I missing? declare eredeti varchar2(6000) default 'UEsDBBQAAgAIAOZIhzpMHviiHAQAA (...)
16 April 2009
Can FROM be followed by a SELECT statement instead a table name?: Can FROM be followed by a SELECT statement instead a table name?
16 April 2009
Can I use a stored procedure to return a table?: Can it be possible?
16 April 2009
What is the best way to replicate few tables between 2 Oracle 10g severs ?: We need to replicate (1-way) a bunch of tables from Server-A to Server-B in close to real-time. Server-B is located in a foreign country. Apporx. # of tables to be replicated : 50 (size : 50 GB) Approx amount of data that gets replicated (changed data) per day : 100 MB Oarcle (...)
16 April 2009
What's the difference between temporary table and table variable?: How to use both?
16 April 2009
The performance of JOIN query and a query containing a subquery: To optimize the performance, is it better to rewrite a JOIN SQL query as SQL query containing a subquery?
16 April 2009
Cisco Network Admin: Hi , Hope you are doing good, below is a "Network Engineer" Position Details. If you are comfortable for this position please do send me your updated resume in the word format with the best number to reach. Job Title: Cisco Network Engineer.(Locals Only) Location: Eagan, MN. (...)
16 April 2009
Software Developer: Hi , Hope you are doing good, below is a "Developer" Position Details. If you are comfortable for this position please do send me your updated resume in the word format with the best number to reach. Job Title: Developer Location: NYC Length: 18 months. We are looking (...)
15 April 2009
Oracle vs SQL Server: We are currently evaluating Honeywell's Optivision software. This database options that we are looking at are Oracle and MS SQL Server. I looking for documentation or real world examples - why Oracle is better than SQL Server. I just cannot see going with a large installation of a (...)
15 April 2009
generate number of rows form a column value: create table test_table ( isim varchar2(50), cnt number); insert into test_table values ('John', 1) ; insert into test_table values ('Dave', 2) ; insert into test_table values ('Simit', 3) ; insert into test_table values ('TEST', 0) ; How can I generate (...)
15 April 2009
oracle database 9.2.0.8 32bit and windows server 2003 64bit: Hello! What about configuration like in subject... What about memory limits on 32bits? Can i rise sga more then 2GB? on 64 bit system but using 32 bit database? Any suggestion? Regards - MJ
15 April 2009
What is the cost of integrity constraints?: Does the database run much slower if there are many integrity constraints?
15 April 2009
What's the difference between snapshot and cache?: Can a snapshot creation be triggered by a INSERT INTO statement or something?
15 April 2009
Creating DB link with SQL Server: Hi, Can someone let me know how we can create a DB link between oracle 10G DB and an SQL Server. More in the line of using ODBC to create this. Thanks.
15 April 2009
Does a trigger eat resources when it doesn't do anything(No triggering event happens): How is a trigger implemented? Does a trigger eat resources when it doesn't do anything(No triggering event happens). IMAO, I think that because a trigger needs to keep alert, so it often consumes memory even if it doesn't do "anything"(No triggering event happens.) Am I (...)
15 April 2009
Geocoding in Oracle with the 2008 TIGER data: Hello everyone, I am new to Oracle Spatial and am wondering if it is possible to use the 2008 TIGER shapefile data with Oracle Spatial's Geocoding package. From the information that I have read so far, it looks like I would have to convert the TIGER data into a specific format (the (...)
14 April 2009
Table Join: Hi, I'm hoping that there is a slick way to do this. I have 2 tables (below). They both have the same structure except for the first column. Is there a way to compare the tables and get the differences from TABLE A that are not in TABLE B, without having to use (...)
14 April 2009
OEM Upgrade from 10.2.0.1 to 10.2.0.5: Hi all, I am doing a fresh install of Oracle Enterprise manager on Linux 32 bit using OLE5.3 using How to Install Grid Control 10.2.0.5.0 on Enterprise Linux 5 Using the Existing Database (11g) Option Doc ID: 784963.1 As per the Metalink note I am doing software only install of (...)
14 April 2009
RMAN and re-do logs: Oracle 10.2.0.4 production RAC on windows 2003 x 64 We are completing a restore procedure that includes clearing out redo- logs from an ASM directory and doing the usual restore & recover For some reason we get a problem with redo / we do have to do rename the disk group as this has (...)
14 April 2009
oradim util manual: Hello! Im looking from oradim util manual some one have ? Mayby some links?? Regards..- MJ
14 April 2009
10g clusterware causes reboots: I have Linux (OEL5.2) running 10g clusterware on 2 nodes. OCFS2 is running as well, with a SAN-based OCFS2 filesystem mounted on both hosts (written to by only one until the other fails over). When I reboot one host, the ethernet interface eth0:2 appears on the other, assuming the VIP (...)
13 April 2009
WWW.KICKSQUALITY.COM**&&sell *Ed Hardy tshirt$18*Jordan*Coach handbag $37$35*AF1 $35@@@&&wholesale*Ed Hardy shoe $36*True Religion jean $36*Evisu jean $35*Polo Shirt $12: WWW.KICKSQUALITY.COMwholesale cheap Jordan, china Nike factory Jordan wholesale, cheap Jordan spiz'ikes, air Jordan factory directn, Jordan mixed with air force one new style, cheap air force ones outlet, authentic Nike af1s,air force 1 xxv'07 anniversary edition premium, custom (...)
13 April 2009
Scalar queries in select clause: I have a bunch of queries that have scalar subqueries in the select clause. From the plan, I see the one with the scalar subqueries has lower cost. Am I missing something ? Is there real benefit in writing queries using scalar subqueries in the select clause ? SQL> desc t1_test (...)
12 April 2009
How to turn on logging in Oracle?: To debug an existing issue, I need to turn on and log all the SQL Statements issued from 3 Clients (not the logging for rollback). May I know how to do that? I have admin password. TIA
12 April 2009
sqlplus termout out: May be a easy question. From the manuals, the "set termout off" sqlplus options suppresses the output to the terminal, but I can still see the output on the terminal. Is there anything more to it ? sqlplus -s AAA_owner/AAA_owner@AAAngrp <<EOF set feedback off set (...)
11 April 2009
How stable is Oracle 11i?: I have some Oracle 9i based databases. These database are used for critical production systems, We are looking to upgrade the databases to newer version of Orcale. I am wondering whether I can upgrade them to 11g (instead of Oracle 10.2.0.x), I find Oracle 11g has lots of nice features, (...)
11 April 2009
Junior QA Analyst (Need Locals) (GC or Citizen): Hello , Hope you are doing good, below is a " Junior QA Analyst" Position Detail's. If you are comfortable for this position please do send me your updated resume in the word format with the best number to reach. Job Title : Junior QA Analyst (NEED LOCALS) Location : (...)
10 April 2009
same application on multiple schemas: Hello, I'm designing a new big application. The application will be instantiated for multiple users. Each application must have its own "database", or schema, Oracle speaking. Every schema should have separate datafiles in its own application folder. Databases will be on a (...)
10 April 2009
Clarity Developer: Hello , Hope you are doing good, below is a " Clarity Developer" Position Detail's. If you are comfortable for this position please do send me your updated resume in the word format with the best number to reach. Job Title : Clarity Developer Location : Chandler AZ (...)
10 April 2009
Linux flavor: Could someone please inform me what version of Linux is good for learning and trying out Oracle DB? Thanks.
9 April 2009
SQL DBA (please send the resumes to syed@catstaffing-us.com): Hello , Hope you are doing good, below is a " Senior Software Developer" Position Detail's. If you are comfortable for this position please do send me your updated resume in the word format with the best number to reach. Job Title : Senior Software Developer Location : (...)
9 April 2009
Earn $25000 monthly. Easy form filling jobs: We are offering a rare Job opportunity where you can earn from home using your computer and the Internet ? part-time or full-time. Qualifications required are Typing on the Computer only. You can even work from a Cyber Caf?r your office PC, if so required. Working part time for 1-2 (...)
9 April 2009
Oracle Engineer - Earth City, MO: Hello, Hope you are doing well, I have the following position, Please reply with contact details and resume. Title: Oracle Engineer Location: Earth City, MO Duration: 6+ months Looking for an Oracle engineer (not developer) who has worked with SAP backend. Should be genuine (...)
8 April 2009
Re-org of partitioned tables: I have strange situation.I have table which is already partitioned by range.This table has partitions upto 2007 November.And there after the rest of the records are moving into MAX partition.Now we are planning to split the max partition so that access of data will be more ease.With (...)
8 April 2009
unknown files in /tmp: I'm running Oracle 11g EE 64bit on Solaris SPARC 10 for testing and developing purposes. $ORACLE_SID=11g. In directory /tmp I found some files I've never seen before: oracle dba 8192 Apr 1 20:47 .SHMDJOXSHM_EXT_0_11g_1 oracle dba 8192 Apr 1 20:47 .SHMDJOXSHM_EXT_1_11g_1 (...)
8 April 2009
Lacoste Puma Adidas Trainers at www.hiphopurbanclothes.com: Designers Sunglasses Wholesale at Www.hiphopurbanclothes.com Discount For DG sunglasses suppliers, wholesale cheap price dior fendi sunglasses womens, lady dior sunglasses 2009 new styles, burbery glasses replica from china shop, top quality for cartier sunglasses, belts, fashion mont (...)
8 April 2009
'lost updates' for web apps: Could someone please inform me if setting ISOLATION LEVEL to either 'READ COMMITED' or 'SERIALIZABLE' can remedy 'lost updates'problem for web-apps? I am using Oracle 10G. TIA.
7 April 2009
Query to find first missing integer in a field: Does anyone know a good way to find the first free integer number that does not exist in a table in a specified column? I can think of a couple of tedious ways of doing this but they are hardly elegant. Assume there could be any integer present up to 2 (...)
7 April 2009
Database practices/operations evaluations.: Hi All - I need your suggestion to evaluate the processes/practices in one project. Manager wants to see the comprehensive audit/evaluation for database track and come with suggestion for cost saving/improvement plans. Can any one of you give me some link of good documents and share (...)
6 April 2009
WE8ISO8859P1 convert to AL32UTF8 unicode character set question: Hi Friends, I have one question about CSSCAN when I do conversion from WE8ISO8859P1 to AL32UTF8 unicode character set. create table aaa (c1 varchar2(10)); insert into aaa values ('sys.…Med'); After csscan the data, get the application exception data as below (...)
6 April 2009
"ORA-00984: column not allowed here" Creating table: Hi All, I'm sorry if this has been asked before, but my searching has only thrown up all kinds of error, which don't quite match what I'm doing. I am creating a table bar with multiple columns, where foo_id is a foreign key reference to the table foo, CREATE TABLE bar ( (...)
6 April 2009
V$TRANSACTION.STATUS='PREPARED': Hi All, We have a large and very active CRM system, most transactions last only a few minutes, however I noticed entry in V$TRANSACTION that has START_TIME more than 10 hours ago. Column V$TRANSACTION.STATUS has value 'PREPARED'. There are no entries in DBA_2PC_PENDING. (...)
6 April 2009
christian audigier woman,discount christian audigier,christian audigier dsquared2 (www.trade8.cc): label man,black label long jeans,Men's Black Label relaxed jeans - 38. ... Long 38" inseam; Black Label Cinch jeans - reg inseam, The Cinch Black Label jean was destined to be,Black Label long jeanscheap christian audigier,christian audigier long jeans,christian audigier (...)
6 April 2009
█▓۞۞▓ Enjoy , Shilpa shetty hot sex & Juicy boobs through wet top ▓۞۞▓█.,: █▓۞۞▓ Enjoy , Shilpa shetty hot sex & Juicy boobs through wet top ▓۞۞▓█ Bollywood Appetizers~Sexiest nude pictures collection [link] Sexy and Hotty Hollywood actress Showing Tits and Pussy - Too Spicy (...)
6 April 2009
www.stylishdudes.com china cheap wholesale nike shoes,air jordan shoes,air force one shoes.: Get Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
6 April 2009
Active data guard vs streams/shareplex: We currently use sharplex to replicate from a source to a target. However with the 11g active dataguard we considering replacing shareplex. The question is can the new dataguard serve as a replacement for streams/shareplex. The source and target need to be in-sync pretty much real time. (...)
5 April 2009
A great opportunity to US Accountants(receivables)@Hyd: V-Soft Consulting group Inc. is looking for US Accountants, to work offshore from Hyderabad: Desired Candidate Profile 2-3 yrs.Experience in Quick Books Hands on experience in US accounting, accounts receivables Good exposure to Ms Excel Person from Consulting/recruitment company is (...)
5 April 2009
Very BEAUTIFUL Bikes,LAPTOPS AND MOBILES FOR SALE 80% DISCOUNT HARRYUP,Take Your NeeDs Here Now,: Very BEAUTIFUL Bikes,LAPTOPS AND MOBILES FOR SALE 80% DISCOUNT HARRYUP,Take Your NeeDs Here Now, [link] $@$@$@$@$@$@$@$@$@$@$@$@$@$@$@ $@$@$@$@$@$@$ *#*#*#*##*#*#*#*#*#*#*#*#*#*#* #*#*#*#*#*#*#* Very BEAUTIFUL Bikes,LAPTOPS AND MOBILES FOR SALE 80% DISCOUNT HARRYUP,Take Your NeeDs (...)
4 April 2009
UNDO: 10g-style behaviour in 9.2.0.8?: Hi All, It is my understanding that UNDO works differently in 9.2 and 10.2. Size of undo datafiles is fixed, AUTOEXTEND is OFF. 9.2: Oracle will maintain undo blocks according to UNDO_RETENTION. If UNDO tablespace is large and UNDO_RETENTION * undo bloc generation is low then the (...)
4 April 2009
oracle update query is taking lot of time..: Dear Experts, I have a very huge table having 89 columns and 100,00,000(1CRORE) records. update customers_master set status='R' where REC_ID in ( select REC_ID from customers_master where ( (firstname is null and lastname is null) or address1 is null or mobilenumber (...)
2 April 2009
ORA-00904 with dbms_metadata.get_ddl: Hi all, does anyone have seen the following problem: SQL> select dbms_metadata.get_ddl('INDEX', MYINDEX) from dual; * ERROR at line 1: ORA-00904: invalid column name Metalink is not able help me, and google so far... Thanks (...)
1 April 2009
stop import datapump: Hi, Someone could tel me how can i do to stop Datapump_job whit sqlplu ? thank's
1 April 2009
[LONG] Logical block corruption: Hi all, from yesterday my RMAN full backup is failing due to logical block corruption. Using dbv I've found that all datafiles belonging to a tablespace have index pages corrupted. Block Checking: DBA = 260237463, Block Type = KTB-managed data block **** actual rows locked by itl (...)
31 March 2009
using Select count(*): Thanks in advance for any clues... I am rather new to Oracle so here goes. I have a package body / query that is returning data with no problems. I do however need to take this package body and rewrite the code above the " select p.pr_p_i_n "PIN"," line to allow me to (...)
31 March 2009
Converting query result to inlist - View performance: I have a complex view created from which I can query from for data refresh purposes. The following query runs fine without any problems select * from <complex view> where cola = :value or select * from <complex view> where cola in ( :value) But, If I change the :value to (...)
31 March 2009
www.fashion4biz.com wholesale evisu jeans design stretch classic jean japan brand top quality comfortable: fashion jeans (paypal payment)( [link] ) denim jeans(paypal payment)( [link]) men's jeans brand jeans (paypal payment)( [link] ) women jeans' jeans (paypal payment)( [link] ) branded jeans (paypal payment)( [link] ) designer jeans men jeans (paypal payment)( [link] (...)
31 March 2009
very important for your life...: very important for your life... Excuse me!! Would you stop for a moment?! O...man...Haven't you thought-one day- about yourself ? Who has made it? Have you seen a design which hasn't a designer ?! Have you seen a wonderful,delicate work without a worker ?! It's you and (...)
31 March 2009
Oralce 10gR2 Setup questions: I have been running Oraclee 9.2 in WIndow2000 Server. I have the folowinf setup: Drive C: Oracle Home; Drive D: Tablespace for Data; Drive E: Tablespace for Index; Drive F: Archive redo Log; Drive G: RMAN Backup location. This database supports a busy on-line system with 24X7 update. (...)
31 March 2009
ASSM tablespace three level bmp block questions.: Hi All I have one question about ASSM tablespace. The ASSM tablespace has three level BMP blocks to indicate if block is used. How many blocks does one L1 BMP block manages? After do one test, I found the number increases when the data increases. Is there any rule about it? How (...)
31 March 2009
Edit records with an Oracle client: I just loaded the 10g client EM on my Windows workstation to connect to our 10g database. Everything works great except I dont see any place where I can edit records. I have to use SQL Plus to edit records but was hoping to use a GUI like I had with 9i client OEM. Before we had 10g, I (...)
31 March 2009
Convert datediff hrs into hrs, min & sec: Hi All, I have : XX@MYDB9I:XXXX> desc t1; Name Null? Type ------------------------------ ----------- -------- ------------------------------ -------- OBJECT_NAME VARCHAR2(128) CREATED DATE LAST_DDL_TIME DATE DAY_LIGHT_SAVING_IN_SEC NUMBER (...)
30 March 2009
Direct Client Requirement For Senior DB Developer: Hi Hope you are doing great. Do send me your updated profile, if you are interested in below requirement. Please response to shant...@ibs-consulting.net or call me on 732-981-0450 x 425 Position : Senior DB Developer Rate:- Open Duration : 6+ Months Location : Austin, TX Job (...)
30 March 2009
Materialised view persformance: All, When I do a "select count(*)" from a materialised view I have created and compare the execution time with the same select on the table the materialised view is being driven off, the time for the materialised vew is much slower even though the number of rows is the same. (...)
30 March 2009
How to print floating point data with commas and $ ?: I've a column of salaries in a table and I want them to print in the format $999,990.00. How to go about doing this ?
30 March 2009
oracle standby datase with select option: Hello!! I need to create test database like production database. The best solution for now is standby databse but it not good enough there is any other solution????? I need to update test databse for every 5 min... Regards
30 March 2009
oracle aplication server forms users session and replace fmx - SOLVED!!!! :-): HELLO!! I know now how to check wich user use actualy fmx when programmers whant to replace that fmx they can`t... but.... You need download program from sysinternals Process Explorer - [link] Open, click Find/Find Handle - write fmx or other file name click (...)
30 March 2009
www.stylishdudes.com china cheap wholesale nike shoes,air jordan shoes,ed hardy,(jean,handbag,cap,sunglass,shoes,t-shirt)air force one shoes,lv,gucci,D&G,bbc,coach.free shipping: Get Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
30 March 2009
Is there an automated way to rename listener log file: I am using Oracle 10.2.0.3. My listener log file keeps growing. Our servers are rebooted every weekend. I am on Windows 2003. Is there a way to give a unique name to listener log file any tme listener is started. I know how to do it in UNIX uisng my own shell scripts, but in Windows (...)
30 March 2009
Local Tablespace L1 BMP DBA Range number question: Hi All Local tablespace L1 BMP DBA Range The L1 BMP DBA Range number increases, What is the rule? L2 BMP L1 Range keeps same about 241 when the blocksize is 2048. is that right? Below is test case. 1. drop tablespace and create tablespace drop tablespace aaa including contents and (...)
29 March 2009
www.dudes-mall.com sell:nike shoes:$32,handbag:$35,NFL:$20,jean:$30,ed hardy,(jean,handbag,cap,sunglass,shoes,t-shirt)air force one shoes,lv,gucci,D&G,bbc,coachUGG boot:$50,.free shipping!: Get Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
28 March 2009
Debugging a buffer busy waits: Hi all, Last day I've encountered a problem with a procedure waiting due to a buffer busy waits. In v$session_wait I've found FILE# and BLOCK#. Looking in DBA_SEGMENTS I've discovered incriminated blocks is belonging to a table called 'DUMMYTBL'. Ok, now I can (...)
28 March 2009
Web Hosting, Reseller Hosting, and Dedicated Hosting!!!!!!: PREMIUM WORDPRESS BLOG HOSTING!! -Word press Hosting -Unlimited Domains -Panel Hosting -Unlimited Blogs -$7,95 per month [link]
28 March 2009
www.stefsclothes.com china cheap wholesale nike shoes,air jordan shoes,air force one shoes: Get Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
28 March 2009
what tool for debugging web toolkit output: I wrote a form using the pl/sql web toolkit. The form fields and the form handler parameters all appear to match up. It compiles all right but when I run it in a browser and click the submit button, I get an HTTP 404 error. Does anyone have any suggestions what might be wrong or how to (...)
28 March 2009
Oracle Lock Problem: Hi, How can I find the SQL statement that make the table lock? Ming
27 March 2009
www.stefsclothes.com china cheap wholesale nike shoes,air jordan shoes,ed hardy,(jean,handbag,cap,sunglass,shoes,t-shirt)air force one shoes,lv,gucci,D&G,bbc,coach.free shipping !: Get Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
27 March 2009
Trigger question..please help.: Hello, I've an employee table which I created as follows: CREATE TABLE employee (fname VARCHAR2(15) NOT NULL, minit VARCHAR2(1) NULL, lname VARCHAR2(15) NOT NULL, ssn VARCHAR2(9) NOT NULL, bdate DATE NULL,
27 March 2009
OCCI connect vs. sqlplus: This works great: $ sqlplus smiller/mill@oradev But connecting to the same db from the same box with this OCCI C++: std::string user("smiller"); std::string pswd("mill"); std::string db("oradev"); Environment *env = Environment::createEnvironment (); (...)
27 March 2009
REGEXP_REPLACE help: Oracle 10.2.0.3 Windows 2003 Server I have a query which was designed using a regular expression to get the LAST and FIRST name from a column which had one string in the format of LAST, FIRST MI/NAME in one column. It originally worked written as: last_name = regexp_replace(name, (...)
26 March 2009
fetch size too big causes hang: I once had a good connection from my machine to our Oracle server, but something has gone wrong lately apparently with transferring packets over the network. Here's the symptom: I connect in SQLPlus and do a large select. Records scroll by. I then fool with SET ARRAYSIZE and do the (...)
26 March 2009
RMAN or Hot Backup: We run RMAN. We have some people here that are fighting to stop using RMAN and move to Hot Backups. I prefer RMAN, but I'm curious on other opinions.......
26 March 2009
Output from pl/sql-block: Hi, is there a way to output from pl/sql-block before end of the block ? I need to: 1) ask some parameters 2) count how many rows are found and show it to the user 3) ask the user, if she/he really wants to update I would like to do it in one pl/sql-block, but since the (...)
26 March 2009
calling a function over db link that creates a table in target db: 10gR2 on target db I have following function: CREATE OR REPLACE FUNCTION prepare_table ( table_name in varchar2) return varchar2 IS err_num NUMBER; err_msg VARCHAR2(100); sqlstmt varchar2(4000) := ''; tbl varchar2(30) := ''; BEGIN if (...)
26 March 2009
Delete from table taking time: Hi Gurus I am having a problem of slowness in deleting the data from a global temporary table. The scenario is like I have a global temporary table which is populates in a procedure. The no of rows populated are approximately 0.5 million and its going to increase in future. The (...)
26 March 2009
(paypal payment)(www.king-trade.cn ): (paypal payment)([link] ) Electronics Vertu Mobile New iphone Mobile Nokia Mobile moto Mobile PSP Game & memory card Sony Mobile Samsung (paypal payment)([link] ) Mobile Ipod nano Sony PS3 Laptops IBM laptops DELL laptops Sony laptops ASUS laptops (paypal payment)([link] (...)
26 March 2009
User-defined metrics in Grid Control: Hi I want to create a user-defined metric to return some value for specific targets (disks). The script would do its thing and return the result as "em_result=1234". My problem is that the same script is used to do the processing on all target disks. How can I pass it a (...)
25 March 2009
Has anyone performed upgrade to OEL 64 bit 5.3 yet?: We are running OEL 5.1 currently ... just starting to think about upgrades to 5.3. Along with the installed oracle software on my systems ( hoping relink all will work ... will research and test etc ) have a manageable number of 3rd party products ( EMC Powerpath ... IBM stuff ... etc ) (...)
25 March 2009
RMAN Error: We've started receiving this error. I'm trying to track to see if it is related to anything, as we did need to run a CROSSCHECK this morning, but, is this serious? It causes the backup not to run: RMAN-03002: failure of delete command at 03/25/2009 04:11:33 ORA-04068: existing (...)
25 March 2009
Low cardinality in OLTP with high concurrency: Hi Gurus I am struct with a problem of slow performance of a query. The problem is because of low cardinality. A table contains about 1 million rows which increases daily. there is a column which contains 16 distinct values say AOFA, AOFB,SIGN etc etc. When i run a query with (...)
25 March 2009
Re: What index do I need for this query ?: The index that will be apparent when you normalize your database design to avoid searching on taxno substrings and nulls. jg
25 March 2009
Pushing predicates - Analytic functions in Views: One of the views used in my application has analytic functions in them. The base tables in the view are kind of big. About 102 million, 86 million, 17 million joined. The view is not performant with the analytic function. If I remove the analytic function, the it runs fine. I have (...)
24 March 2009
www.fashion4biz.com Wholesale evisu jeans design stretch classic jean JAPAN brand top Quality Comfortable: fashion jeans (paypal payment)( [link] ) denim jeans(paypal payment)( [link]) men's jeans brand jeans (paypal payment)( [link] ) women jeans' jeans (paypal payment)( [link] ) branded jeans (paypal payment)( [link] ) designer jeans men jeans (paypal payment)( [link] (...)
24 March 2009
FREE DOWNLOAD--SPECIAL 1000JAPAN GIRLS RAPE --- 1000Girl - Emi Rib - Uncensored [RMVB] + Vietnamese Girls Pic Collection 4 (inside bonus;MISS MAXIM THAILAND 2008)---FREE DOWNLOAD XXX JPAN RAPE MOVIE++++Super Bonus FREE XXX Games: FREE DOWNLOAD--SPECIAL 1000JAPAN GIRLS RAPE --- 1000Girl - Emi Rib - Uncensored [RMVB] + Vietnamese Girls Pic Collection 4 (inside bonus;MISS MAXIM THAILAND 2008)---FREE DOWNLOAD XXX JPAN RAPE MOVIE [link] +++++Super Bonus FREE XXX (...)
24 March 2009
FREE INVITE: Experts from Polaris, Hexaware, Cognizant, EDS to speak at Business Intelligence Conference (March 28): Hello, If you are a BI/DW Architect or Application Developer, here's your chance to enhance your skills and learn from industry experts for FREE. The following experts will be giving technical tutorials: Siva Lakshmanan, CEO & Co-founder, Aldea Infotech Muniswamy Rajakumar - (...)
24 March 2009
re: C++ equivalent type to Oracle's rowid.: Hi, What is the C/C++ equivalent to Oracle's rowid? Currently I am using OTL 4.0 and passing/returning rowids to Oracle stored procedures e.g.: insert into ... values( .. ) returning rowid into rw_id; # returning id update ... set .. where rowid=ord_id; # passing in id Right (...)
24 March 2009
Connecting to RAC on a different network than the one on which VIP is set up: Hi, I am trying to set up Streams in Oracle 11g between two RAC databases. Unfortunately the connectivity between the two databases is on a different network than the one on which the VIP is set up. In doing sqlplus from one to the other on this other (management) network, I get these (...)
23 March 2009
ugg boot,t-shirt,handbag,sunglass,hat,nike shoes,jordan shoes,dunk shoes,puma shoes,and so on for free shipping from: We are wholesaler of Nike Jordan and Other Shoes in China. We are a professional exporting company in china. We supply many kinds of Shoes, such as Nike Shoes, Jordan 1-23, Air Jordan, AF1, DUNK, Air max series etc. Most of them are in stock and can be supplied surely on time. All (...)
23 March 2009
WWW.STEFSCLOTHES.COM cheaper nike shoes g-satr kidrobot hoodies ed hardy star red monkey gino green global true religion ed-hardy kidrobot jeans hoodies china supplier wholesaler exporters,manufacture: Get Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
23 March 2009
Joining two disparate tables: I have 4-5 tables joined to do a query from multiple tables with the number of rows in those tables ranging from 10^5 to 10^7. Though I already take a severe performance hit, I had stated that as a limitation in my product and the customer lived with it and also the response time (...)
23 March 2009
www.fashon4biz.com NIKE AIR JORDAN FORCE FUSION SHOES AJF 5 V JORDANs 5 FUSION NIKE: shoes on AIR Jordan 1 (paypal payment)([link] ) AIR Jordan 2 AIR Jordan 3 AIR Jordan 4 AIR Jordan 5 (paypal payment)([link] ) AIR Jordan 6 Rings AIR Jordan 6 AIR Jordan 7 AIR Jordan 8 AIR Jordan 9 (paypal payment)([link] ) AIR Jordan 10 AIR Jordan 11 AIR Jordan (...)
23 March 2009
returning array type from a function: I am wondering why following returns PLS-00382: expression is of wrong type I declares in package specification TYPE index_record is record ( index_type varchar2(2) := 'BT', index_name varchar2(27) := ''); type assoc_array_index_recs is table of index_record index by (...)
23 March 2009
How to pass Oracle certification exam?: How to pass Oracle certification exam? Only $30, you can get a pass4sure to pass Oracle certification exam easily with hign scores. [link]
23 March 2009
Testing rman recovery from block corruption in an 11g ASM environment: Disclaimer and caveat: Testing database recoveries is a DBA responsibility. Each time you migrate environments this really must be done ... you don't want to be in a place where you tell management ... well the last time we tried this ... several years ago on a different os ... (...)
23 March 2009
composite primary key vs. primary key on additional single column: we have 2 tables: individuals1 with primary key on ind1_id (numeric field) and individuals2 on ind2_id (varchar2 field) individuals1 has as well ind2_id populated for some rows (not all) individuals2 has as well ind1_id populated for some rows (not all) both tables have common (...)
22 March 2009
work from home and earn 1000/- daily: I want to tell you about a great site I found. They pay me to read e- mail, visit web sites and much more. [link] Win cash Rs.10,000. SMS BLUFF to 57333 (India Only) Free registration! - [link] Send SMS to India @ 1 Cent / SMS! Packs Start $2 Only (...)
22 March 2009
www.stylishdudes.com sell:nike shoes:$32,handbag:$35,NFL:$20,jean:$30,UGG boot:$50(free shipping): Get Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
22 March 2009
10g install problem - didnt set orcl instance passwords: Hello. I'm an oracle novice and have just installed 10g on my XP laptop from a download. I didn't enter a password for the "orcl" default db instance, and now cannot login to OEM. I can get into SQL*Plus, and understand that I should be able to reset passwords there. (...)
21 March 2009
Re: Fun Time...: presuming you desire viruses, trojans and the like from a suspect website.
21 March 2009
drop package. Where are the grants ?: From some tests, I understand that when a package is dropped and recreated, the grants need not be given again. I don't see those grants in the dictionary tables, but the package executes fines from ua_system_app user. Am I missing something ? SQL> connect (...)
21 March 2009
change the hostname and IP address on linux database server: Dear group, We have a oracle 10.2.0.1 installed linux box. Now i need to change my hostname and IP address, do i need to re-install the Oracle? And ultimate question is, can i just tar my Oracle Home and move it to different hosts, as long as the OS structure are the same? Thanks for (...)
20 March 2009
Free Natural Beauty Tips: All Natural Beauty Tips For You, Full Range Of Homemade Remedies, Cure All Your Skin Problems, Fast & Effective Results - 60% off Beauty Secret Kit at, .. [link].
20 March 2009
Granting table SELECT to another user: Hi, I've got a tool, that creates tables "on-line", i.e. tables are beeing created when end-user is on action. And then there's a "viewer" end-user who should have a SELECT-grant to all those new-born tables... Yes, granting select to any table might to do (...)
20 March 2009
oracle application server forms changing problem: Hello! Out programmers for evry 1 houre change somethig in forms files when they try tu update old form file to new(fmx) they cant becouse someone is using already that old(fmx). I there any option in application server to show who is using fmx file???? (...)
19 March 2009
very slow archivelogs write: Hello! I have archivelog enabled on my oracle 9 database. I have 2 destionations of my arch local and remote. When all redologs full and remote destionation is enabled database hang until finished copy archivelog to remote. But when i turn off remote dest when redologs full nothing (...)
19 March 2009
Merge Statement: Merge statement is useful, but can it do anything in this situation: I have the following: Product Table: PRODUCT_CODE, PRODUCT_DESCRIPTION. Lookup Table: PRODUCT_ID, PRODUCT_CODE Updates: PRODUCT_ID, NEW_DESCRIPTION I need to update or insert the Product Table. But, in order to use (...)
19 March 2009
RAC Node deleted: Hi All, On our test environment, One of RAC node (rac2) is deleted before dropping with proper steps from other nodes. Kindly let me know, if is there any way, that related entries can be removed from rest of nodes. Following are the rest of the details: Linux 4 is OS Database ver (...)
19 March 2009
program for analyze archive logs: Hello! Im looking for program to analyze archive logs. It shows me what update,insert etc. are done on database. I open one of my arhive logs and see that insert into was done at 4pm Regards
19 March 2009
Tuning direct path read (lob): Hi, I'm currently investigating a possible performance problem with a Oracle 8.1.7 database on Windows XP (I know 8i is out of support, but this is an "embedded" database that comes with the application). A statspack report showed me that the biggest amount of waits were (...)
19 March 2009
After statement level trigger iring before after row level trigger: I have a database table which has an after statement level trigger firing before the after row level trigger, does anyone have any suggestions as to what could be causing this?
19 March 2009
Old application forms: Hi I have an old application with 8i and Forms how can I migrate it to 9i, 10g ? Thanks in advance
18 March 2009
Is there a tool to allow users to build algorithms that are then run by database: Using Oracle 10gR2 on unix Solaris. We have a database that has equipment tables, readings tables, and lookup tables associated with equipment. we will take both join them, apply algorithms to create a health index for each piece of equipment (e.g. take age, oil readings, etc, add, (...)
18 March 2009
Save 30% on Kaspersky Internet Security: [link] [link] [link] [link] HOT SALE SOFTWARES & SPECIAL OFFERS TODAY 1.Microsoft Office Home and Student 2007 2.McAfee Internet Security 2009 3-User 3.TurboTax Deluxe Federal + State + eFile 2008
18 March 2009
too many archive logs: I'm running 10.2.0.4 on solaris 10 (sparc 64). I'm in archivelog mode with 3 groups of redo logs sized at 200M (at 100M I was getting checkpoint can't complete messages). I've got archive_lag_target set to 900. Watching the alert log all seems to be fine. However, when I (...)
18 March 2009
Bought a Pass4Sure of Oracle certification exam is very cheap: Bought a Pass4Sure of Oracle certification exam is very cheap All pass4sure of Microsoft are only $30 [link] [link] [link] Oracle Certification Exams Testing Engine,Braindumps and Q&As
18 March 2009
Fast schema duplication: Hi all, I've to duplicate frequently a schema. Usually I do it with exp/imp, but I'm looking if there's a PL/SQL package make me able to do it direcly from SQLPLUS and maybe to make my customer to do it without call me ... Thanks (...)
18 March 2009
Nothing like an ORA 600 in the middle of a recover database eh?: Nasty bug in 64 bit 11.1.0.7 ... ( we are running OEL 5.1 ). So you are in the middle of a recover database and forward recovering with archive logs ... then you see this: ORA-00279: change 568074198 generated at 03/13/2009 10:47:27 needed for thread 1 ORA-00289: suggestion : (...)
18 March 2009
dba_lmt_free_space: Hi, I am trying to see why there is a huge difference between these two sqls: SQL>select sum(BLOCKS) fr from dba_lmt_free_space where file_id=8; FR -------------- 257280 1 row selected. QL>select sum(BLOCKS) fr from dba_free_space where file_id=8; FR --------------- (...)
18 March 2009
Query help please: Hi, How can I optimize this query (30 min) (9.2.0.6) Thanks for your help .... p49> SELECT mds.messagepartdata, ms.status, mi.ID, mi.messageguid, mi.channel, 2 ROWNUM AS messagecount 3 FROM pfmq_messagedata md, 4 pfmq_messagedatastorage mds, 5 pfmq_messageinfo (...)
17 March 2009
Employment Opportunity for Sr. Oracle Developer - PL/SQL: Sr. Software Developer - Oracle Seattle, WA 3 mo. Contract to Hire Come work for an exciting company that provides users access to millions of songs and videos from all major labels and thousands of independent labels, available for sale as MP3 downloads, streams or part of (...)
17 March 2009
SQL*Developer 1.5.4 has a very serious bug: The export of SQL results does not work. Nothing, nada, zilch. I could not get the results of my query to the management. I am switching back to 1.5.3.
17 March 2009
Table size and dates: Dear Friend How can we find the size and creation date of the particular table Thanks
17 March 2009
Performance issue: our database oracle 9i is running on tru64. Db's performance degrades as the time goes on, later we bounce the DB and also restarts the machine. after restart the performance increases drastically and as time goes performance degrade. Can anyone tell what the problem is and also a (...)
17 March 2009
Buy Trend Micro Internet Security Pro Receive H&R Block TaxCut Premium Free!!: Buy Trend Micro Internet Security Pro Receive H&R Block TaxCut Premium Free!! [link] *McAfee Internet Security 2009 3-User With the daily emergence of new and more sophisticated Internet threats that could disrupt your digital life, you need more than a simple anti-virus program (...)
16 March 2009
popular storage for ORACLE RAC: Hi there, I am trying to determine what is the most popular storage solution for Oracle RAC. Specifically I am trying to compare NAS (NetApp, EMC, Sun, etc) versus RedHat cluster file system, versus Veritas, versus any other solution out there. Which is the most mainstream? (...)
16 March 2009
Is comp.databases.oracle.server dying?: Hi all, I've followed this group on and off for a while now, and am just wondering is it dying? Time was, there'd be over a hundred posts a day, now the traffic seems right down. Is this true or is it my imagination? Have the forums.oracle.com boards helped the decline? (...)
15 March 2009
Oracle Magazine - Free Subscription: Free Subscription here.. [link] Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software (...)
15 March 2009
Upgrade Oracle Application Express: Hi, can I upgrade Application Express of and Oracle database Express Edition ? Regards. Ganimede Dignan.
15 March 2009
Patch Oracle Express Edition: Hi, can I patch with last patchset 10.2.0.4 an Oracle Express Edition ? it's should be 10.2.0.1 Regards. Ganimede Dignan.
15 March 2009
you have the golden oppourtunities to earn more money in the morden world: no investment: no physical work: no tension: earn more money in the home: per day earning is 10$ to 12$: we can do it as part time job: minimum one or two hours: click here below: ****************************** ****** [link] ****************************** (...)
15 March 2009
www.gobizunitestates.com cheap jordan jumpman team pro shoes: addidas wholesalers distributor bulk air force ones for sale ([link]) Burberry Handbags made in China ([link]) juicy hoodies on sale Buy wholesale from china GUCCI ([link]) buy jordans made in china ([link]) buy nike shoes at wholesale (...)
14 March 2009
Partitioning on Timestamp with Time zone column in 10g: Hi Is partitioning on Timestamp with Time zone data type possible in 10g? WHen I try the following it reports ORA-03001 unimplemented feature. The DW guide illustrates partitioning only on DATe columns and there is no specific mention of this data type. create table testtbl (id (...)
13 March 2009
query to output result horizontally: I could not figure out a query to display the output below. I'm running 10g. Table record ============ GRP NAME XTRANS QUANTITY 1 AAA CX 10 1 AAA YP 20 1 BBB CX 100 1 BBB YP 200 2 AAA CX 80 2 AAA YP 81 2 BBB CX 90 2 BBB YP (...)
13 March 2009
Free Oracle Magazine Subscription: Qualify for Your Free Subscription Here...http:// ebooksick.tradepub.com/free/or m/ Published bimonthly and distributed to more than 550,000 of the top IT managers, database administrators, and developers. Oracle Magazine contains technology strategy articles, sample code, tips, (...)
13 March 2009
Urgent XML DOM question in Oracle: Hi I have a question when I use the xmldom in a procedure. I need to have the following information in my file from the procedure: <?xml version="1.0" encoding="ISO-8859-1" ?> <?POSTNET SND="XXXXX001" REC="XXXX0001" (...)
12 March 2009
can you take a schema offline?: i have a couple of schemas i suspect are not used any longer but am not sure. is there a way i can make them inaccessible before actually dropping them? or do i basically have no option other than drop them? I thought i might be able to take the tablespace where its objects are in (...)
12 March 2009
Problems about RAC/Multiple database: Dear group, we have a RAC environment which has several databases on it. Recently one of our database is consuming too much CPU, and it eventually cause the the server to reboot because the miscount > crs expected. Is there any way i can manage the CPU usage at database level? Say (...)
12 March 2009
NCS US, Inc is seeking a challenging candidate for a Sr Recruiter Position.: Dear Recruiters, NCS US, Inc is seeking a challenging candidate for a Sr Recruiter Position. Please read the job description below & send across your word doc resumes to p...@ncsus.net Experience:2+ Years Location: Hyderabad / Secunderabad Compensation: Best of Industry (...)
12 March 2009
query across 3 Oracle DBs and MS-SQL: Hello Guys, I will shortly be tasked with running some complex queries across 3 X Oracle DBs and MS-SQL. Each of these db has millions of lines. I have run queries again a single Oracle DB with millions of lines with some success - that take several hours to complete. However I have (...)
12 March 2009
11g create spfile from memory ... implications and potential problems: Looks like if you try a create spfile from memory ( running 11.1.0.7.0 64 bit on OEL 5.1 ) or a pfile from memory you get all the undocumented underscore parameters now put in permanently into your new spfile or pfile. ( Things like _globalindex_pnum_filter_enabl ed=TRUE etc ). Looks (...)
11 March 2009
Migrate from Oracle 9i to 10g on new Hardware: We currently have Oracle 9i setup for our production environment. We would like to install 10g on new hardware and bring in the data from our 9i setup. Most of the documentation refers to either upgrading in place or just fresh installs. Can anyone point me in the right (...)
11 March 2009
Accessing sqlserver database from oracle using heterogenous services: oracle 10.2.0.4 / sqlserver 2000 I have set up a database link within oracle pointing to a data source (odbc) which points to a sqlserver instance and a default database I can get the following command to work select count(*) from brokers@rdt ...which reads data from the default (...)
11 March 2009
recommended way of exporting/importing big data sets: What is the recommended method to export and later import big tables (1-5 Mio rows with ca. 50 columns)? database oracle 10gR2 Goal, Copy some big tables from remote DB1 (no filesystem access, no DBA role, etc.) to locally managed DB2 (full access). I checked datapump but it requires (...)
11 March 2009
How to convert "Thu Nov 17 06:44:23 CST 2005" to date ?: Hi, How to convert "Thu Nov 17 06:44:23 CST 2005" to date ? This works : select to_date('Thu Nov 17 06:44:23 2005','Dy Mon DD hh24:mi:ss yyyy') from dual; But when timezone is added in between, it doesn't. Thanx (...)
10 March 2009
timezone conversions?: hello group, What's the easiest/preferred way to programmatically convert a timestamp value from one timezone to another? (i.e. subtract/add the necessary number of hours). I checked the documentation but unfortunately missed any one function to switch timezones. thanks, (...)
10 March 2009
Live Sex >>>>>>>>>>>>>>>>>Click Now <<<<<<<<<<<<<< Earn Money Online: Free Live Sex Web Cams & Chat Click here for free live sex web cams Chat for free *!*!*!*!*!*!* [link] *!*!*!*!*!*!* [A]^^^^^ [link] ] [B]^^^^^^^ [link] ] [C]^^^^^^^^^^^ [link] ] [D]^^^^^^^^^^^^^^^ [link] ]
10 March 2009
Is Oracle faster/easier than mySQL: I am deciding on a database sw for a future startup. Which one is better? Also what would it cost for Oracle? Is this subscription or one time pay?
9 March 2009
Re: DR Options.: Assuming each database generates 1GB of redo per day (AWR can generate a good bit), you should be able to copy the archived redo logs to the remote data centre and script an apply process for them. That assumes you can sustain 512K per second of throughput for about 40GB per day if you (...)
9 March 2009
sql query not use index: Hello Guys, I was asked yesterday a project manager what sort of query will not use an index? What sort of index ? I asked say a varchar(256) ? A badly written regex. I responded. OK thanks. Now I am worried I have given a misleading or wrong response! Can anyone help me out (...)
9 March 2009
Mviews Refresh Timings: Hi All, We have production box on 10g R2 on Linux system. One Mview refresh job which refreshes bunch of mviews takes normally 10 hours. It is 3 TB database. But sometime this jobs take 15 hours or more. I agree that this should look from performance tuning prospective but at this (...)
8 March 2009
Any tools/scripts for finding underlying cause of concurrency?: We have been having concurrency issues for the past week but have managed to resolve it (the underlying cause of it was a bug). One thing that I wanted to know is that if there are any tools or scripts out there to tell us immediately the cause of the concurrency? All we saw in OEM was (...)
8 March 2009
ORA-04030, create text index error: ORA-04030, create text index error SQL> create index t1_idx on t1(IS_ACCESS_BY) 2 indextype is ctxsys.context 3 parameters( 'datastore foo_user_datastore lexer my_lexer'); create index t1_idx on t1(IS_ACCESS_BY) indextype is ctxsys.context parameters( 'datastore (...)
8 March 2009
SQL Question - Adding rows to the resultset: I am try to solve a migration problem in sql. Test scripts below if someone would like to try and give me a hand. The issue, how to carry over the result of the previous row to the next (well, not lag or lead exactly). In this example below, a particular transaction has a set of (...)
8 March 2009
Question - Laptop shutdown: Hi, I would like to know what went wrong. I have 2002-2008 worth of data and using MS Access 2002 to link oracle where the data keep in. Everytime, I run the queries and it take a well to get the result but it shut down the laptop. Do you know what cause this ? Your feeback would be (...)
7 March 2009
index block cleanout: Hi All, I have one question about index block cleanout. When I use two commands to cleanout index block. But it does not work at all. ALTER SESSION SET EVENTS 'immediate trace name flush_cache'; alter system flush buffer_cache; Below are my test case 1. create table (...)
7 March 2009
Number 8 on the list ... just like the Spartans!: Moving on up ... to the East side ... to a deluxe apartment ... in the skyyyyyy! See ya HJR and watch out connor! Joel G ... you got some breathing space for now! ( Kidding mostly ... )
7 March 2009
Top SQLs from Statspack Vs SQLs from v$session_lonops: Hi All I'm trying to understand the difference vs TOP SQL statement from Statspack report vs. SQLs shown by v$session_longops. Suppose, I took Statspack report between 12:00 hr to 12:15 hrs. and during the same time i qurried the v$session_longops then is it most likely that all (...)
6 March 2009
TimesTen and In Memory Databases.....: All, I have been assigned to evaluate the TimesTen in memory database software. Please note I am not a DBA but I do have quite a bit of systems knowledge. From what I have seen I have not been that impressed based on the price point and some of the issues I have read about. Such (...)
5 March 2009
Oracle creates multiple shared memory segments despite SGA < SHMMAX: This is new installation of 10.2.0.4 on HP-UX 11.23 Itanium. HP-UX kernel parameter SHMMAX is 10G, Oracle parameter SGA_MAX_SIZE set to 8G. On startup Oracle creates 4 shared memory segments, size in bytes: 4064346112 4076863488 488710144 20480 Any idea why? Yes I know that it (...)
5 March 2009
help: Restore database to a different disk group: Dear group, I need to restore a RMAN backup to a different server, with different diskgroup name After i shipped all the RMAN backups to the new server, i need to do run set newname for datafile 1 to '+NEWDISKG'; set newname for datafile 2 to '+NEWDISKG'; set (...)
5 March 2009
aggregation in columns: Hi, I have a table named ReportData which reportes activity for a small but dynamic number of components there are 2 columns: componentId and timeMeasurement I want to defin a query which counts all the reports per each component per year I can do the following query select (...)
5 March 2009
Ouch...: [link]
5 March 2009
Creating Oracle Text Indexes: Hi this is on 10gR2 - we have a table with around 240,000 documents (word, pdf, html). We have a text index created on it using the following settings (generated by executing the procedure): ------------------------------ --------------------------- create or replace procedure (...)
5 March 2009
Problem with x64 Oracle OLE DB Provider, MS ADO, server side forward cursor: With 64 bit Oracle 10 or 11 client, using MS ADO with a server side forward only cursor to run a simple query against a single table, the result Recordset does not contain all rows. In fact the number of records I can see is equal to the Recordset.CacheSize. It works as expected when (...)
4 March 2009
Licensing Question: I just want to know if this is something I can bring up during a budget meeting later this week. If we have two servers. One will be production and the other strictly development/testing but only one license for Enterprise Edition is it possible to have Enterprise Edition on the (...)
4 March 2009
EMN0 process memory leak.: Hi All, Oracle 9.2.0.8, running on Solaris 9 64 bit We use advanced queuing to trickle (800 per minute) real time transactions into a datamart. This has been live for a month and is working great. Apart from the fact we have noticed that the EMN0 process is now at 1.8g. This is a 24x7 (...)
4 March 2009
Hot backup: Hi Can someone guide me on what are the components of a hotbackup and how to restore a hot backup. I have tried it , but always i had to use 'until cancel' option while recovering the database. How can i avoid this. (...)
4 March 2009
List of files outside of Oracle home: Oracle database 10g on Red Hat AS 4.0. I'm looking for a list of files that Oracle installs outside of the Oracle home. I have: - /etc/oratab - /etc/oraInst.loc - /usr/local/bin/coraenv - /usr/local/bin/oraenv - /usr/local/bin/dbhome Any others ? (...)
4 March 2009
Ora-12514: Hi! My Windows base Oracle server has 2 Oracle instances. However, when I connect to one of instance by sqlplus, Ora-12514 occurs! How can I do? I have tried the following methods 1. set oracle_sid=XXXX 2. sqlplus /nolog | connect sys@XXX as sysdba 3. add names.directory_path = (...)
4 March 2009
Another Newbie Question: How to restore data .bkp w/o info on orig. db settings?: First, I apologize for the dumb question. We are not Oracle Gurus, but are given a dataset we need to examine before passing along. In the past they gave us exp files and we figured out a way to get into them by adding all the usernames it asked for and then using the imp command to (...)
3 March 2009
Dataguard: recovering from network outage: Greetings from snowy New York, NY USA! I'm running Oracle 9i on AIX 5.2. I usually use FAL to resolve missing archived redo logs on the standby database, but following an extended network outage, I compressed and moved the archived redo logs by "hand" to the standy (...)
3 March 2009
welcome to my pc world: Software has not passed windows logo testing to verify it's compatibility with windows XP @@@@@@@@@@@@@@@@@@@@@ §§§§§§§§§§§§§§§§§§§§§§§ [link] §§§§§§§§§§§§§§§§§§§§§§§ @@@@@@@@@@@@@@@@@@@@@
3 March 2009
Cartesian join: Hi everyone, I Hope can explain well my issue, i have 2 tables, 1 of them has a column which contains a phone number and other column which means the name of a client, the other table has 2 columns which means a range of phone numbers (init range and end range) so i want to get the (...)
2 March 2009
Only $30 to get a Oracle certification: Only $30 to get a Oracle certification Latest Oracle Pass4Sure Dumps Only $30 to pass your Oracle certification exam for sure. [link] Pass4Sure.co.in is the leader in supplying certification candidates with current and up-to-date training materials for Oracle Certification and Exam (...)
2 March 2009
Latest Oracle Pass4Sure Dumps: Latest Oracle Pass4Sure Dumps Only $30 to pass your Oracle certification exam for sure. [link] Pass4Sure.co.in is the leader in supplying certification candidates with current and up-to-date training materials for Oracle Certification and Exam preparation. Our Oracle resources (...)
2 March 2009
Join with a global temp table: Hello, I want to join a global temp table (delete on commit, not more than 250.000 records) with a normal table (about 100 mio records). To speed up the join - would it be better to create a primary key on the join column of the temp table? My tests show that it seems not to affect (...)
1 March 2009
oracle 9 export all without 1 table: Hello! I have user name : joe He have 4000 tables. Id like to know if it is possible to export all tables without only one table. Or export all and import all without only one or delete from export dmp file certin table? Need help regard : (...)
28 February 2009
Taking export from SECONDARY_INSTANCE from 02 node RAC: Hi All We are at : Oracle 9.2.0.6 HP Ux : 11.23 RAC : 02 Node ( say node-A & node-B) Primary Instance is running in node-A & secondary instance running in node-B. All db connections goes to PRIMARY_INSTANCE , we control it via TNS. Hence at a given time (...)
26 February 2009
Triggers: Hi, We are making some changes and I'd like to know if this can be done with a trigger. I have Table1 which is the master table and Table2 which is the history table. Currently we have over 100 places where Table1 is inserted to and deleted from. After that Table2 is dealt with. (...)
26 February 2009
display table row into column: Hi All I have : SQL> create table t1( col1 varchar2(10), col2 varchar2(10),col3 varchar2(10)); Table created. SQL> SQL> insert into t1(col1,col2,col3) values ('A','B','C'); 1 row created. SQL> insert into t1(col1,col2,col3) values (...)
26 February 2009
Tracing time spent on the network: Hello, Sorry i am a n00b :) I have a java application connecting to 10g. My queries appear slow and I believe the network is the issue. I am trying to prove my network admin that most of my time is spent on the network. Is there a trace facility in the jdbc driver that would show me (...)
25 February 2009
Accelerating sp, again!!!: Hi people, this is a continuation of the post titled "ACCELERATING STORED PROCEDURE" from the last week, am sorry for the inconvenience that might cause them to have to read the previous post but its a long history as you can see, so the last post was very useful and thanks (...)
24 February 2009
How do you move archivelogs from one asm to another asm on standby site?: Dear group, Somehow my archivelog is in the primary site ASM disk, but failed to shipped to standby site. If I do SQL>alter database recover managed standby database finish * ERROR at line 1: ORA-00283: recovery session canceled due to errors ORA-16171: RECOVER...FINISH not (...)
23 February 2009
trailing white spaces in datafile names (Linux): Did anyone ever have to fix an 'error' like that? They can easily be renamed in Oracle, but what to do on the OS? Thanks ....... We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc) We use RMAN and remote catalog for (...)
23 February 2009
Oracle 10g backup/restore: Is there any official documentation available for Oracle backup/ restore from Oracle? Please let me know the link if it is available. Thanks in advance.
23 February 2009
OCILogon using Secure External Password Store parameters: I'm using Oracle 10g Release 2 on IBM AIX. sqlplus /@PPRD works fine with Secure External Password Store where PPRD is a TNS Alias It's not working for my OCI program. Code for OCI rc = OCILogon(p_env, p_err, &p_svc, "/@PPRD", 6, "", 0, "", (...)
21 February 2009
Max. size of Oracle data file: Anyone know the max. size of Oracle data file in Windows Server with NTFS? 32G? or depends on block size of instance? Ming
20 February 2009
Re-design of data storage table: Hi, I have been tasked with redesigning the way that our application data is stored in the database. I have come up with the way I think it should be done but I wanted to see how others would handle the same problem. We have to do this on SQL Server (and Oracle). I cannot use our (...)
20 February 2009
Oracle databases on a server: I have Oracle installation on a SUN UNIX server. I tappears that it is running Oracle 10.2 and Solaris 8. I want to find out how many databases are installed on this server. Would it be true to say that all databases installed on this server are listed in tnsnames.ora where the (...)
20 February 2009
Cheap Cheap Database Recovery: Hi, Having a extremely low budget for IT, I tried to design a very cheap recovery database system without having to pay for a standby database. This is the idea: 1 -use a duplex destination for the archive logs located in a remote server (nfs mounted). 2-every 5 minutes a cron job (...)
20 February 2009
In-house beta: ALI Database Consultants sells a set of tools for Rdb (currently sold via Oracle, originally developed by DEC). Since Oracle took over Rdb, more and more "Rdb'isms" have been showing up in standard Oracle. Consequently, we are currently working on a port of the Rdb tools (...)
19 February 2009
Another rotten query: I can do this, probably the long way with PLSQL code. I was just seeing if someone knew of a better way. Here is our query: v_select := 'SELECT my_left_table.fund_name, my_left_table.ticker, DECODE(fund_rank.curr_rank,NUL L,'NA',fund_rank.curr_rank) AS fund_rank, (...)
19 February 2009
ACCELERATING STORE PROCEDURE: Hi everyone, Hoping you are ok, i need your help to solve this query in order to make faster an stored procedure, it goes likes this: Tables Sources -> SP procesing some data -> Tables Destiny (Results) So my source's tables are OM_DB.CDRS (86 fields and 30,000 rows average) (...)
19 February 2009
oms problems: aix 5.3 64bit EM Repository DB 10.1.0.4 OEM 10g R3 Grid Control Other than Doc id # 283327.1, which I'm not being affected by, does anyone know why trying to start oms via a Putty connection to the server would work on from the PC you used to install it and not another? The (...)
19 February 2009
How to determine oracle user size?: Hi Any SQL statement can find the Oracle user/owner size when more than one user in a Oracle instance? Thx! Ming
19 February 2009
SRDF/A failover.: Hi All We have site -A (Live) and site-B (Disaster Recovery). Database is replicated to site-B using EMC SRDF/A links. We use Veritas global cluster manager to monitor/control the failover. Global failover is set to manual not automatic. i.e. Manually DNS entries has to be updated. so (...)
19 February 2009
DataGuard vs Hardware mirroring for DR: Dear Group, We are planning for DR site. We have two options, one is DataGuard, another is using Hardware SAN mirroring. Is there any pros and cons in terms of this two methods? Your help is highly appreciated.
18 February 2009
how to see the complete description of table in oracle: hi, i want to see the complete description of table with it's structure and constraints. I also want to see the column name on which the constraints are applied.
18 February 2009
restore database from an old incarnation: Hi, We are using rman and a 3rd party vendor backing up to tape directly. We used Oracle 10g2 on windows 2003 server with a catalog database on another database. I need to restore and recover a database from a previous incarnation to a different server. (NOT the original production). (...)
18 February 2009
Getting "ORA-29024: Certificate validation failure", when using UTL_HTTP to POST to Google Checkout URL: Hello there, I'm running Oracle 10g Release2, XE Edition. I'm trying to use the UTL_HTTP Package to submit a POST request to the Google Checkout Test Server. Now, if I run my script to try to send a POST request to [link], it works, i.e. DECLARE l_url VARCHAR2(200) := (...)
17 February 2009
value prediction: I'm using Oracle 10g. Are there any analytic/statistic functions in Oracle to predict future values based on existing historical data ? For example: I have a table with product sales of the last 5 years, can we make an estimation of the sales for the next year ? Thanks, (...)
17 February 2009
understanding NOT IN / IN: Following situation: create table a (org_id number, org_name varchar2(1)); insert into a values(1,'a'); insert into a values(2,'b'); insert into a values(3,'c'); create table b (name varchar2(1)); insert into b values('a'); insert into b (...)
17 February 2009
Is this query done easier?: We have this query: SELECT ticker, category_name, fund_name, class_rank, total_return_1yr, expense_ratio, market_value_avg, mgr_start_date FROM (SELECT pr.ticker, pr.category_name, mf.fund_name, fc.class_rank, pr.total_return_1yr, fm.expense_ratio, market_value_avg, mgr_start_date, (...)
17 February 2009
What tools do you use for healthchecking?: Hi, For the earlymorning check, I am working with self made scripts here that run overnight and check for things like space in the database, security, backup ran ok, duplicates to testenvironments, errorlogchecking etc. These scripts are a bit... wel... 20th century.. I am looking for (...)
17 February 2009
Hogan shoes (paypal payment)(www.king-trade.cn ): Footwear (paypal payment)([link] ) Paul Smith shoes Jordan shoes Bape shoes Chanel shoes (paypal payment)([link] ) D&G shoes Dior shoes ED hardy shoes Evisu shoes Fendi shoes (paypal payment)([link] ) Gucci shoes Hogan shoes (paypal payment)([link] ) Lv (...)
17 February 2009
NIKE AIR JORDAN FORCE FUSION SHOES AJF 5 V JORDANs 5 FUSION NIKE: shoes on AIR Jordan 1 (paypal payment)([link] ) AIR Jordan 2 AIR Jordan 3 AIR Jordan 4 AIR Jordan 5 (paypal payment)([link] ) AIR Jordan 6 Rings AIR Jordan 6 AIR Jordan 7 AIR Jordan 8 AIR Jordan 9 (paypal payment)([link] ) AIR Jordan 10 AIR Jordan 11 AIR Jordan 12 (...)
17 February 2009
Verify Outdated Optimizer Stats: Hi All, I hope every one would have come across that users complaining about the response of database.Usually the first thought comes to the DBA is to Gather Stats and verify the performance.Performance will be far better after collecting stats and this is expected behavior. Before (...)
17 February 2009
|☻|) Sexy Free Tits and Ass ;: + Watch [link] movies for free with imival the totally free sex video client.+
16 February 2009
Design question: Hello group, Oracle version is 10g. 11g might be possible too. I'm currently involved with the pre-analysis of a new project I'll be working on. We will get historical environmental data (temperature, rainfall, ...) for about 70.000 different locations, and this for a period (...)
16 February 2009
Cross Reference Table Design and Query: Hi all, I have a cross-reference table which stores student class enrollment info: Table Name: ENROLLMENT_XREF XREFID STUDENT CLASS ------ ------- ----- 1 MARY MATH 2 MARY SCIENCE 3 MARY COOKERY 4 JIM MATH 5 JIM AUTO-REPAIR 6 JIM (...)
16 February 2009
Which SQL is the best for servers?: I am involved with a SQL server project. The server would be used in a very heavy duty environment, with hundreds of thousands, if not millions of database enquiries per minutes. The server would run Linux or one of the BSD variant, with at least 32GB of RAM. We are not very certain of (...)
16 February 2009
certified linux versions to use with oracle 9.2.0.4: hi, i've just wasted some of my life trying to install oracle 9.2.0.4 on RH9 only to find its not certified by linux - it did not work. this begs the question on my part as to what the certified linux version(s) are and where i can find this informaiton? any ideas? ta, (...)
15 February 2009
* Hot Teen Boobs Videos: Amazing [link] all these barely legal babes burn it up fast with their gyrating mammoth mounds of sensuous sands of titalating termultuous tazering taps of turbulent tasles, Enjoy
15 February 2009
Aggregate query: Hi, I have to aggregate some data between fact table (20Mrows) and dim tables (8Krows) but the query failed due to huge TEMP space needed (10.2.0.4) how can I execute this query ? SELECT ( ("FAI_XPO_VNTUGA"."NUMMOIS" || "DMS_OLTP_HIE_UGA || (...)
14 February 2009
Online redef - is there a better way?: We have a requirement to move some of the table from normal to partitioned. I tested the oracle provided online redef way by simulating select+dml load on the table. I tried using exec DBMS_REDEFINITION.START_REDEF_ TABLE ('OWNER1','SOURCE1','SOURCE1_T EMP$') (...)
14 February 2009
* Take it like a man live screen shots: Get stuffed wow [link] its unbelievable live screen footage of a professor of lots of little things society of the mentally gifted.
14 February 2009
restore using rman: Hi, I don't know if following is possible: 1. restore all datafiles from a rman backup 2. restore to the SAME server but to a different location 3. during the restore, the existing production database is up and open all the time The reason is because I got a request to restore a (...)
14 February 2009
Rman catalog: Have patched database on windows 2003 to 10.2.0.4 with jan cpu There is an RMAN catalog on this database / remote jobs on other servers still work When i try and connect to catalog using connect catalog rman/ rman@repos I get the following:- connected to recovery catalog database (...)
13 February 2009
RMAN restore to lower point release/different OS?: This is probably going to sound like a very weird thing to do, but please bear with me for a minute: I have an Oracle 10.2.0.4 database running on RedHat Linux on an HP Itanium server. I'm playing around with the possibility of copying the database to a VMS 8.3 Alphaserver (for (...)
12 February 2009
Parallel hint: Hi, I have table with parallel degree 4. I altered the table with parallel degree 8. But the insert query of that table didnt take the parallel process of 8, though i forced the parallel hint with 8. Instead it is taking parallel degree 4. Note 1 : i also used alter session (...)
12 February 2009
Will Oracle ever follow its own advice?: 11:05:39 oracle@wcasbuild01 ~ >sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 12 12:30:28 2009 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the (...)
12 February 2009
Regular expression problem: I'm using Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production With the Partitioning option JServer Release 9.2.0.7.0 - Production. I'm in trouble using owa_pattern Oracle standard package. Trying the following block: begin if owa_pattern.match( (...)
12 February 2009
Intermittent java.sql.SQLException: ORA-00902: invalid datatype: Hi, We are getting java.sql.SQLException: ORA-00902: invalid datatype exception intermittently while saving the data in db using java, most of the times it is working for the same data elements, We are using Oracle SQL types to save the data in Oracle9i database! Please give some (...)
12 February 2009
dbca - configure db options - checkboxes disabled: Hi, this must be easy ... When starting dbca and trying to 'Configure database options' I find all those checkboxes disabled ..? Why this happens ? (db is 10.2 running on linux) BR, Timo
12 February 2009
New to Oracle ---> Where to Start? Options: [link]
12 February 2009
* Obama's wife Naked: Get it [link] - Photos of Obamas wife naked! We will keep this our little secret amazing! archive of private movies and all kinds of sexual positions. You must see her with her batman utility belt its quite the movie. A must watch. Voted for change and thats all I got (...)
11 February 2009
DBCA doesn't create new database (Oracle 11g): Hello, When I try to create a new database with the DBCA (Database Configuration Assistant), I am able to choose all the configurations for my new database. However, at the end of the process, when I click "OK" in order for the DBCA to create the database, nothing happens. (...)
11 February 2009
disks for redo logs: Hi, I've got two database - rac and single - and two RAID groups - 4 disks in RAID 10 and two disks in RAID 1 on storage array. At this time I'm using RAID 10 for RAC database redo and RAID 1 for single instance database redo. RAC is producing about 100% percent more redo then (...)
11 February 2009
How to do this query without blocking each other ?: Hi Gurus, I have a table like below to implement Seat stock taking : (the table below is simplified form, just to explain the requirement ) CREATE TABLE SEAT_STOCK ( ROOM_ID NUMBER(12) PRIMARY KEY, ROOM_NO VARCHAR2(5 CHAR) NOT NULL, -- room number SEAT_NO VARCHAR2(1 CHAR) NOT (...)
11 February 2009
Pressure Test tools for oracle database: hi, we plan to do some pressure test on Oracle 10g database againt our environment. Would anybody do some favor to recommend pressure test tools for oracle database ? Joe
11 February 2009
earn more money: Do you want reach your dreams Do you want improve your economic range Do you want to make more money from home very easy click here [link] ****************************** ****************************** ****
11 February 2009
ORACLE / FINANCIALS DBA - 6/12 MONTH CONTRACT IN NY CITY: Note: We want someone that is very technical, lots of application DBA experience particular to e-business but also a manager at present, not just a project leader. So someone that been a DBA customizing EBS and then became a manager and has been in that role for the past 6-12 months. (...)
10 February 2009
ORA-01861: literal does not match format string: Hi All Our aplication is throwing the following error : Oracle access failed. ORA-01861: literal does not match format string . SQL Stmt : We have java based application. and Oracle 9.2.0.6 Oracle recommends to use : to_date to_char to_number to avoid such errors. (...)
10 February 2009
[OT]: How to access this group via NNTP: Hello List, I wonder if any of you access this list over NNTP? I checked in Gmane but it seems this group is not aggregated there. My ISP does not run usenet service. :-/ Any leads/suggestions would be much appreciated. (...)
10 February 2009
Handling Multi User Stock Taking: Hi sql gurus, We have a system to handle seat inventory stock taking in a marine cruise. All seats in all rooms are maintained in a table. below is the simplified structure of the table : CREATE TABLE SEAT_STOCK ( ROOM_ID NUMBER(12) PRIMARY KEY, ROOM_NO VARCHAR2(5 CHAR) NOT NULL, (...)
10 February 2009
||&|| Hot chicks getting stuffed free downloads: Download [link] - these images and ladies taking it deep inside.
9 February 2009
Re: The Query From Hell: Mtek schreef: As far as I can see (apart from the size of this query) there is only one small error in it (apart from some lingual errors), but I'm sure you have found that one already! Looks like they tried to put a complete spreadsheet in one query! (...)
9 February 2009
ORA-1727 - where does the error go?: 10.2.0.4, hp-ux 11.23 I have a slightly odd script that does an alter database backup controlfile to '$OBACKUP/backupcontrolfile.ct l' Of course, I had forgotten to export the OBACKUP, since, well, there is an alter to trace which happens to work ok, and everything else works (...)
9 February 2009
rman restore from consistent backup: SUN SOLARIS 10 Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production Could someone help me please. We are starting to use RMAN. We have a test database running in noarchivelog mode. We took a consistent backup (mount) on Feb 5 20:55 (backup as compressed (...)
9 February 2009
Streams example: I am trying to get an understanding of Streams. I worked through the "single-databse capture and apply example" in the 10.2 Streams Concept and Administration guide. I was able to get it to work. I am implementing a similar process for one of our tables. I am a little confused (...)
9 February 2009
Fairy Tales: ****************************** ****************************** ******* ~~~Fairy Tales~~~ ****************************** ****************************** ******* ENTER HERE >>> [link] <<< ENTER HERE
9 February 2009
Free Singles: ****************************** ****************************** ******* ~~~Free Singles~~~ ****************************** ****************************** ******* ENTER HERE >>> [link] <<< ENTER HERE
9 February 2009
Comfort Suites: ****************************** ****************************** ******* ~~~Comfort Suites~~~ ****************************** ****************************** ******* ENTER HERE >>> [link] <<< ENTER HERE
9 February 2009
Patio Furniture: ****************************** ****************************** ******* ~~~Patio Furniture~~~ ****************************** ****************************** ******* ENTER HERE >>> [link] <<< ENTER HERE
9 February 2009
Rascal Flatts: ****************************** ****************************** ******* ~~~Rascal Flatts~~~ ****************************** ****************************** ******* ENTER HERE >>> [link] <<< ENTER HERE
9 February 2009
recovering a subset database: I have problem creating a subset of a 10g database including the SYSTEM tablespace on the same server as the source database. On source database, I have the following tablespaces: system, undots, users, sysaux, data1, data2 On the new subset database, I want only the following (...)
9 February 2009
grant execute on package by DBA: I would like to find out if there is a possibility (as a non-DBA user) to list all objects (owned by that user) including the grants done by DBA on these objects. I have a package called chrispack. Whenever I want to expose a procedure or function from within that package I create (...)
9 February 2009
Hi all: Hi , myself new to your group. Hope for an effective visit regularly . Working as an oracle dba . thanks ershad, [link]
9 February 2009
Creating a Table of a Type which contains a nested table: Oracle 10.2.0.3 Windows Server 2003 Example 1 with VARRAY: CREATE OR REPLACE TYPE t_test AS OBJECT ( field1 VARCHAR2(10), array1 t_array_va, array2 t_array_va ); CREATE OR REPLACE TYPE t_test_tab AS TABLE OF t_test; / Example 2 with NESTED TABLES: CREATE OR REPLACE TYPE (...)
8 February 2009
* Huge Tits Movies Images Archive75v6-7: Get it [link] for free and download all the movies and images for free and for promotion cometh neither from the east, nor from the west, nor from the south. But God is the judge: he puteth down one, and setteth up another.
8 February 2009
Net Configuration Assistant problem: On several onsite computers all running Windows XP Pro, the 10g Net Config Assistant hangs for at least an hour when I select local net service name configuration. Any ideas on why it is hanging? Thanks, Greg
6 February 2009
HP and Oracle Team.The alliance of the Kings.: Hardware leader HP and software king Oracle has created a new technological; terror something big and massive. [link]
6 February 2009
Why Oracle is not adding a second to date/time:: I am using Oracle 10.2 on HP UNIX 11i I have table lasttime with a column runtime (of type date)./ select * from lasttime; 02/04/2009 22:35:38 I want to add one second to runtime. I am unable to do it using following statement: Update lasttime set runtime = (...)
5 February 2009
Permsssions to create sql profiles: I am using Oracle 10.1 and 10.2 on Windows 2003 and HP UNIX 11i platforms. When I need to create sql profiles, it works if I login with dba privileges. However, for some databases I do not have dba privileges. What are minimum privileges required. I read somewhere to be given advisor (...)
5 February 2009
error with dblink.: I need to access a oracle serveur in 8.0.6 from a client 10g. As I got the error "ORA-03134: Connections to this server version are no longer supported." someone told me to create a dblink on a 8.1.7 server. (in fact I had tested that from the client 10g to 8.1.7 it was ok and (...)
5 February 2009
SGA: I'm looking for a book that is dedicated to the SGA. Explaining how the different parts work together, how changing a parameter affects the different parts fo the SGA and the performance. PGA, Buffer Cache, etc........ Already know how to program. Do not need a PLSQL review. Just (...)
5 February 2009
ORA-06502: Hi, I have the follwing error with the query below: OK for 01/01/2008 and 15/07/2008 OK for 01/08/2008 and 30/09/2008 ORA-06502 with other values Thanks for your help (9.2.0.6) ------------------------------ ------------------------------ ------------------------------ ------ (...)
4 February 2009
Instance down due to ORA-00476: Hi database instance went down with the below mentioned error. Wed Feb 4 15:26:30 2009 Errors in file /abc/<inst>_pmon_10200.trc: ORA-00476: RECO process terminated with error Wed Feb 4 15:26:30 2009 PMON: terminating instance due to error 476 Wed Feb 4 15:26:30 2009 (...)
4 February 2009
Why can't an RMAN job be edited in 10G dbcontrol?: I set up a nightly backup job on a new database I just moved over to a Windows 2008 server, and I was sure I told it to keep 3 days worth of backups then delete obsolete backups. The problem is that it is not deleting the older backups, I have to do it manually, and I can't get into (...)
4 February 2009
& 1 Samuel 25v42: And Abigail hasted, [link] and arose, and rode upon an ass, with five damsels of hers that went after her; and she went after the messengers of David, and became his wife. Please TURN! to page 288 of your king james green covered bible printed with one page printed in korea with me and (...)
4 February 2009
New to Oracle and have Backup Question..: I'm new to Oracle and have a question for someone that I started trying to help out. They are using Oracle for a DB server and currently don't backup anything nightly or weekly. I'm sure there is a way to set Oracle up to Backup nightly to a file on the hard drive somewhere (...)
3 February 2009
Embedded Software Developer Needed: Hi Please see below the requirement and let me know if you have any one for this. [link]
3 February 2009
REK:SFA Data Analyst at South San Francisco, CA: Hi, Warm Greetings!!! Please send the suitable resume to pr...@jivainfotech.com We are currently searching for a SFA Data Analyst for our client in South San Francisco, CA. SFA Data Analyst South San Francisco, CA Duration: 5 weeks Requirements: The ideal candidate must be (...)
3 February 2009
Rek:Web Developer at Phoenix, AZ.: Hi, Warm Greetings!!! Please send the suitable resume to pr...@jivainfotech.com We are currently searching for a Web Developer for our client in Phoenix, AZ. Web Developer Phoenix, AZ Duration: 5 months + Requirements: Looking for a senior Java Developer with following skills (...)
3 February 2009
Rek:Business Systems Consultant at Columbia, MD: Hi, Warm Greetings!!! Please send the suitable resume to pr...@jivainfotech.com We are currently searching for a Business Systems Consultant for our client in Columbia, MD Business Systems Consultant Columbia, MD Duration: 6 months Requirements: Requirements: Senior level (...)
3 February 2009
Re: Mistä edulliset hyllyt verkkokellariin: Energiamurros [Tomi Savolainen, 06.05.2008] Pekkarinen kuittaisi uusiutuville jo kesällä miljoonatuet Investoijilla on satojen miljoonien eurojen valmiit suunnitelmat, Pekkarinen laskee. Hänen mukaansa niiden käynnistämiseen tarvittaisiin vähintään 40 miljoonan euron tuet. » Aiemmin (...)
3 February 2009
Integrity constraint: Hi, I have a developer who has written the following code to delete some records: DELETE FROM x WHERE id NOT IN (SELECT id FROM y) AND id NOT IN (SELECT id FROM z); ORA-02292: integrity constraint (Y_FK) violated - child record found When there is already a clause in my delete (...)
3 February 2009
++ Hilary Clinton Sex Scandal,: Free Download [link] - The video that rocked the oval oralfis , Hilary Clinton Sex tape naked with The hockey legend Wade Greatski.,
3 February 2009
asm and multiple databases: Hi, I've got two database on different servers which have the same name - ORCL Then, I've got clustered ASM with one disk group which is available on this servers. I know that ASM naming standard is "+diskgroup_name/DATABASE_NAME /database file (...)
3 February 2009
How to create pl/sql that run efficiently in background ?: Hi sql gurus, We have application on Oracle 10g where 150+users (from multiple branch) concurrently input transaction. The transaction number is centralized, means all user use same transaction number counter. To avoid the contention that occured, we think of using pl/sql procedure (...)
3 February 2009
Re: Cognos Consultant at Detroit,MI: Will you PLEASE stop posting jobs on comp.databases.oracle.server. This violates the group charter, and alienates the people you are trying to recruit! Please remove your posts and apologize, so other recruiters don't pile on. This is sent from a bogus account, please apologize (...)
2 February 2009
REK:Technical Architect at PHILADELPHIA, PA: Hi, We are currently searching for a Technical Architect for our client in PHILADELPHIA, PA. Technical Architect PHILADELPHIA, PA Duration: 3 months Requirements: The ideal candidate must possess knowledge of internet/intranet based technologies and architectures. Ability to (...)
2 February 2009
REK:Application Systems Engineer at San Francisco, CA: Hi, Warm Greetings!!! Please send the suitable resume to pr...@jivainfotech.com We are currently searching for a Application Systems Engineer for our client in San Francisco, CA. Application Systems Engineer San Francisco, CA Duration: 6 months+ Requirements: The ideal (...)
2 February 2009
Web Developer at San Francisco, CA: Hi, Warm Greetings!!! Please send the suitable resume to pr...@jivainfotech.com We are currently searching for a Web Developer for our client in San Francisco, CA Web Developer San Francisco, CA Duration: 1 year Requirements: The successful candidate: - 5+ years of J2EE and (...)
2 February 2009
Re: REK:Business Systems Consultant at Phoenix, AZ.: Plonk
2 February 2009
~ Baby Spice Naked Photo Shoot: Nice [link] - Baby spice nude photos as well as Britney and brooke hogan. And one said, Be content, I pray thee, and go with thy servants. And he answered, I will go.
2 February 2009
@@ Look @@@ Hidden Spy Cams Britney Spears: Get it [link] Live Hidden spy cams with britney spears , brooke hogan, and baby spice. Can and be profitable unto God, as he that is wise may be profitable unto himself?
2 February 2009
Low cardinality,high concurrent in OLTP, how to improve query performance?: Hi sql gurus, In our racle DB 10g application we have a table that is INSERTED highly concurrently in OLTP application (but are NEVER UPDATED, Insert Only). There is a column : IS_PROCESSED VARCHAR2(1) , values is : 'Y' or 'N' . The rows will grows by a mill rows in (...)
31 January 2009
Multi Lingual Full Text Index rebuild consumes lot of memory: Hi All, We have a multi lingual full text index where in lexers for specific languages can be added any time depenedin upon the reuirement. So whenever there is a new lexer added we add the new lexer to the multi lexer and rebuild the index. During rebuilding the index, oracle is (...)
31 January 2009
computer database: more details visit links ****************************** *********** [link] ****************************** **********
31 January 2009
"direct path write" wait event: Snap Id Snap Time Sessions Curs/Sess Comment --------- ------------------ -------- --------- ------------------- Begin Snap: 58 31-Dec-08 09:18:02 ####### .0 End Snap: 59 31-Dec-08 09:31:19 ####### .0 Elapsed: 13.28 (...)
31 January 2009
sell jean$30,jordan shoe $32,handbag$35,top ugg boots$70(FREE SHIPPING )from WWW.IOFFERKICKS.COM: Get Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
31 January 2009
an honest post about being an oracle ace: Found this one [link] Very honestly it appears the author notes that he is a junior dba but has had oracle grant him this "credential" based on posting and promoting oracle ... Interesting eh?
31 January 2009
Db crashed with no backups :confused:: Hi all We've just had a scenario here; one of our dev db has just crashed due to unavoidable power failure. We've had no backup for this since the beginning. I could recover redo logfiles; I couldn't RECOVER datafiles though. I am trying out CREATE CONTROLFILE REUSE DATABASE (...)
30 January 2009
Why Does Query Require Table Access: Hi, I have a table t, partitioned by business_date, one partition per day. I have a locally partitioned index on this table on column c1. The following query performs as expected and accesses only one partition of the index, and doesn't touch the table at all (as expected): select (...)
30 January 2009
Anyone having any luck with Oracle docos online?: No otn links working, no tahiti, nothing. Must be that 'unbreakable' thing at work again...
30 January 2009
using db_file_name_convert for RMAN 32 to 64 bit conversion.: I'm a little confused about how this works, or if its just an option for what I want to do, which is, take a copy of a production database on windows 32 bit os and prepare it for windows x86 64 bit. Database is 10.2.0.4 So at RMAN prompt I put in: ------------------------------ (...)
29 January 2009
Spaces: Hi, no answer yet, but I've made some progress. Is there a way to tell REGEXP_INSTR to ignore spaces in my string? Sale I have this expression: SELECT REGEXP_INSTR('"FO EM, FO LA","ABCDEF","12345"','"()+, (+)"') FROM DUAL; (...)
29 January 2009
Welcome my to pc world: The new 48cms lcd monitor with f-Engine gives microscopic picture clarity and consumes only 22W power. Bed it to your pc and saving. @@@@@@@@@@@@@@@@@@@@@ §§§§§§§§§§§§§§§§§§§§§§§ [link] §§§§§§§§§§§§§§§§§§§§§§§ @@@@@@@@@@@@@@@@@@@@@
29 January 2009
Earn Online, Want to know how?: SOOO Don’t loose your time hurry to get the jobs. 1] Data Entry (Online / Offine) [link] Job in Microsoft Word. Textual data. Good package of page rate. Guaranteed payment. Flexible & unlimited job. 2] Medical Transcription [link] Choose a course which gives Weightage (...)
29 January 2009
* Ladies! Gay Videos Huge dongs Man on Man: Holla [link] - watch these amazing videos with man on man action full faCIAls , washroom games and inside paul deep collection.
29 January 2009
Multi-master replication: Hi there, I need to remove some "push" entries from replication queue, don't ask why. How could I locate entries concerning certain table and certain site. TIA C
29 January 2009
REGEXP thingy: Ok, I'm getting mad. I have a string like this: "FO EM, FO LA","ABCDEF","12345" I need a couple of regular expressions to do the following: 1: Let me know if I have a pattern of "something , something" like "FO EM, FO LA" 2: (...)
28 January 2009
What is in a pipe?: Hi all, I'm trying to work out how many messages are queued in a pipe and how long said messages are. Anyone got any ideas? So far, the best I can come up with is something silly like receiving DBMS_PIPE messages, unpacking them, counting and adding lengths and then repacking and (...)
28 January 2009
* Stephen Harper Sex Sex Scandalous Scandal: wow [link] - video recorded by monte' montevon , shot with davids gronkcapture Model24325 and Delay3000 dreamworks frustration camera resulting in total lossless photos.
28 January 2009
Discoverer EUL command line for java: Can someone tell me if the Discoverer EUL command line for java can be used on Discoverer Desktop? Thank you in advance for your help! Leo
28 January 2009
REGEXP_SUBSTR: I'm working on this now but figured I'd cheat at the same time and see if someone else can help. I have a text pattern: "M, MO" or "M,MO" or "HELO","M,MO" I am looking to extract the "M,MO" pattern. First I remove the space after (...)
28 January 2009
dbca error: Hello all, I've been playing around with an 11g DB. I installed it on OEL 5.2 (no updates / no subscription) and did a software only install. Then I patched it to 11.1.0.7.0. After that I wanted to create a starters database, so I fired up DBCA, selected a General Purpose database (...)
28 January 2009
## Rabbi caught on tape with 17 stripper hidden video: Right here [link] - Hidden video of Rabbi having sex with 17 year old stripper from conneticut
28 January 2009
Translate week number to date of the week.: All, Is there a quick way to convert week number ( of the year) to start date of that week? EX: If I pass week number as 1 then it should return 1/1/2009 if I pass week number as 7 then it should return 2/8/2009. This gets if I know the date select trunc(sysdate, 'd') from (...)
27 January 2009
RMAN NEWNAME FEATURE: We have recently upgrade one of our systems to a new server which has a different file structure in both location and size. Is there a way to split a single datafile over many datafiles when using RMAN clone features. For Example Source file INDEX_01.dbf size 20GB Destination (...)
27 January 2009
Re: ! Live Naked Pot smoking: If you are into Sheep so much why post about naked pot smoking?
27 January 2009
Script to detect any changes to database: Hi, Would anyone have a nice neat little script that can do the above? Also what the actual changes were would be handy! Many thanks, tb3101
27 January 2009
^ Hot Tits free download videos: Get [link] these ladies dangerously hot goods free on your computer in pc , mac and linux versions skid 5000 vidz archive pink eddie 6370 reserves.
27 January 2009
Yet another "why is my index not used" question: Hi all, our environment: 9i EE 9.2.0.4 64bit, Solaris 8 We're trying to understand why the CBO picks suboptimal single partition scan, when there is a more efficient index range scan available. Some details (table name modified): segment statistics are gathered with the (...)
26 January 2009
* Hot girls videos pics and much more: [link] - free downloads for your perusal.
26 January 2009
2009 Salford Data Mining Conference - San Diego, CA: Salford Systems' Data Mining Conference 2009 San Diego, California Conference Dates: August 23-25, 2009 Post-Conference Training: August 26-28, 2009 Don't miss Salford Systems' 6th International APPLIED Data Mining Conference, featuring real world applications and (...)
26 January 2009
Expiring passwords question: Hi all, When I select from dba_users it shows a schema with a password that will expire tomorrow. I do not want to change the password however. How can I make the password NOT expire tomorrow? (Without changing the password)? Version 10.2.1, Windows 2003 (...)
26 January 2009
Error 12154 - could not resolve the connect indentifier specified: Hi all I have to make to connect to two databases in other departsments. I am using 3 computers, my own, test intra server and intra server. I have updated the tnsnames.ora file on the test server, but it is the only one, which cannot connect to anything except our own server. The (...)
26 January 2009
Regarding Oracle version upgrading questions: hi, we are considering seriously on upgrading our database server. Current database runs on HP-UX 11.11, 20CPU and 36GB RAM. The version is Oracle8.1.7. To system running records, we met Ora-600 error frequently. There is always sequent read and latch waiting in system. We also found, (...)
26 January 2009
Any chance to surpass 4000 character limit?: Hi Oracle experts, with Oracle 9i Release2, and/or Oracle 10g Release 2, is there any chance to surpass the 4000 character limit for a *searchable* character column? At the moment we are splitting longer texts into several rows, but since most other databases work with longer (...)
26 January 2009
Brave new stats in 11.1.0.7: There are some very strange new statistics in 11.1.0.7, namely the "fastpath" mechanism for consistent gets. There are 2 types of fastpath consistent gets, one for the db blocks, one apart from that one, probably for the index blocks. That would be consistent with (...)
26 January 2009
where to find sql generated by EM in 10g: Hi some time ago I think I recall stumbling across the sql which was generated for an Enterprise Manager operation on the file system of the Oracle host. Does anyone know this location as I can't find it again? See Ya (when bandwidth gets better ;-) Chris Eastwood (...)
26 January 2009
Selecting from colection within a table: Oracle 10.2.0.4.0 Windows 2003 Server I'm trying to see if I can use collections within tables instead of long where conditions with lots of ORs but I'm stumbling right now. I have an existing table similar to below along with code used to select rows from the table: TABLE (...)
25 January 2009
Question on oracle control file: I have a database with 3 control files on 3 different disk. They are in location: /dbcontrol1 /dbcontrol2 /dbcontrol3 As I know, they are mirroring each other. Is there any way to disable one of the mirror, let say /dbcontrol2, so that I can change any other bigger hot swap hard (...)
23 January 2009
Can AQ under CDC be directly accessed?: I'd like to access the Oracle AQ that is underneath the CDC subscriber window directly. Can it be done? How is the AQ named and can messages be consumed from the AQ without crashing CDC? Background information: This is for message based integration (JMS) of an ERP system to an (...)
23 January 2009
IMP-00098: INTERNAL ERROR: impccr2: When I import a dump from the same scheme I get the following message: IMP-00098: INTERNAL ERROR: impccr2 About to enable constraints... Import terminated successfully with warnings. We use Oracle 9.2.0.8 which recently was updated from 9.2.0.5. It also happens when I import a dump (...)
23 January 2009
Flashback vs. rollback mechanism: In the newer versions of Oracle there are 2 distinct mechanisms for undoing the effect of transactions: rollback and flashback. Rollback method is transactional, it simply undoes the changes made to the blocks during the failed transaction while the flashback method is more akin to (...)
23 January 2009
Imp-error: 23 January 2009
moving 10GR2 from server 2003 32bit to server 2008 64 bit - best method?: IIRC correctly an online (or cold) backup (user managed or rman) can't be restored on a different platform, although I faintly recall before 10G was released hearing that 10G datafiles were going to be platform independent, but perhaps I misunderstood. Anyway, we are upgrading (...)
22 January 2009
Fast roll-back: Hi, Why, where a roll back occurred, it is faster to reboot the database instead of waiting the end of the roll-back ? Thanks for your lights
22 January 2009
Query & Column Display: I did this once before a long time ago, but cannot remember how. Say I have 2 tables. I query table #1, and if the value I am looking for is not there, then get the value from table 2. Both tables have the same primary key, so they must be joined. I remember this was NOT a lot of code (...)
22 January 2009
Can oracle notify an application: Can Oracle notify a running application (Unix) about a change in some table data? something that the application can trap and take an action on?
22 January 2009
Saving Rich Text Format (RTF) in Oracle 10g using PL/SQL via VB/ASP.NET: Hi Everyone, I am converting from a Filemaker application to VB.NET/Oracle and the question that the user has a TEXT BOX where the user is able to highlight, color, underline, etc. the text. What I am seeing is RTF is the best option for VB/ASP.NET but where I am stuck is how to (...)
21 January 2009
Accessing Enterprise manager - oracle 11g - windows 2003 - password failure: We have windows 2003 server and we are running 2 oracle databases in version 11g. We were successfully configured EM for one database and when we were tried for the other database we encountered configuration errors and we were able to sort by searching on "google", solution (...)
21 January 2009
LD_LIBRARY_PATH in mixed environment: hi, I've installed test RAC environment and everything works fine, there where no problems during install process. Later I started wondering "why didn't I set LD_LIBRARY_PATH env" :)...now I am wondering - is this neccessary ? If yes - what need this ? I've got (...)
21 January 2009
Hundreds of perl-processes in Linux, Oracle 10.2.0.1: Hi, we have multiple Oracle 10.2.0.1.0 databases in different Linux servers (different Linux versions) and all of them face the same problem every now and then. The database server gets very slow and with top-command I see hundreds of processes with user=oracle and command=perl and load (...)
21 January 2009
unknow appliaction in ORA grid: Hi All, just a very simple question: I have an general business appliaction what using ORA database (wrote in Delphi) A company would like to use this application, and this comapany have a Grid 1.0 architecture. Do I need any modification on my oracle access layer, or not? This (...)
21 January 2009
iWare Logic provides Oracle Apps Training and Certification: iWare Logic provides “Oracle Apps Training” and Certification in Oracle EBusiness Suite Financials, HRMS, Supply Chain, CRM, System Administration in association with Oracle University. For details please check [link] For Special Offer on our Oracle Apps trainings please (...)
21 January 2009
ODBC SQLColums is very slow: Hello, I'm using the Oracle ODBC driver to connect to my 10g database, and found the SQLColumns function (that returns a table description similiar to sqlplus's "describe" command) to be terribly slow: It takes about 1.3 seconds per table, even when executed repeatedly (...)
20 January 2009
DBA_OUTSTANDING_ALERTS: Hi, We have some technical problem with 10g OEM and we have raised a TAR for that, but since 3 months we have'nt got any solution for that . They are still working.... I want all the outstanding alerts should be sent to my official email id is that possible .if it is possible can (...)
19 January 2009
Oracle 11g Virtual Columns?: I have read various articles on virtual columns? I still do not understand their advantages other than they save some disk space, One can put logic of virtual columns in a trigger which will save information in a real column. Real column will need some additional disk space, but it will (...)
18 January 2009
Upgrade Plan: Hi All We are in the process of upgrading Oracle . We are at : RDBMS : 9.2.0.6 Oracle Client ver: 9.2.0.6 OS : HP Ux 11.23 RAC : 02 Node RAC VCS : 4.1 Target RDBMS : 9.2.0.8 Questions a) What dependency 9.2.0.8 will have on OS, VCS ? I mean OS patch, VCS Ver etc. b) Can (...)
17 January 2009
dbms_flashback: wiki about DBMS_FLASHBACK [link] regards,
16 January 2009
Slow access to the data base.: Good day, I have an oracle installation on an IBM machine with AIX. I have three users created on the Oracle DB: The user "oracle", "mo", and "fo" The installation was working well so far. But for almost a week, the connexion of the users "mo" (...)
16 January 2009
help with select statement: Hi, I've got the following SQL statement and it is working almost fine. select distinct cscontact.name, relkeyword.swcode from cscontact, relkeyword where cscontact.pubindex = relkeyword.relpubindex(+) AND (relkeyword.swcode <> 173 OR relkeyword.swcode IS NULL) order by (...)
16 January 2009
quick question on cloning and patch levels..: Was going to open an SR for this, but time is tight so: The situation - Server running production database on 9ir2 is in a degraded state so I am moving 9.2.0.6 database over to new hardware imminently. Same platform more or less, a bit more RAM and CPU, windows 2003 server etc.. was (...)
15 January 2009
How to select all tables that have the same column name and column value: Hi everybody, I know how to select out all the tables that have the same column name using SELECT TABLE_NAME FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME = 'column_name'. I need to take it a step further to select only those tables that have the same column name and a certain field (...)
15 January 2009
ORacle IO Numbers (ORION): Hi, in the last weeks I was heavily using the ORION test tool available from OTN. I found some rediculous results from a 32 disks array. The array is supposed to physically deliver about 4500 iops. I believe that the pseudo random number generator (or the way it is used to calculate the (...)
15 January 2009
Visualization tool: All, I am looking for a fairly simple visulaization tool. I played around with Xcelsius and came to relize that it sucks big time. Its too sensitive for even a minor change and too many steps to get it up and running. Any suggestions will be much appreciated. (...)
15 January 2009
RE-make your business trip sucessfully and enjoyable: Dear Friend, Greetings Our company provides Services of International standard, which are as follows: Business Assistants, Business Secretary, Business Guide, Interpreter, Tour Guide, Travel Companion, Buying Agent and Selling agent during your International Tour, Domestic Tour, (...)
15 January 2009
Could someone provide the URL to download the Oracle demo file?: Recently, I read the Oracle Doc and find there are files distributed with the database that demonstrate how LOBs are used in supported programmatic environments.These files are installed in $ORACLE_HOME/ rdbms/demo/lobs/plsql/. I installed Oracle 11g and 10g, but the (...)
15 January 2009
diskgroup calculations: Hi I am using this query to display the size of the diskgroups in Oracle and manually adding the figures up to get the total size of the diskgroup. select b.instance_name, a.LABEL,a.NAME,a.TOTAL_MB,a.GR OUP_NUMBER from v $asm_disk a, v$asm_client b where a.group_number = (...)
15 January 2009
help with select for update: Dear group, I am trying to debug a problem with FGAC, i enable the policy on a table When i do SQL>select count(*) from tableA where col=1; COUNT(*) ---------- 1 I can get the row without problem But when i do SQL>select count(*) from tableA where col=1 for update (...)
14 January 2009
nice shopping plaza: hi,please check my web :[link] we have a lot of nice products at low price and PAYPL accept. sneaker,clothes,bags,and so on
14 January 2009
cannot recover copy of database: hi, I've got simple rman backup script: allocate channel c1 device type disk; backup incremental level 1 for recover of copy with tag='DB' database; recover copy of database with tag='DB'; release channel c1; ... Everything works fine until I've started (...)
13 January 2009
Re: Oracle9i Release 2 (9.2.0.7) installators: 1. oracle questions like this could go to an oracle group. comp.databases.oracle.server seems right for this one. (I cross posted my reply if you want to just continue discussion there.) 2. if you have a support contract, call Oracle. 3. not on contract? Also are you saying you do not (...)
13 January 2009
ARH-How syncronize database passwords: I have around 40 odd oracle 10g databases that use the same username/ password through the application. Now I need to synchronize these passwords anytime someone changes it on 1 database and this has to happen in near/real time for my requirement to be met. How can I do this completely (...)
13 January 2009
Where I can find Oracle9i 9.2.0.7: Hi! I have Oracle9i Release 2 (9.2.0.4), but I must install or upgrade to version 9.2.0.7. Where I can find these instalators or patch? These is not produtions server - I can reinstall it.
13 January 2009
Assioma Watch, Best Wristwatch: Assioma Watch, Best Wristwatch Best Watches World: [link] Bulgari Watches World: [link] Bulgari Assioma Watch : [link] Sotiro Bulgari emigrated from his native Greece to Italy in 1879. His first shop opened in Rome in 1884. Then, in 1905, with his two (...)
13 January 2009
Blog update: [link]
13 January 2009
How to reverse an LDAP query?: Hello, I have developed a (Oracle 9i) packaged funcion to get a user's email address from their username in an LDAP server. How can I reverse this so I get the username from the email address? Below is the query and the package. Any help would be highly appreciated! Thanks, (...)
12 January 2009
Business Systems Consultant, Salt Lake City, UT (Local candidates only): Hello, Warm Greetings!!! Please send the suitable resume to pr...@jivainfotech.com Job Title: Business Systems Consultant Duration: 6+ months Location: Salt Lake City, UT Description: Must be Local and have PAC2000 experience Looking for a PAC2000 Business Analyst responsible (...)
12 January 2009
Application Systems Engineer at Tempe, AZ: Hello, Warm Greetings!!! Please send the suitable resume to pr...@jivainfotech.com Job Title: Application Systems Engineer Duration: 1 year Location: Tempe, AZ Description: HP SAS or OpsWare experience is required Particularly skilled in supporting HP SAS formerly OpsWare (...)
12 January 2009
Reviews of Dan Tow's "SQL Tuning"?: Hi All, My apologies if this should have gone in CDOM, but it seemed relevant here. I have seen several posts that mention this book as part of a reply, but I wanted to get a separate thread for it in case anyone has a string opinion on it one way or the other. (...)
12 January 2009
ORACLE ERP mail list or forums?: our company plan to use ORACLE ERP and we are new to this area. Does there has ant ORACLE ERP mail list ot Forurms which we can get help? Thanks.
12 January 2009
"Page refreshed" Time displayed by dbcontrol ?: I posted this question on the OTN forum a couple of days ago, but got no response, thought I'd try here. Oracle 10.2.0.2.0 on HP-UX Itanium Just noticed this: SQL> select sysdate from dual; SYSDATE -------------------- 09-jan-2009 11:21:41 SQL> !date Fri Jan 9 (...)
11 January 2009
Advanced Technology: Technology is a concept that deals with knowledge of tools and crafts The word "technology" can also be used to refer to a collection of techniques Technology is the application of maths, science and the arts for the benefit of life The Latest technology's are Wireless (...)
11 January 2009
WRH$_SESSMETRIC_HISTORY is empty: I have an issue with this table It is empty and should contain session level metrics ... anyone around who have the same issue patrick
10 January 2009
Help required - URGENT PLS: CAN U HELP ME? I get ORA-01034 WHEN I TRY TO GET TO MY DB. THIS IS PROD, SO YOU MUST NOT DLEAY. PLS DO THE NEEDFUL SOONEST. THX GURU'S. RANJEET
10 January 2009
ora-3113 creating CONTEXT index on BLOB: Oracle Standard Edition 10.2.0.2 on OpenVMS 8.3 (Itanium server) I am attempting to create a CTXSYS.CONTEXT index on a blob column in a table. When I run the command I get: SQL> CREATE INDEX XXX ON FRS_DOCUMENT_STORE(DOCUMENT_DA TA) INDEXTYPE IS CTXSYS.CONTEXT; * ERROR at line 1: (...)
9 January 2009
Another Messed Up Query: This must be a bad day for me. Here are the 2 tables: TABLE A -------------- ID MONTH YEAR TOTAL_RETURN ------------------------------ ------------------------------ - A 1 1997 56 A 2 1997 88 A 3 1997 98
9 January 2009
Oracle listener and JDBC - newbie question: In order to connect to an oracle database via JDBC the oracle listener must be running on the database server. Thats correct isn't it?
9 January 2009
Change of database characterset: Hi all, I am about to change our dev database characterset from WE8ISO8859P1 to UTF8 (new database,export/import) to bring dev in line with production. However, before I do this I would be grateful if someone could explain the fundamental differences between the two charactersets i.e. (...)
9 January 2009
AWR Java JFreeChart Monitoring variance ASH spikes detection ...: I am looking for people interested in these Oracle issues and challenges Had already started developping java API for helping DBA in monitoring issues [link] anyone up to the challenge and ready for helping happy new year 2009 (...)
9 January 2009
How to get the 'SQL query' which is blocking rows: Hello All, I was able to get to the object using object_id from v$lock.p1 for TM type lock. But I actually want the sql query from blocking session which locked that objects row(s). For example: session 1: update table_a ..or select for update.. or delete ... select * from table_b (...)
9 January 2009
RMAN 'delete obsolete' command takes ages: Hi, I'm running Oracle 10g on RHEL 5.2, backing up with RMAN to Tivoli Storage Manager. When I run 'delete obsolete', it quickly lists what it wants to delete but then just sits there for many tens of minutes, occasionally deleting one. strace tells me that the rman (...)
9 January 2009
How to find out common records with Where clause: Dear Gurus, I have "VISITOR" table as follows. VisitNo EmpName Address ------------------------------ -------------- 1 Sanjeev Mumbai 2 Rajeev New-Mumbai 3 Shailesh Mumbai 4 Ramesh New-Mumbai 5 Sanjeev Pune-1 6 Rajeev (...)
9 January 2009
Prada shoes (paypal payment)www.king-trade.cn ): Footwear (paypal payment)[link] ) Paul Smith shoes Jordan shoes Bape shoes Chanel shoes (paypal payment)[link] ) D&G shoes Dior shoes ED hardy shoes Evisu shoes Fendi shoes (paypal payment)[link] ) Gucci shoes ` Hogan shoes (paypal payment)[link] ) Lv (...)
9 January 2009
cheap THE CROUN HOLDER jeans wholesale: jeans: cheap EVISU jeans wholesale [link] cheap ED hardy jeans wholesale cheap COOGI jeans wholesale [link] cheap GINO GREEN GLOBAL jeans wholesale cheap LACOSTE jeans wholesale cheap G-STAR jeans wholesale cheap KED ROBOT jeans wholesale cheap RED MONKEY jeans wholesale cheap (...)
9 January 2009
TNS-12500: TNS:listener failed to start a dedicated server process: Hi All We are badly being hit by the following error: 08-JAN-2009 12:43:05 * (connect_data=(server=dedicate d) (service_name=XX)(INSTANCE_ROL E=primary)(failover_mode=(type =session) (method=basic)(backup=YY)(retr ies=180)(delay=5))(CID=(PROGRA M=oracle) (HOST=ZZ)(USER=oracle))(INSTAN (...)
8 January 2009
gc buffer busy and rac testing: Hi, I'am testing 2 node RAC but I haven't got too much experince with this technology and I am little puzzled after test results. I used Swingemch (order_entry test) and when I ran this test on 2 nodes RAC performance is much lower then on only one node of this cluster. TPS (...)
8 January 2009
Unexpected conversion from AL32UTF8 to WE8ISO8859P1: Hi, I have two databases: the source, version 10.2.0.3.0 with AL32UTF8, and the target, version 9.2.0.5.0, with WE8ISO8859P1. I copy a table, containing single and double byte characters, from the source database to the target database with "insert into ... select from (...)
8 January 2009
discount Air max 95 shoeswww.gotoorder.cn: discount Air max 95 shoes[link] wholesale Air Max 87 shoes discount Air MAX LTD shoes sell Air max 90 shoes discount Air Max 88 shoes[link] discount Air MAX 89 shoes discount Air max tn shoes discount Air Max tn8 shoes discount Air MAX tn9 shoes[link] discount MEN'S (...)
8 January 2009
MERGE Command: Been looking all over for this answer: MERGE INTO x USING DUAL ON (x.c4 = 'A') WHEN MATCHED THEN INSERT VALUES (0,0,0,'0'); ERROR at line 3: ORA-00905: missing keyword I want to skip the whole "SELECT COUNT(*) blah, blah, blah" to check for record (...)
7 January 2009
What is the ora_q000 process: I've got three background processes named ora_q000, ora_q001, and ora_q003 on a 10.2.0.4 instance. What are they? The documentation ([link]) says nothing about ora_q000 processes, and a google search didn't turn up anything other than other folks asking the same question but not (...)
7 January 2009
Java Programmer at Phoenix, AZ: Hello, Warm Greetings!!! Please send the suitable resume to pr...@jivainfotech.com Java Programmer Duration: 6 months Location: Phoenix, AZ Requirements: Must be customer focused. Must be a good problem solver. Must have excellent communication skills Must have development (...)
7 January 2009
How to exclude a Table during Import: Hi All, I have taken backup of entire schema using exp un/pass owner=TOM file=tom.dmp ..... Suppose TOM has 03 tables T1 , T2, T3 in his schema. Now , while import the entire tom.dmp file to some other database , excluding T2 table. How to do that in import statements.? I mean is (...)
7 January 2009
default select order: Hi, we have changed from Oracle 7 to Oracle10g2 and found a mistake from our program that didn't appear in the old environment. That is, we have two select-statements that should return rows in the same order but there is no order by -clause. Now I'm wondering why 10g2 works (...)
7 January 2009
XP Startup Hangs: Many of our clients' PCs have started hanging at the 'Loading Personal Settings' stage since installing 11g client. If they unplug the network cable before switching on, then plug it back in afterwards, the problem goes away. Similarly restoring back to 10g client solves the (...)
7 January 2009
POLO 5 T-shirt www.king-trade.cn: We provide Abercrombie & Fitch,Lacoste,Ralph Lauren polo etc brand cloth,like t-shirt,jacket,jeans,fleece,pa nts and so on), also provide sports Jersey:NBA jersey,NFL jersey,NHL jersey,MLB jersey. All of our products are in high quality with competitive price,safe and fast (...)
7 January 2009
JIMMY CHOO bags ( paypal payment )( www.king-trade.cn ): GUCCI bags ( paypal payment )( [link] ) CHLOE bags CHANEL bags CLOTHES COACH bags ( paypal payment )( [link] ) DOLCE&GABBANA bags FENDI bags GUESS bags JIMMY CHOO bags ( paypal payment )( [link] ) JUICY bags LV bags PRADA bags ( paypal payment )( [link] ) BAPE (...)
7 January 2009
index skip scan: First of all I am using 10.2.0.3 running on solaris 64-bit. I have the following query. select * from inventory_trans_qty itq where itq.effective_date > '01-Dec-2008' and itq.effective_date <= '05-Dec-2008' I have the following two indexes on that table. (...)
6 January 2009
DataWarehousing: Hi, I got a oracle 10g database for datawarehousing. I dont know about datawarehousing concepts and the ways to performing tuning techniques applied in it. Please clarify me the following questions : For performance tuning and to know about the details of that database : In a (...)
6 January 2009
Monitor Standby Database using Grid Control: Hi, Would it be possible to use OEM Grid Control 10gR3 to monitor 10g standby database without using Data Guard Broker? From the documentation, it appears that I would need to configure a Data Guard Broker? thanks.
6 January 2009
Looking for Java Developer: Dear Friends, We are looking candidates for Java Developer position in Phoenix, AZ. Please find the job description below. Position Title: Java Developer Job Location: Phoenix, AZ (Only local candidates need apply) Duration: 6 months Employment status: Corp2Corp Job Description : (...)
5 January 2009
ISO weeknumbers: The IW format string returns the ISO week number IW No Week of year (1-52 or 1-53) based on the ISO standard. I'm confused by this. When would you get week 53? For example, when running this against the last week of 2008 (using 9.2.0.7 SE) , it switches from week 52 to week 1 (...)
5 January 2009
JBDC URL – is they a way to provide indirection for db name?: A third party application is using JDBC URL to connect to Oracle, jdbc:oracle:thin:scott/tiger@M yOracleHost:1521:MyDB For some reason in third party application, same URL has to be used for Dev, QA and Production. I know using /etc/hosts (Or its equivalent in Windows), I can point (...)
5 January 2009
backup/restore of a table with multiple xmltype columns failing: Operating System: Sun Solaris 10 Database Version: 10.2.0.1.0 64 bit Rac: 2 nodes export/import: using the expdp and impdp command We have a table which has an xmltype column amongst other columns. We had a problem importing data into the table from an export of the same table. We (...)
5 January 2009
Wishes From Onlineteaching.in: Hi !! Onlineteaching.in Wishing You A Happy and Successful New Year 2009. We make your new year a year of successful career with lots of blooming accomplishments which would help you boost your self- confidence and job skills for further prosperous endeavors. We are honored to (...)
5 January 2009
The duration of one single oracle job: The question I have is simple and I thought I would find the answer in no time, but no luck. I user Oracle 10g, but we do not use the scheduler, but dbms_jobs. I have a job that gathers table statistics once a week. I want to know how long the last job execution took. In user_jobs (...)
5 January 2009
Application "deployment" tool?: With multiple databases (all Oracle 10gR2) and a single version of application code (pl/sql plus css, images etc - it is a web application)) can anyone suggest any good tools for managing the release and "build" of each database we have to upgrade? Ideally somthing that ties (...)
4 January 2009
Export question 10gR2 - different query for different tables: Oraclr 10gR2 - 10.2.0.1 Hi the exp utility supports a "query" parameter - is it possible to specify this on a per table basis within a single parameter file? The way I understand it this is not possible - the query will be applied to all tables in the export. However it (...)
4 January 2009
Children with multiple parents: Hi All, 10.2.0.4 64 bit Enterprise on SuSE 2.6.16 I have been working on a small application to allow us to print a hierarchical list of affected systems when a change is made to another system. For example, when a change is made to our storage system, we want a report that may look (...)
2 January 2009
cheap wholesale jordan shoes: cheap wholsale jordan shoes, sneakers , jordan 1, jordan 2, jordan 3 , jordan 4 ,jordan 4 , jordan5 , jordan 6, jordan 7 ,jordan 8, jordan 9, jordan 9, jordan 10, jordan 11, jordan 12, jordan 13, jordan 14, jordan 15, jordan 16, jordan 17, jordan 17 , jordan 18, jordan 19, jordan 20, (...)
2 January 2009
Oracle Certification DBA or Developer: Dear Gurus, I have got 2.5 years experience in Oracle 9i (SQL, PL/SQL) with Java. Mostly Database development (SQL, PL/SQL). I want do a certification in Oracle and having a doubt where should go? Whether Developer or DBA track, as well as which certification I need to go for so (...)
2 January 2009
create sequence in procedure / privileges ?: Hi, I'm facing problems when creating sequences in a stored procedure. Seqs are beeing created with dymanic pl/sql and eevrything should be fine - but still seqs are beeing dropped but not created or altered - this must be up to privileges ??? If so, what privs there should be in (...)
2 January 2009
GOLDEN PROFIT SHARING SPECIAL DEPOSIT BONUS 10 % PROMO OFFER: Apakah Anda Serius Ingin Mendapatkan Pasive Income ?? Jika Jawaban Anda ya..., Selamat !! Anda berada ditempat yang tepat ! TITIPKAN SEDIKIT DANA ANDA DI G P S ....akan diputar di BetOn Market dan Forex Trading secara profesional Program ini dikelola di Ciputat Jakarta dan sudah go (...)
2 January 2009
15,999$,WATCH FULL OPEN VIDEO,SANIA MIRZA & KATRINA KAIF: PER MONTH 15,999$ & MORE. WATCH KATRINA KAIF OPEN, SANIA MIRZA,& ALL INDIAN ACTREASS..AND MORE THING.. [link]
1 January 2009
rman ? nfs ? slow: I use rman backup product database on OS windows(2003 R2 standard 64 edition ) ,I check to find it is slow (vs Linux rhel 4.3 ). My nfs server use SFU for windows. windows: => select * from v$version ; BANNER ------------------------------ ------------------------------ ---- (...)
1 January 2009
how to link BBED executable in windows: Hi All, How can i link oracle BBED executable in windows .. can any one help me out ??. Regards Balakrishna.
31 December 2008
SQL Flooding Shared Memory: Hi All I have identified the SQL occupying max shared pool space. Detailed as follows::: SQL> show parameter shared_pool_size NAME TYPE VALUE ------------------------------ ------ ----------- ------------------------------ shared_pool_size big integer (...)
30 December 2008
NIKE AIR JORDAN FORCE FUSION SHOES AJF 5 V JORDANs 5 FUSION NIKE: shoes on AIR Jordan 1 (paypal payment)[link] AIR Jordan 2 AIR Jordan 3 AIR Jordan 4 AIR Jordan 5 (paypal payment)[link] AIR Jordan 6 Rings AIR Jordan 6 AIR Jordan 7 AIR Jordan 8 AIR Jordan 9 (paypal payment)[link] AIR Jordan 10 AIR Jordan 11 AIR Jordan 12 AIR Jordan (...)
30 December 2008
Replicated File System Consistency: So we've got a half dozen or so Oracle 10G (10.2.0.3) servers with production data on them. Historically, we ran them with direct attached RAID arrays, but recently we moved them to a new data center with a netapp 3040 SAN. Performance on the new hardware seems about the same; SAN (...)
29 December 2008
Library Cache: Hi, We installed this Spotlight for Oracle software. The software shows an 85% re-parse rate against the Library Cache. Here is the biggest issue we have. I do not think anything can be done, but maybe another brain can figure something out: We have a table with stored queries: Row (...)
29 December 2008
SUPRISE...!: [link]
29 December 2008
Unit of TIME in dbms_xplan: I am 10.2.0.3 on HP UNIX 11i I use sqlplus to run a query. I set set autotrace on which I think calls dbms_xplan to display the sql plan. Query took 54 seconds to complete (using UNIX time x command). Plan (only few lines are shown), times are lot more. I do not understand TIME for (...)
27 December 2008
When should one rebuild an index?: Hi We can use ANALYZE INDEX <index> VALIDATE STRUCTURE command on the affected indexes - each invocation of this command creates a single row in the INDEX_STATS view. Thus determining the indexes which are good candidates for rebuilding. BUT my doubt is that if, we use (...)
27 December 2008
How to read BLOB data from Oracle table: Hi All How to read BLOB column using simple method. I can do using TOAD ( export option). Regards
26 December 2008
Cosmetic Surgery Tips: How To Get Laser Hair Removal Information [link] Plastic Surgery - Buttock Augmentation [link] Cosmetic Surgery Tips [link] How to choose your esthetic surgeon? [link] The MedLite laser - the choice for tattoo (...)
26 December 2008
GIDS 2009 .Net:: Save Big, Win Big, Learn Big: Act Before Dec 29 2008: ------------------------------ ------- ------------------------------ ------------------------------ ------- Dear Group members, The economic downturn will run out of steam trying to outdo the 'ready and waiting' software professional. Packed with premium knowledge, action (...)
26 December 2008
Footwear (paypal payment)www.king-trade.cn ): Footwear (paypal payment)[link] ) Paul Smith shoes Jordan shoes Bape shoes Chanel shoes (paypal payment)[link] ) D&G shoes Dior shoes ED hardy shoes Evisu shoes Fendi shoes (paypal payment)[link] ) Gucci shoes ` Hogan shoes (paypal payment)[link] ) Lv (...)
26 December 2008
Improving Performance of Hash Joins: I am on Oracle 10.2.0.3 on Windows 2003 32 bit. I have /3GB switch set on and have a value of sga_target set to 2.x GB, I am using a third party package and many queries are doing hash joins. I cannot modify any queries because of no source code available to me. I know in Oracle9i, (...)
25 December 2008
www.iofferkicks.com china cheap wholesale nike shoes,air jordan shoes,air force one shoes.: Get Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
25 December 2008
shaggy dba joke: I resisted joining linkedin.com for a long time, somehow I had the idea it was for headhunters and finding jobs and that sort of thing. My alumni association sent an email saying they now had a group there, so I thought, ok, I'll join for that, there're some people I wouldn't (...)
25 December 2008
Re: Question about Queries: SELECT address FROM emp WHERE name = 'John Doe';" won't get reparsed IF that is exactly what you send each and every time. (soft parse, which with some languages you could further avoid) But SELECT address FROM emp WHERE name = 'John Doe';" is NOT the same (...)
24 December 2008
Library Cache: Hi, 2 questions here: First, in terms of minimizing the number of parse/execute calls, it is suggested to use bind variables. Is a bind variable the same as a plsql variable? If I have a stored procedure with either of these in them, will it remain in the library cache? SELECT (...)
24 December 2008
DUNK DUNK man DUNK women DUNK High man DUNK High women: ( paypal payment )( [link] )Air Jordans Air Jordans 1 Air Jordans 2 Air Jordans 3 Air Jordans 3.5 Air Jordans 4 Air Jordans 4.5 Air Jordans 5 Air Jordans 6 ( paypal payment )( [link] )Air Jordans 7 Air Jordans 8 Air Jordans 9 Air Jordans 10 Air Jordans 11 Air Jordans 12 Air Jordans (...)
24 December 2008
CLOB to file via UTL_FILE: I have large CLOB (XML) (way bigger than 32K) data that has NO LINEBREAK/NL..... I want to write the CLOBs to files. Using UTL_FILE...is there anyway to avoid newline --- so that the file size = LOB length ? If not, is there another option ? (...)
23 December 2008
Help with Regular Expressions: Oracle 10.20.03.0, 64 bit Windows 2003 Server I'm trying to use regular expressions (REGEXP_REPLACE) to transform rows like the following from rows with multiple values to one value per row. I've used similar syntax to extract first and last names but this is not working at (...)
23 December 2008
IO function metric.: Oracle 11g has a table called V$IOFUNCMETRIC which is a typical metric table, like the set that was introduced in 10g. What confuses me are 2 things: 1) SQL> select function_name from V$IOFUNCMETRIC; FUNCTION_NAME ------------------ Recovery Direct Writes Smart Scan Others (...)
23 December 2008
How to rewrite the query using with Clause: Hi, Can any body help me out in rewriting the query using with clause where ever necessary or any method which suits for better performance. SELECT distinct (SELECT ood.organization_name FROM org_organization_definitions ood WHERE ood.operating_unit = ood.organization_id AND (...)
23 December 2008
Instant Client on Server ?: App Server is Windows box. Can Instant Client be used on server ? or should it be the full Oracle Client ? thanks 10gR2
22 December 2008
Prada shoes (paypal payment)www.king-trade.cn ): Footwear (paypal payment)[link] ) Paul Smith shoes Jordan shoes Bape shoes Chanel shoes (paypal payment)[link] ) D&G shoes Dior shoes ED hardy shoes Evisu shoes Fendi shoes (paypal payment)[link] ) Gucci shoes ` Hogan shoes (paypal payment)[link] ) Lv (...)
22 December 2008
NIKE AIR JORDAN FORCE FUSION SHOES AJF 5 V JORDANs 5 FUSION NIKE: shoes on AIR Jordan 1 (paypal payment)[link] AIR Jordan 2 AIR Jordan 3 AIR Jordan 4 AIR Jordan 5 (paypal payment)[link] AIR Jordan 6 Rings AIR Jordan 6 AIR Jordan 7 AIR Jordan 8 AIR Jordan 9 (paypal payment)[link] AIR Jordan 10 AIR Jordan 11 AIR Jordan 12 AIR Jordan (...)
22 December 2008
www.iofferkicks.com china cheap wholesale nike shoes,air jordan shoes,air force one shoes: Get Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
21 December 2008
Deleting Large Numbers of Rows w/o Filling up my redo logs: I'm managing a server that spins about a million rows of logging information a day. This is up from about 200k rows a year ago, or about 400k rows last summer. Since we didn't want the log table to grow to absurd sizes, we like to only keep about 7 days worth of logs. So (...)
20 December 2008
iofferkicks.com china cheap wholesale nike shoes,air jordan shoes,air force one shoes.: Get Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
20 December 2008
TDE: I just read an oracle white paper on transparent data encryption in 10gR2. It states that decryption occurs at the SQL layer. Doesn't that mean that the data will be decrypted *before* it's transmitted over the network to a client? I would think that defeats part of the goal of (...)
19 December 2008
Grid Control 10gR2: repository password: oracle@oracle-test-04$ uname Linux oracle@oracle-test-04$ uname -r 2.6.18-6-amd64 oracle@oracle-test-04$ echo $ORACLE_HOME /opt/oracle/product/oms10g oracle@oracle-test-04$ /opt/oracle/product/oms10g/bin /emctl getversion Oracle Enterprise Manager 10g Release 4 Grid Control (...)
19 December 2008
Hash Based Column Sampling In 11g As Compared To RowBased....: Hi, In 11g (11106), here is what is mentioned about the stats gathering, [link] In the 11g NF guide from OU, it is mentioned that prior to 11g , the column sampling was done with the help of "Row Based Sampling". In 11g, if one uses, ESTIMATE_PERCENT=>AUTO_SAMPLE_ SIZE (...)
19 December 2008
Nike Jordans Fusion 23 AIR Jordan 22 Jordan Fusions 21 AIR Jordans: NIKE AIR JORDAN FORCE FUSION SHOES AJF 5 V JORDANs 5 FUSION NIKE JORDAN 5 FUSION SHOES AJF5 Nike Air Jordan XXIII 23 Force 1 Jordan Fusion AJF 23 AJF23 AJ23F (paypal payment)([link] ) Nike Jordans Fusion 23 AIR Jordan 22 Jordan Fusions 21 AIR Jordans Fusion 20 Jordan 19 shoes Air (...)
19 December 2008
Synonym in trucate table, drop table ...: am on Oracle 10.2.0.3 on HP UNIX 11i. When I execute a statement: truncate table t; where t is a synonym for a table tx I get error ORA-00942: table or view does not exit However, if I do truncate table tx table is deleted. synonym however works for insert, select, delete, (...)
18 December 2008
Lead Oracle Developer at Orlando, Florida: Hi, We are currently searching for a PL/SQL Developer for our client in Orlando, Florida. The company provides statistical analysis for the health industry. Skill (in order of importance): The role requires 5+ years of experience: " PL/SQL Development " Complex Stored (...)
18 December 2008
Web Designer / Developer at NYC, NY: Hi, We are currently searching for Web Designer / Developer. Please only respond with MS-Word Updated Resume if you can commute to New York City or are willing to relocate. Interactive Design Technologist Reuters is seeking an Interactive Design Technologist contractor for the (...)
18 December 2008
HTTP://WWW.STREETCANDY.ORG: Get Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
18 December 2008
performance of updates: I am in the midst of some performance improvements. I have never thought about this aspect before but has anyone tested the difference in performance between UPDATE mytable SET status = new_status WHERE mykey = thiskey; and UPDATE mytable SET status = new_status WHERE mykey = (...)
18 December 2008
Turning off DML commit when session is exited or disconnected: If i issue a DML statment in oracle database from sqlplus session (where autocommit is off by default ) and then 'exit' or 'disc' the session without explicitly commiting the DML ,the DML gets commited . Is it possible to turn off this default behaviour. Thanks in (...)
18 December 2008
QUERY TUNING: MY QUERY: select bran_code,sum(ps_tran_qty) cls_qty from bs_brnd_smr where substr(bran_code,3,1) !='D' group by bran_code; ------------------------------ ----- IN THE ABOVE QUERY I HAVE A NORMAL INDEX IN THE BRAN_CODE COLUMN.. THIS IS THE EXPLAIN PLAN OF THAT QUERY.. (...)
18 December 2008
Discount Coach Sandals, Dior Sandals, Prada Sandals, Chanel Sandals,: Discount Coach Sandals, Dior Sandals, Prada Sandals, Chanel Sandals, Versace Sandals, Crocs Sandals, Women's Sandals Men's Slippers From China [link] Discount, Prada Sunglasses, Discount, [link] D&G Sunglasses, Discount, [link] Fendi [link] Sunglasses,Discount,Burberry (...)
18 December 2008
grid control threshold global changes: Hi, In Oracle 10g Grid Control, I have modified the warning and critical thresholds of tablespaces for a particular database. Instead of going to each database to make the changes, is there a way of propagating the changes to other databases or is there a page where I can make global (...)
17 December 2008
table accesing: hi, i have table called employees.. many users are accescing this table at a time .. how can i find which users is accesing that table presently...
17 December 2008
Oracle RAC support & Clarify: Hi All Does Clarify CRM application supports Oracle Active-Active Real Application Cluster? Further, I will appreciate any refrence to documents/links. Regards. Shweta
17 December 2008
tool: convert classic oracle sql to ansi?: Hi Group, I do this manually from time to time - but maybe there's a better way ... Does anybody know of a way, tool or whatever to convert classic oracle sql-statements to ansi-sql and vice versa? Maybe the database is able to do so? Thanks, (...)
16 December 2008
Global Temporary Table with column of type ROWID and Oracle Updates: All, I have proposed a solution which uses a global temporary table to remember an updated record via its rowid. Concerns have been risen that this will cause trouble in case of an update of the Oracle version (currently 10.2.0.2) to another version with a changed format for ROWID (...)
16 December 2008
libaio: Hi, I am testing some storage configuration (raw devices/SAN) using oracle ORION tool. But SOMETIMES I've got error: waiting for async I/Os failed Linux-x86_64 Error: 14: Bad address Additional information: -1 Additional information: 1048576 I din't found any errors like (...)
16 December 2008
ASM and RAID: Now that we have sufficiently beat the RAID5 horse to death, let's add a twist to the debate. What is your experience either in the lab or real sites where you have the virtualization at the array level (pick your RAID level) in addition to the virtualization provided by ASM in an (...)
16 December 2008
Prada shoes (paypal payment)(www.king-trade.cn ): Footwear (paypal payment)([link] ) Paul Smith shoes Jordan shoes Bape shoes Chanel shoes (paypal payment)([link] ) D&G shoes Dior shoes ED hardy shoes Evisu shoes Fendi shoes (paypal payment)([link] ) Gucci shoes Hogan shoes (paypal payment)([link] ) Lv (...)
15 December 2008
NIKE AIR JORDAN FORCE FUSION SHOES AJF 5 V JORDANs 5 FUSION NIKE: shoes on AIR Jordan 1 (paypal payment)([link] ) AIR Jordan 2 AIR Jordan 3 AIR Jordan 4 AIR Jordan 5 (paypal payment)([link] ) AIR Jordan 6 Rings AIR Jordan 6 AIR Jordan 7 AIR Jordan 8 AIR Jordan 9 (paypal payment)([link] ) AIR Jordan 10 AIR Jordan 11 AIR Jordan 12 (...)
15 December 2008
ASM and IBM SVC: Can anyone share performance impressions when using ASM with SVC or even 9i(yeah we know...) cooked file systems? We currently have the impression that SVC can only return data in 32k chunks regardless of I/O setting at the OS (Solaris, AIX and HPUX) and or storage parameters in Oracle (...)
14 December 2008
Oracle Apps 11i and R12 training course form Oracle University Approved Education Center iWare Logic: iWare Logic provides “Oracle Apps 11i and R12 Training” and Certification in Oracle Apps EBusiness Suite 11i as well as R12 Financials, HRMS, Supply Chain, CRM, Apps DBA in association with Oracle University. For details please check [link] for Special Offer on our (...)
13 December 2008
EARN 15,000$ /- PER MONTH: TURN YOUR PC INTO A CASH GENERATING, MACHINE.WORK ONLINE FROM HOME. GUARANTEED,EXTRA CASH, 15,000$ /- PER MONTH. NO INVESTMENT [link]
12 December 2008
What is the basic structure of PL/SQL ?: What is the basic structure of PL/SQL ? [link]
12 December 2008
Application Server 10g and memory problem: Hello! Problem : 08/12/12 11:51:22 Exception in thread "Timer-4" java.lang.OutOfMemoryError: Java heap space WHAT I HEEEL I GOING ONE??? I have 16GB memory and CENTOS 5.2 can some one tell why my app hang i get this error? When its full operates suddenly hang and error (...)
12 December 2008
Clone wars: In oracle11g, cloning databases just got easier. MUCH easier. The "duplicate database" command now has an option "from active database" which will make a copy of the live database. I tested it on a small DB and it worked flawlessly. Of course, that is not a good test (...)
12 December 2008
Hit 4GB file size limit in Oracle 9.2.0.1.0 on W2003: Please could anybody help. A friend has a corrupted database. She has execeed 4GB on the size of a datafile. She has been told she will need patch 2585700 and will have to restore her database. I must admit I was not aware of this problem. I would be gratefull for any information, if (...)
12 December 2008
What will happen after commit statement ?: What will happen after commit statement ? [link]
12 December 2008
What is an Exception ? What are types of Exception ?: What is an Exception ? What are types of Exception ? [link]
12 December 2008
What is Pragma EXECPTION_INIT ? Explain the usage ?: What is Pragma EXECPTION_INIT ? Explain the usage ? [link]
12 December 2008
What are two parts of package ?: What are two parts of package ? [link]
12 December 2008
Reading data from oracle database: Can anyone help me on understanding how data is read from oracle database.There is a db writer process which writes data in the dbf files from dirty buffers. Similary what is the the mechanism for reading data from dbf files of oracle database. If a user connect's to sqlplus session (...)
12 December 2008
formula for OPTIMIZER_INDEX_COST_ADJ: Hello *, I am now looking at setting the optimizer_index_cost_adj. I read that a nice starting point would be to look at the ratio of the dbfile sequential read vs the scattered read (see [link] for details.) However, EVENT (...)
11 December 2008
asm on san: Hi, I'm preparing to test some configurations on san storage array. I would like to find out what will be better in my environment: raid1+0 or raid5. Other thing is what size of segment size should be configured on storage array. For example, I've got 5 disks in RAID5, so if ASM (...)
11 December 2008
For more products pls visit: www.king-trade.cn: iscount Air max 95 shoes [link] wholesale Air Max 87 shoes discount Air MAX LTD shoes sell Air max 90 shoes discount Air Max 88 shoes [link] discount Air MAX 89 shoes discount Air max tn shoes discount Air Max tn8 shoes discount Air MAX tn9 shoes [link] discount MEN'S (...)
11 December 2008
find out how many times particular character occur in given string.: Dear Gurus, I want to find out how many times particular character occur in given string. e.g. 'A*B*C*D*E*F' count of '*' is 5 'A*B*C*D' count of '*' is 3 'A' count of '*' is 0 Is there any function available in SQL to find out the (...)
10 December 2008
PERFSTAT tablespace and sppurge.sql: Hi all, Yesterday I purged 80% of the my statspack snapshots using sppurge.sql however, the PERFSTAT tablespace remains the same size as before the purge. My question is (and somehow I believe I should know the answer to this!) how comes the PERFSTAT tablespace has not shrunk (...)
10 December 2008
E-mail alert DBA_AUDIT_TRAIL: Hello, Oracle 10g 10.2.0.4 on Linux. I enabled some auditing of events to the sys.aud$ table (audit_trail = DB_EXTENDED). Is it possible to configure some sort of e-mail alerting so I receive a mail when new information is added to the sys.aud$ table ? Should I create a trigger on (...)
10 December 2008
Is there a way to extract the primary key from Oracle wallet?: Is there a way(or possible method) to extract the primary key from Oracle wallet if I know the password ? (Since Oracle10R2) Thanks.
10 December 2008
Very Cute And Very Sexy Blonde Stripping: [link]
9 December 2008
Crash recovery after shutdown immediate?: Hello *, Odd problem i had after i had shut down the database (immediate) and made a media copy. After restoring and opening with resetlogs, the database stated it wanted a recovery. After i did a recover until cancel, and cancelled immediately on first occasion, the database started. (...)
9 December 2008
chained jobs: hi, How to set condition to evaluate 1min after start of step_1? I've got this: BEGIN DBMS_SCHEDULER.DEFINE_CHAIN_RU LE ( chain_name => 'my_chain', condition => 'TRUE', action => 'START my_step_1', rule_name => 'my_rule_1', (...)
8 December 2008
how to cast ORA-22905 away?: SQL> SELECT * FROM TABLE(dbms_xplan.display ('PLAN_TABLE','p10','BASIC')); SELECT * FROM TABLE(dbms_xplan.display('PLAN _TABLE','p10','BASIC')) * ERROR at line 1: ORA-22905: cannot access rows from a non-nested table item According (...)
8 December 2008
Cambodia TEFL - Gap Year, Travel & Study, Paid Teaching Job - http://www.cambodiatefl.com: Cambodia TEFL - Gap Year, Travel & Study, Paid Teaching Job [link]
8 December 2008
performance questions and help!: Hi I’m kind of new in oracle administration, take the performance class, and try to learn and understanding the concepts. I came up with some questions. If you can just give me a hint or just help me to find out where should I go to get my answers. Here they are: 1. A user (...)
7 December 2008
Oracle database works properly but from designers tools I can't connect to database: I've installed Oracle 10G on my computer. I can log in using system account. by plsql. I've installed designer and tried to log from designers plsql to the same databse also using sys account - I could not't, I got ora-1017 error. What I'm doing wrong, why plsql from (...)
6 December 2008
how to activate oracle text in 10g enterprise: I need to do some testing with Oracle Text and have read that Oracle Text is automatically available in Oracle Express Edition (witnessed that on colleague's laptop) but in other editions that feature needed to be installed. I can't seem to find out how to install it on my (...)
5 December 2008
RMAN Error: We're starting to run RMAN. It backups the archive logs just fine. However, all of a sudden we receive this error: RMAN-00571: ============================== ============================= RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: (...)
5 December 2008
Upgrade Oracle 9i to 10g from 4096 to 8192 db block size: Is it something feasible? i have 9i running 4096 db block size and my goal is to do an upgrade to 10g and db block size 8192. thanks!
5 December 2008
10g R2 running e-Business Suite R12: Hello, We have a 10g R2 RAC db which houses our e-Business Suite R12. We have a tablespace which seems to be growing at an alarming rate. Considering how many transactional users I have. Does anyone know what kinds of data are being stored in the APPS_TS_TX_DATA tablespace? Thanks (...)
5 December 2008
a beginner's question: CREATE TABLE TEST_A ( ID VARCHAR2(5), ID2 VARCHAR2(10), CONTS VARCHAR2(20) ) CREATE TABLE TEST_B ( ID VARCHAR2(5), ID2 VARCHAR2(10), CONTS VARCHAR2(20) ) insert into test_a values ('11111','01','Test Row') insert into test_a values (...)
5 December 2008
Table fragmented: Table size (with fragmentation) SQL> select table_name,round((blocks*8),2) ||'kb' "size" 2 from user_tables 3 where table_name = 'BIG1'; TABLE_NAME size ------------------------------ ------------------------------ ------------ BIG1 72952kb Actual data (...)
4 December 2008
PLS-00801: internal error [*** ASSERT at file pdw4.c, line 589;: Hi all, The database this is occuring on is Release 10.2.0.3.0. Compiling the procedure below is producing the error LINE/COL ERROR -------- ------------------------------ ------------------------------ ----- 18/42 PLS-00801: internal error [*** ASSERT at file pdw4.c, line (...)
4 December 2008
Oracle Forms Server 6i and WebDB: Hello. It's the first time I get into this forum. I do really need your help... I have got a harddisk crash in a server with Forms Server 6i with Internet Application Server 9. I found that server working four years ago, and no documentation nor software is now available. So, I need (...)
4 December 2008
oracle application server 10g tuning: Hello! CentOS 5.2 32bit 100% Cpu 4 core and 9gb memory java used. Mayby some tuning tricks? Or something else? help
4 December 2008
OEM Grid control configuration questions: I have the following configuration questions: 1. Is there a way to not monitor TEMP and UNDOTS tablespaces space usage within Grid Control? I could not find a way to select tablespaces that I do not want to monitor. 2. Is there a global setting whereby I can specify tablespace warning (...)
3 December 2008
ORA-600 kghssgai3 Error in Win2003: Hi, Does anybody have any information about this specific ORA-00600 error in Win2003? I searched on 'kghssgai3', but did not find anything; ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [kghssgai3], [128], [36], [], [], [], [], [] Current SQL (...)
3 December 2008
SQL%ROWCOUNT value: Oracle 10g 10.2.0.3 In the code below can someone tell me exactly what SQL%ROWCOUNT is returning? Is it the number of rows processed or the number of rows updated? I'm trying to clarify since the individual who runs this says it's updating correctly but is questioning the (...)
3 December 2008
Obama's Birth Certificate - Demand that US presidential electors investigate Obama's eligibility: This message is not about the meaningless computer printout called "Certification of Live Birth" that Obama propaganda machine calls his "Birth Certificate". The American people are still waiting for a copy of Obama's original birth certificate that includes all (...)
3 December 2008
how to compute value from different rows: Hi, I have a big table (about 5 million rows) of phases and I need to compute the duration of the phase. I'm doing it now with a cursor loop (select... order by key, date; update duration := (newrow.date - oldrow.date) ), but that takes almost 20 minutes (Oracle 10g2). I believe (...)
3 December 2008
Oracle Database Backup: Hi, I am running an oracle 10G database on a suse OS and i have been assigned with the job of backing the DB. Now i, donot have enough space in the flash Recovery Area to carry out this tasks so i have been presented with a solution to backup the DB onto another machine. What happens (...)
3 December 2008
dual network adapters on ora 7.3: Happy Holidays to all !! Could this forum please make some suggestions on how to best utilize dual network adapters on a server running Ora 7.3 . OS is Windows 2000 Adv. Server. We need more performance/bandwidth, what are our choices, dual listeners, dual instances, split users (...)
2 December 2008
Oracle listener redirect configure help: Hello Folks, I have a question about the Oracle listener configuration. When a listener is configured, and a DNS name is used to populate the Hostfield, is it possible to put a DNS name in the hostfield, that is not replaced by its resolved IP address before it leaves the server? For (...)
2 December 2008
how to insert multiline values with empty lines in a VARCHAR2 column using SQL*Plus: Maybe a trivial question... I am able to insert multiline values in a VARCHAR2 column using SQL*Plus: --- file x.sql --- Insert into EMAILTEMPLATES (FOLDERNAME,TEMPLATENAME,SUBJE CT,DESCRIPTION,BODY,DELETED,TE MPLATEID) values ('Public','Target Crossed!','Target (...)
2 December 2008
Rman Question: I need to restore a copy of our database on a different server. I have full backups going back 4 weeks plus cumulative backups. I'm not sure where the problem happened. So, I figure I can restore the earilest copy, and if that is not it, restore the next full backup...... Anyhow, (...)
2 December 2008
iptables settings for 10g RAC: I have created a 10g RAC database, and want to lock down the individual servers with iptables. Can someone give me some sample rules which will allow free communication between server A and server B, for both the pub/vip/priv interfaces? Thanks (...)
2 December 2008
Oracle 10g Recycle Bin: Hi, I've read all about Oracle uses the recycle bin and how it purges objects when it needs space, etc. But, is there any way to manually control that, meaning to keep the objects in there longer? Other than increasing the size of the tablespace?? (...)
1 December 2008
triggers on views: Creating a database as a part of a school project, I ran into a problem that was solved by switching place of two rows that by the look of them would suggest their order would be irrelevant. The situation was roughly as follows: A view was created as a union of two tables. Two (...)
1 December 2008
Utility for creating a ZIP file from BLOBs?: Hi 10g R2 - 10.2.0.1.0 on Linux RHEL4 We have a number of documents in the database stored as BLOBs. Increasingly we are being asked to provide a method by which a number of these can be delivered to a user as a ZIP file. The application is web-based and uses the web pl/sql toolkit. (...)
1 December 2008
Yellowfin Business Intelligence recognised among 25 rising companies that CIO’s must know about.: MIS Magazine has recognised Yellowfin Business Intelligence as a rising star with inclusion in its strategic 100 list for 2008. The MIS Strategic 100 provides a snapshot of the international, domestic and soon-to-be-big technology vendors battling it out for market share. It also gives (...)
1 December 2008
Need Help: Getting hang while importing schema dump: Hi, System getting hang when I am trying to import schema dump into new schema. Actually, I am just creating duplicate schema in same DB. Consider, I have two schema A and B on the same DB and now I have exported schema A and trying import same into B.But while importing type (...)
1 December 2008
Made by TVO/Posiva/Tem ydintaivaat.: Oli taas härski vedätys ydinalaltamme. Eli ei antanut Kalli julkisuuteen edes sitä laajasti tunnettua faktaa, että hänen mm. 60v juhlat järjesti, kas kummaa TVO! Olisi toimittajilta kyllä ollut minimi vaatia edes näin räikeää faktaa esille. Mutta kuten olemme saaneet tottua (...)
1 December 2008
Function based index not used with like operator: Hi! I have two tables A and B where I in both tables have a function index (upper case) on a column. When I do a query like Select col1, col2 from A where upper(col_with_ucase_index) like 'ABC%' and I verify the execution plan it uses the upper case index on (...)
1 December 2008
Trying to get more interest in Dataphor starting with my blog: Greetings, I'm sure some here know of Dataphor. Dataphor is an open source project RAD tool that has a relational engine encorporating many of the ideas expressed by Date and Darwen in TTM (the third manifesto, an outline of a future db). I have been blogging about it for a while (...)
30 November 2008
Unofficial Phone, ,the most cheap mobile phones from china ,30 kinds today: Unofficial Phone, ,the most cheap mobile phones from china ,30 kinds today [link] [link] [link] [link]
30 November 2008
Formatted/Unformatted Oracle Block....: Hi, When a block comes under the HWM,I believe its formatted by Oracle.What I want to know is that is there any bit in block dump which does differentiate that the block is unformatted or formatted? Secondly, is there a difference in the performance for oracle when it formats a (...)
30 November 2008
Lot of row cache/library pin: Hi, I have a database 9.2.0.6, with the wait events below: Top 5 Timed Events ~~~~~~~~~~~~~~~~~~ % Total Event Waits Time (s) Ela Time ------------------------------ -------------- ------------ ----------- --------
29 November 2008
Query with concatenation in explain plan: I have a customer who has a bad-performing query, and the explain plan shows a split in the query with a concatenation at the end. Because the query is fairly complex, the two parts of the query take a lot of time, where (to my opinion) the whole part could be done in one run. I (...)
29 November 2008
Storing time values via jdbc thin driver: Hi, I have an Oracle 9.2 database. If I use the 9.2 driver java.sql.Time is stored with 1900-01-01 HH:MM. If I use the 10.2 driver java.sql.Time is stored with 1970-01-01 HH:MM. Is this a know bug/feature? Do I have to update all my records to 1970 when using oracle 10 driver? Thank (...)
28 November 2008
Re: No ni! Kuka tunnustaa?: TEM TYÖ JA ELINKEINOMINISTERIÖ ________________________ Helsingissä 27. päivänä toukokuuta 2008 "Mielipiteitten esittäminen julkisuuteen nettiin valtiovallan erityissuojeluksessa." "Voi esittää mielipiteitä ja antaa ydinkriittisiä lausuntoja kirjallisesti (...)
28 November 2008
HELP DESK: [ [link] ] [ [link] ] [ [link] ]
28 November 2008
Data Guard and Oracle 11g: I believe Data Guard was a free option with Oracle 10g EE. But is it still free for Oracle 11g ? Matthias
28 November 2008
Standby database Transport Lag: Oracle 10.2.0.3 EE with Data Guard Physical Standby configured with Asynchronous transport and real time apply. Platform RHEL 4 x86_64. How can I determine the exact lag between when a transaction is committed on the Primary database and when that transaction gets written into the (...)
28 November 2008
Long time for v$database_block_corruption to return: Hi, I've been noticing on Enterprise Manager that I am getting spikes in activity every 20 minutes or so. It is running the query: "SELECT nvl(sum(blocks), 0) FROM v$database_block_corruption". This can take up to two minutes to return, even though there are no corrupt (...)
27 November 2008
Complexity metrics for Oracle applications?: Can anybody point me to some good references or resources on software complexity measures that work well for Oracle applications - that is dealing specifically with stored procedures, SQL, data model, schema model and so forth? Also I would appreciate correction if I'm off base (...)
27 November 2008
VPD and rewritten queries: Hi, VPD rewrites queries - that's obvious - but I'd like to find out final sql executed for optimizing purposes. I should find sqls from all connected users with diffent roles and privileges - is there any simple way to get those after-VPD-add -sqls ? And if it's up to (...)
27 November 2008
Exporting and Importing SQL Statement Cache: Hi All, Does anyone know if it's possible to perform an export and import of the SQL Statement Cache in Oracle 8i? Thanks Steve.
26 November 2008
Documentation of databases.: Hi everyone. Anyone who have knowledge of a application/tool to use when you want to document all tables, columns, triggers and so on, all objects in a database? Years ago i worked with Designer2000. But i guess and hope that there is some lighter/smaller applications who has (...)
26 November 2008
W2K8 64bit Instalation Error: Hi, After installing oracle client (10.2.0.4) even thou I can connect to my database using SQL PLUS, on some applications I am getting the following error. Does anyone know what to do? Test connection failed because of an error in initializing provider. Oracle client and networking (...)
26 November 2008
Estimating effectivity of performance improvement measures: Today I have another question regarding estimating effectivity of changes. Situation: we have a query that accesses four tables, which result in 18 buffer gets per execution and 3 physical reads. The plan looks pretty good given the schema and query. This query is responsible for more (...)
26 November 2008
OUI in 9i for a database 10g: Hi, I installed 10.2.0.1 on AIX6 in a directory /logi/ora/1020, installation is OK but i saw a /logi/ora/920 created with some files about oui. Do you know how the directory was created and why ? The machine had ora 920 before something I forgot to delete ? Thanks in (...)
25 November 2008
Finding out the default tablespace: Hello out there, today I was wondering how to find out the default tablespace of an Oracle Database. The Version is 10.2.0.4. I looked in the docs and did a bit googling but did not came up with a result. It seems I'm too blind too find the right DBA- or V$-View that holds the (...)
25 November 2008
Blocks are not getting cache: Hi All - HP-UX 64bit, Oracle 9.2.0.5 We are facing this problem in one of our instance. This is 11i instance and near about 5TB. This query is running fine in of the development instance but in one instance it's taking much time. Same query is completing in less than a minute (...)
25 November 2008
problem creating tracefile level12: hello everyone, I'm trying to create a level 12 trace for a surtain process. After finding out the sid and serial, i try: exec dbms_system.set_ev (si=>19, se=>1423,ev=>10046,le=12,nm=>N ULL) or the above with the dbms_support.start_trace_in_se ssion( etc...) both (...)
24 November 2008
Using bind variables for multiple values: All, a bit of background: we have a stored procedure that needs to lock several rows via SELECT ... FOR UPDATE. Currently this stored procedure has a single VARCHAR2 argument which contains a comma separated list of integers (ids) and consequently uses EXECUTE IMMEDIATE. Since the (...)
24 November 2008
Free Girls Pictures,Chinese Girls Pictures,Russia Girls: Free Girls Pictures,Chinese Girls Pictures,Russia Girls Free Girls Picture [link] Chinese Girls Pictures [link] Russia Girls Pictures [link] Cartoon Girls Pictures [link] Non-mainstream Pictures
23 November 2008
migration from WE8ISO8859P1 to AR8MSWIN1256: Hi, I have a 9i database with WE8ISO8859P1 characterset, the database is supposed to hold Farsi characters (weird!!), so my client developers have coded a PLSQL function that converts any characters read from this database into a character from a non standard charset they had come up (...)
23 November 2008
FAST & EASY - ::: INSURANCE ::: allstate insurance: FAST & EASY - ::: INSURANCE ::: allstate insurance [link] [link]
23 November 2008
db_files setting on 10g: hi all: Recently, we move a oracle 9i DB up to a oracle 10g. Everything is nice, but i found a problem about a parameter db_files. when i set db_files to 65535, you can find yourself can not analyze / scan a big table on 10g, but on 9i will running smoothly. when i set this parameter (...)
23 November 2008
Antispam - Spam - Antispamapplication - Antispam appliance: AntiSpamAppliance.org. Related Searches: Anti Spam Appliances. Spam Gateway. Ironport Exchange ... [link]
22 November 2008
expdp very sllllllllloooooooooowwwww: I have a database with quite a few partition tables. Each of the tables has 751 partitions. In addition the tables have about 30millions rows each. Why would expdp be so slow it looks like i†'s not moving(status command). I use the parallel option. I've opened a SR with (...)
22 November 2008
RMAN restore of full backup fails completely: Hi, after searching for a hint to solve this problem for quite some time, I thought I might try it here to get help - I am a RMAN novice, so please excuse me seeming uninformed or plain dumb, but since this is a production problem posting instead of reading to even more material than I (...)
21 November 2008
oem grid control agent command line functionality: Have got em agent installed on windows 10.2.0.3 database I would like to invoke stop/start blackouts by scripts on the server rather than via central repository Can anyone advise on the steps that I need to follow thanks Chris (...)
21 November 2008
Chase credit cards HERE ALL: Chase Credit Cards & CreditCard Offers at CreditCardFlyers [link]
21 November 2008
COMPUTER FOR PEOPLE USE: which need for people. Web where you can find additional information Fact-filled, fun and totally free. Click below for more details: ****************************** ************** [link] [link] [link] ****************************** (...)
21 November 2008
I Need Oracle Server 7.1.6.2.0: Hi, Can anybody tell me where can I get the following software for windows? List of software: Oracle Server 7.1.6.2.0 SQL Forms 3.0 SQL Menu 5.0 SQL ReportWriter 1.1 Thanks in advance, NPita
21 November 2008
10g data pump question: Why is it that when I run a data pump operation with PARALLEL > 1, I only ever see one worker EXECUTING and the state for all the others is WORK WAITING? What would cause that? TIA
20 November 2008
Which rows cause exception: Oracle 9.2.05 SE In a stored procedure I have code like this: INSERT INTO DPRS_WELL (PRODUCTION_MONTH,UWI,....) SELECT ad_prod_date,UWI,... FROM DPRS_WELL_LOAD WHERE PRODUCTION_MONTH = add_months(ad_prod_date,-1); EXCEPTION WHEN DUP_VAL_ON_INDEX THEN (...)
20 November 2008
process running slowly, lots of yield() calls ?: We upgraded database from 9i to 10g at the weekend. One of the processes (whose statement basically consists of an "create table as select etc") is taking +7hrs and still running instead of the more usual 30 mins. OK, I would think that this is a statistics/explain- plan (...)
20 November 2008
Not able to connect as sysdba,shared memory error: One of our 8i server ran out of shared memory. I am getting following error and not even able to log in for shutting down conn "/ as sysdba" ERROR: ORA-00604: error occurred at recursive SQL level 2 ORA-04031: unable to allocate 4200 bytes of shared memory ("shared (...)
20 November 2008
move from UNDO_MANAGMENT=AUTO to MANUAL: Hi, Oracle 10.2.0.3 on Win 2003 Server We have an Oracle database running in automatic undo management. An application provider has to upgrade his application and needs the database running in manual undo management. I've never gone back to manual from auto ... could you give me (...)
20 November 2008
Ora 12899 error: Hi, I have got ora 12899 error in the database. My question is , the database for which i got this error , is working properly on one machine(computer) but the same database on another machine facing the ora 12899 error. How is it possible ? And what could be the reason? Plz help me (...)
20 November 2008
11.1.0.7 patchset experiences: We're running RAC cluster (Dell PowerEdge 1950s w/1 quad core/node) with Oracle11 on Linux Intel 5.2 64-bit and are considering the 11.1.0.7 upgrade. In the next few days the goal is to begin evaluating the upgrade in a test environment, but I'd be interested in finding out what (...)
20 November 2008
Oracle 10g / PHP / utf-8: Hi, I have installed the Oracle Database 10g Express Edition Release 10.2.0.1.0 on a Linux workstation for dev purposes, along with Apache 2 and PHP5. The production environment uses Unix for the Oracle database server, Win2003/IIS for the webserver. Our PHP application works with UTF-8 (...)
19 November 2008
DUPLICATE DATABASE and ORA-00235 error: Hi I am trying to run the duplicate database command, USING an rman catalog, but keep getting ORA-00235: controlfile fixed table inconsistent due to concurrent update How come ? this is the command I run : rman target sys/****@timsr5 catalog rman/rman@rman auxiliary / cmdfile (...)
19 November 2008
Re: execution plan: It should be irrelevant except should you run out of space. The size could affect speed but it should not affect the plan.
19 November 2008
Analyze tables+ind: Hi, I'd like to analyze one schema's all tables and indexes every night - should I implement a PL/SQL-procedure for this and add it to Database Control/Scheduler Jobs ? - there seems to some "gather stats"-jobs already but those are "smart-ones" and this one (...)
19 November 2008
temp tablespace: ORACLE 8i (we are in process of upgrading to 10g). UNIX solaris 5.8 (we are moving to new box). optimizer_mode = choose Does anyone know if the size of the temp tablespace is used to create an execution plan ? If we significantly increased its size, could the execution plan change ? (...)
18 November 2008
Urgent help needed. Datafile dropped from OS. Please help.: Hi all Somebody just dropped an Oracle datafile from OS commands in our development RAC. The tablespace isn't that important but i am afraid RAC may be down. Please suggest how can I get rid of this tablespace. I am on 10.2.0.4 RAC environment with two nodes, in noarchivelog mode. (...)
18 November 2008
Free mock tests @TechFaq360.com: Free mock tests @TechFaq360.com: [link]
18 November 2008
HELP DESK: HELP DESK [link]
18 November 2008
mysql "LOAD DATA" equivalent in Oracle?: I am using the query in MySql to import data from a tabular file: +++++++++++++++++++++ LOAD DATA LOCAL INFILE '/file1.tab' INTO TABLE table1 FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (column1, column2, column3); +++++++++++++++++++++ what is the (...)
18 November 2008
Re: Oracle 9i LIKE search assistance: You didn't actually try it did you.
18 November 2008
RMAN How to restore a single tablespace into a different host: Hi I am looking for a way to use RMAN to restore one tablespace into a DIFFERENT database/host. I know I can use RMAN transportable tablespace starting from 10.2 b ( and I have used it successfully ) , but I have a database operating on 10.1 as well as a 9i databases. How can this (...)
17 November 2008
Getting that first Oracel DBA job.: I finished writing an article for new DBA's that are trying to get that first Oracle DBA job. I remember how tough it was so I thought I would share what I learned. You can read the article by going to: [link] Let me know what you think of it, I would love to hear what (...)
17 November 2008
Oracle 10g XE with SQL Developer: First of all my background. I was a software developer from 1975 until the late 1990s. I developed software on OpenVMS systems eventually writing code to interface to Oracle, Ingres, Rdb, Sybase, Progress, and Interbase databases. With Oracle I used the Oracle Call Interface. With the (...)
17 November 2008
ora-12545 reported from oracle 10g RAC under HP Unix 11i: Hi We recently migrated to oracle10g ver 2 RAC under HP Unix 11i from oracle9i clustered environment under HP Tru64 unix. From the time we migrated we have been having client connectivity problem. It is very unstable with clients often getting ORA-12545 error "connection failed (...)
16 November 2008
ASO - how to verify that traffic is encrypted: Hi, I have set up ASO 10g. How do I verify that the traffic is encrypted in Sqlnet:1521? I'm using RedHat AS4. thanks.
16 November 2008
How to speed up this: Hi, Have you any hint to speed up the query below ? (oracle 9.2.0.6) Thanks in advance call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 581 0.45 0.43 0 0 (...)
15 November 2008
View from CLOB chunks: Hello, Is it possible to creare a view that will split single CLOB column into multiple chunks of VARCHAR2 something like this: TABLE: --------------------------- ID INTEGER DATA CLOB into VIEW: ------------------------------ -------------------- ID INTEGER CHUNK_ID INTEGER (...)
14 November 2008
"between" vs. ">= and <=": Hi, a client of us requested to replace ">= and <=" with "between" with a TIMESTAMP column. Unfortunately I am still waiting for his justification... In the meantime I thought I do some researching. Personally I cannot think of any reason why one or the other (...)
14 November 2008
Re: Request that loses indexes: So once per day the SQL plans behind the stored procedure go to lunch by all of a sudden not using the indexes. The following would be helpful The full Oracle version. The good and bad explain plans for the statement in question. When the query goes bad is the input to the procedure (...)
14 November 2008
Cartier Santos Two-Tone 18kt Yellow Gold and Steel Ladies Watch W20012C4 Collection: Cartier Santos Two-Tone 18kt Yellow Gold and Steel Ladies Watch W20012C4 Collection Watches Collection Site : [link] Cartier Santos Two-Tone 18kt Yellow Gold and Steel Ladies Watch W20012C4 View Full : [link]
14 November 2008
Query Execution Time: Hi, I am using both 9i/10g. I am checking the performance of a query, so i have 2 queries, one before change and one after changing the query. Let the testing environment be any of these sql*plus / sqltools / toad / oracle sql developer. The problem here is that: when i executed (...)
14 November 2008
Tissot PRS200 Steel Chronograph Mens Watch T17.1.486.34 Collection: Tissot PRS200 Steel Chronograph Mens Watch T17.1.486.34 Collection Watches Collection Site : [link] Tissot PRS200 Steel Chronograph Mens Watch T17.1.486.34 View Full : [link] Tissot PRS200 Steel Chronograph Mens Watch (...)
14 November 2008
anyone have a decent purge script for 11g diag directories: Not only do we have the standard .trc files there are now .trm files and probably various other things. Maybe I am missing some basic concept like some parameter to set or utility to use so that 11g databases will clean out and delete stuff after a certain date in the diag structure. (...)
14 November 2008
DBMS_LOB.SUBSTR failed to retrieve 4000 characters: Hello, Oracle throws the error when trying to retrieve first 4000 characters from a CLOB column SELECT DBMS_LOB.SUBSTR(clob_column,40 00, 1) FROM tbl ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 Depends on the row it works fine (...)
13 November 2008
Materialized View: New column in master table is not replicated: Hello NG! I created this Materialized View to replicate a table to another database: CREATE MATERIALIZED VIEW MyTblName TABLESPACE MyTblSpace REFRESH FAST AS SELECT * FROM MyTblName@l_source; Anything works fine! Now I added a new column "Field4" to the master table in the (...)
13 November 2008
Import Data Into Table With ORA-01578 Error: Hi, We have a case, in Windows (9i), of "ORA-01578: ORACLE data block corrupted (file # x, block # y)". We know the table which this affects, as well as the primary keys of the records stored in this block and file. (For the purposes of this post, say, table A, keys PK1 (...)
13 November 2008
cheap wholesale dunk shoes and air force 1st: cheap sell dunk sb low dunk mid dunk sb high sell dunk shoes for men , women, kid dunk shoes for china discount sale air force one our webiste: [link] [link] paypal shoes 25 years ? Remove jordan kids ? Remove and1 ? Remove air jordan 1 ? (...)
13 November 2008
new dba blog: [link]
13 November 2008
ORA-00600 when using SELECT UNION and PUBLIC SYNONYM: problem summary: I am having problems with "PUBLIC SYNONYM" in UNION statement, which cause a crash, but if I rename the "PUBLIC SYNONYM" it works. Any ideas? Full Question: After an upgrade from 10g to 11g I get a ora-600 error when I do the following statement: (...)
13 November 2008
Drop database on Oracle 9i: As you may understand I'm new to Oracle :-) But I wish to drop a database on Oracle 9i, but cannot find a 'drop database' command, like I find in versjon 10g. How can I drop my database? This is on Solaris, and I cannot use any GUI tools (...)
13 November 2008
performance question: I have a QA and PROD server and has loaded identical Oracle DB 10 i. This query runs fast on (10 Minutes) QA and slow on (3 hours) PROD. The servers are Red hat Linux. INSERT INTO xyz_ime_candidate (proj_key, xref_item_key, xyz_prod_key, match_type, (...)
12 November 2008
Query Tuning: Hi All, One developer wrote this SQL for Oracle E-Biz vision DB, but it's taking hours to fetch the data. I did last query tuning 4-5 years ago. Any pointer would be appreciated: EXPLAIN PLAN SET STATEMENT_ID = 'ABC' FOR SELECT COUNT(1) FROM OE_ORDER_HEADERS_ALL OOHA WHERE (...)
12 November 2008
do desc on tables, dump output to text file: As per the subject line, I have a comma seperated list of table names. Not every table necessarily exists but they most probably do, I want to run desc on each one of them and catch the output into a text file. Part of my reasons for doing what is probably a much simpler operation via (...)
12 November 2008
How to change the tablespace of a subpartitioned partition: I have a subpartitioned table with an undesired value for the tablespace of the partitions. How do I change those? I tried to MOVE them, but that is not allowed (ora-14257), because the table is subpartitioned. I tried to MODIFY then, but that is not a valid syntax. My version is (...)
12 November 2008
how to determined the recover start point when oracle crash: Sometimes ,if oracle crash(mediea or instance level) ,we must implement some recover . As every one knows ,there are vary SCN in oracle,just like start scn, stop scn ,block scn etc... How oracle determined which SCN is the recover start scn?and witch is finall scn? anybody know (...)
12 November 2008
Oem windows 2003 issues: We have a situation over here. We uninstalled oracle enterprise manager from one box completely and our production environment still looking for that old EM for some reason. We used to schedule our nightly backup job using this repository but we no longer use this. Is there a step that (...)
11 November 2008
Oracle 11g and v$session information: Hi, I have a (Java) application that supplies the application information by setting connection properties to populate the v$session stuff using connection properties <[link]>
11 November 2008
Are there performancebenefits to reorganizing database-using export/import?: I am using Oracle 9.2.0.5 on HP UNIX 11i. Since it is a production system, I cannot change version of Oracle any time soon, so please do not suggest that. I have a production database using Oracle 9.2.0.5, which has been running for last 3 years since it was upgraded from 8.1.7. At that (...)
10 November 2008
estimate memory usage on linux: does anyone have a document handy (or metalink note bookmarked) on estimating memory usage on linux and seeing actual memory usage (primarily sga_max_size + session details).. session details are always fuzzy. oracle is 10.2.0.3 linux is rh4 ....... We run Oracle 9iR2,10gR2, (...)
10 November 2008
Why Oracle does not allow rollback of DDL statements?: I have always been surprised why Oracle does a implicit commit when DDL statements (e.g create table …) are executed. DDL statements simply write information (insert, delete and update) to data dictionary, so why DDL statement cannot be rolled back. Am I missing some thing? I (...)
10 November 2008
Does Oracle have anything like SAP Business Intelligence Accelerator?: Being Oracle Developer and DBA for many years, I was really intrigued by SAP’s Business Intelligence Accelerator (BIA). [link] You can google to get more information about BIA. SAP BIA is said to improve performance of Adahoc queries on data warehouses by 10 to 100. BIA stores (...)
8 November 2008
Oracle SQL SELECT using SHA-1 HASH function: Folks, Is there a way to perform this kind of SQL select command? SELECT id FROM user WHERE password = SHA1('secret'); I have been searching, but it does not appear this is a built in Oracle function. I am looking from some function that works for version Oracle 9 and above. (...)
8 November 2008
How to get all the archive logs in a backup piece: Is there any way I can get all the archive log files present in a backup piece. I tried following but it always gives me all the log files for each piece: **** SQL> select s.set_stamp, s.set_count, s.PIECES, s.backup_type, s.controlfile_included from v$backup_set s, v$backup_piece (...)
8 November 2008
recover data: hi all, i'm running in a trouble because the raid container where my /oradata (windows 2003 with oracle 9.2.0.1) was installed failed (of corse no backup, n odump, nothing at all..it was too easy). We sent the disks to a recover company and they sent me back 12 files (called from (...)
8 November 2008
can we delete .patch_storage: Dear group, Could somebody tell me what is stored in .patch_storage under OH? It is getting bigger now, will it hurt if I delete this directory? Thanks for your help Thanks
7 November 2008
Tablespace Usage and Performance: Oracle 10g 10.2.0.3 Windows 2003 Server I have someone who made the following statement: "any time a tablespace is > 85% [ of capacity ] we experience performance degragation". Is there any validity in that or not? (...)
7 November 2008
Help: how to update a table with a value from Stored procedure: Dear Group, We have a third party supplied package which we do not want to change. I would like to update a table with a value from the procedure. I can use PL/SQL to do that. But our tool does not support PL/SQL, i have to use SQL. Something like SQL> var res varchar2(30) (...)
6 November 2008
When a Column/Field was Added to a Table: I'm trying to create a report that will tell me what new fields are added to a database by software patches. I'd like to be able to run the report after applying the patches, and have the report give me the new fields that were added. Does Oracle store the date that a new column (...)
6 November 2008
Oracle user attributes: How can I find out a users attributes: 1. Grants currently assigned to user 2. Users default and temporary tablespace
6 November 2008
ora-03232: ORACLE 8i (we are in process of upgrading to 10g). UNIX solaris 5.8 (we are moving to new box). We recovered our production database in our current environment with RMAN. We started getting ORA-25153. We added the old tempfile to the temporary tablespace and resized it at the same (...)
6 November 2008
Materialized View - Performance: Hi, I am using Oracle 10g. Please answer my doubts regarding Materialized Views ( MV ) : 1. if we give the option 'enable query rewrite' option, while creating MV, will the optimizer do automatic query rewriting and optimize the MV ? 2. Can i use WITH Clause in a MV ? 3. I (...)
6 November 2008
Listener easy question: Hello it's clear that default listener is listener_name listener and port number 1521 is the definition of a default listener only the port number or only the listener name or strict both listener and 1521 all together? Greetings (...)
6 November 2008
Windows Clustering and FailSafe???: Anybody out there using Windows clustering service and Oracle Fail Safe running 10g or 11g? RAC is just too expensive for us so we are looking at this solution but we know very little about it. For one does it support a active/active solution where both nodes can share the load of one (...)
5 November 2008
Can Oracle use Multiple indexes at once on a single table?: Dear Experts, Can Oracle use Multiple indexes at once on a single table? Say we make a single table with multiple indexes on it. A single field index on Field_A. Another index on Field_B. Another index on Field_C. And we do a query on the one table, and have filter conditions on (...)
5 November 2008
Character set for exp/imp: HI, I have to migrate a database WE8ISO8859P1 (8i) to to another database AL32UTF8 (9i) I did an export with NLS_LANG=.WE8ISO8859P1 what is the right NLS_LANG to do the import ? when I tried the import with WE8ISO8859P1 or AL32UTF8 I got a warnings about conversion. what is the (...)
5 November 2008
changing nls parameters on database level: Hi, I've got a question regardins nls-settings on a 10g database. These are the settings for NLS_TERRITORY on instance, database and session level: select * from nls_session_parameters where parameter='NLS_TERRITORY' PARAMETER VALUE NLS_TERRITORY GERMANY select * from (...)
5 November 2008
log file sync vs log file parallel write probably not bug 2669566: This is a continuation of a previous thread about ‘log file sync’ and ‘log file parallel write’ events. Version : 9.2.0.8 Platform : Solaris Application : Oracle Apps The number of commits per second ranges between 10 and 30. When querying statspack (...)
5 November 2008
How to add an entry to TNSNAMES.ORA?: Hello, if I add the following entry to the TNSNAMES.ORA: test1_10.121.34.56 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.121.34.56)(PORT = 1521)) ) (CONNECT_DATA = (SID = test1) (SERVER = DEDICATED) ) ) how could I activate it please without (...)
5 November 2008
DBMS_ERRLOG.CREATE_ERROR_LOG: Hi all, If a logging table is created using the above function call, how are changes to structure of the underlying tabel (the one on with the logging table is based handled. i.e. if a column is added, dropped or modified does this change cascade through to the error logging table? (...)
5 November 2008
document tables and columns used in arbitrary sql-statements: hi, a collegue of mine came up with an interesting question: he wants to document all tables/columns used in sql-statements. doing this manuallly is cumbersome as this statements tend to be very large. i wonder if it is possible querying oracle's system tables to get this (...)
5 November 2008
With Clause: Hi, I had a look at the usage of WITH Clause, where a repeated subquery can be replaced using WITH clause which reduces the complexity of the query. Apart from this, i was not able to find anything regarding WITH Clause. Please reply to my doubts on WITH Clause : 1. Apart from (...)
5 November 2008
AWR Sample Report: Hi, I have a small part ( output ) of AWR Report. Can anyone help me on this, to interpret the AWR Output... Snap Id Snap Time Sessions Cursors/Session Begin Snap: 8193 17-Oct-08 16:00:54 90 62.7 End Snap: 8194 17-Oct-08 16:01:26 89 63.4 Elapsed: 0.52 (mins) DB Time: 1.63 (mins) (...)
5 November 2008
What is an edition?: Server is 11.1.0.7 on Linux/x86. I noticed processes sometimes holding an "edition lock" on object ORA$BASE. The V$LOCK_TYPE table says the following: "Prevent Dropping an edition in use ". To make things even more confusing, there is a very well hidden view named (...)
4 November 2008
direct path read (temp) 31 blocks per event: Version 11.1.0.6 Platform: Linux During a performance test I noticed the that 'direct path read temp' where done with 31 blocks and sometimes with 1 block per wait. The 'db file scattered read' 's where done with 128 blocks per wait (db_file_multiblock_read_count (...)
4 November 2008
Multi Partition Types: Hi, I want to partition my Orders table which is usually queried on three columns I am using Oracle 9i and the shortened table is Order (Date, RegionID, ProductCategory) Can i apply Range partitioning on all three columns? if yes then how data will be distributed? Can i apply (...)
4 November 2008
Oracle 10g silent installation issue on Vista: I have created a response file to make silent installation of Oracle 10g client on windows vista PC. The installation did not show me any errors. However it did not install all the products. When i installed it on XP it installed 44 products. Whereas when i installed on Vista it (...)
4 November 2008
3 table outer join with where caluse colc='P' question: I have distilled my question down to this. I have three table and I normally query tables x and y to get my passed results something like select x.cola,x.colb,y.colc from x,y where x.cola=y.cola and y.colc = 'P'; COLA COLB C ---------- ----- - 1 A P 2 B P 4 D (...)
4 November 2008
Query Table Name: If you are joining one or more tables, is there a way to know which table the value came from? For example: SELECT DISTINCT(id), DECODE(<table_name>,value,<tab le_name>,value,<table_name>,va lue)........ FROM a, b, c WHERE a.id = b.id AND a.id = c.id; In this (...)
3 November 2008
11g Enterprise Manager Performance Tab Not Working: We purchased Oracle Standard Edition. I noticed that in Enterprise Manager that I can't click on the Performance tab (no clickable link). I can click on the Home, Availability, Server, Schema, Data Movement, and Software and Support tabs. I am logged in as a user with sysdba (...)
3 November 2008
Peoplesoft Evaluation - RFP Information: We were discussing government agency sizes when selecting the operating system (UNIX -vs- Windows) to support PeopleSoft applications. What factors (other than employee size) determined whether the implementation was considered small, medium or large? Were other factors considered (# of (...)
3 November 2008
Implementation of 11g parameter MEMORY_TARGET on UNIX: Hi All, 11g introduced new parameter MEMORY_TARGET which is sum of SGA + PGA. Oracle manuals state that the database dynamically re-distributes memory between SGA and PGA as needed. Question: how is it implemented on UNIX platform taking into account that: - SGA is one or several (...)
3 November 2008
FREE SOFTWARE NEWS: [link]
2 November 2008
** Boobie Breast Plate ARmOr Body Armor ProTecTor Video ***: Virginia Chicks Naked! - [link] Download exclusive test video of women taking bullets with their transparent body armor!! Watch the video and pics free downloads
2 November 2008
fuzzy hot backup: Hi, I'm trying to do a restore/recover to a point in time from a hot backup in 10.2. When I opened (reset log) the database, it complained that datafile 1 was fuzzy. What view can I use to check which datafile has a different checkpoint scn or what the issue is? I ran the (...)
31 October 2008
Filling in "gaps" in data: Oracle 10g R2 10.2.0.1.0 Hi I posted (couple of weeks ago) on this (as a sub-thread) but wanted to ask it here with some clarity. Say we have a table with date/time related data create table hits (date_time date, ip_address varchar2(240)); And our data look like this: (...)
31 October 2008
return all base objects referenced by a cursor?: Hi, Its been a slow day at work, and I had a thought to write a bit of sql to return the list of indexes, last time analyzed, and num_rows for a given cursor. I initially thought about using the join and split pl/sql functions available on the web to take sql_text and parse it to (...)
31 October 2008
Multiple name spaces in XML Query fails with "nonexistent LOB value": If this query (at the end of the post) is changed to return just one of the extractvalue (or extract) columns it works. Add a second one and it fails with a nonexistent LOB value error. Am I losing my mind or is something wrong with the parser? Thus: SELECT extractvalue(VALUE(t), (...)
31 October 2008
xmltype column and schema validation broken on xs:choice elements: I have a problem with schema validation on table with xmltype column. I have very simple schema: "X" root element with one of the "A" or "B" child. BEGIN DBMS_XMLSCHEMA.registerSchema( schemaURL => '/schemas/test', schemaDoc => (...)
31 October 2008
Oracle DataPump: Situation: The QA department performs oracle exp/imp from one oracle server to another- this is done from a central client where the oracle client software is installed and there is no need to have physical access to the oracle database server. Is there a way to perform datapump (...)
30 October 2008
SQL*Net message to client: Hi, the query below waits a lot of time on "SQL*Net message to client" (20/30 min) and after on "latch free " do you know why ? Thanks in advance Oracle 9.2.0.6 bind 97: dty=2 mxl=22(02) mal=00 scl=00 pre=00 oacflg=10 oacfl2=100 size=24 offset=0 (...)
30 October 2008
64G file limit on ASM: Is there are an existing monitor in Grid that would alert us of that? Thnx. ....... We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc) We use RMAN and remote catalog for backups
30 October 2008
SEGMENT SPACE MANAGEMENT AUTO: How do I set the SSM to auto for the SYSTEM tablespace (EXTENT MANAGEMENT LOCAL) when creating a new database in 10.2.0.3?
30 October 2008
RH Server puking when RMAN is writing to NFS and NFS goes down: Anyone seen this? Any clue? ....... We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc) We use RMAN and remote catalog for backups
30 October 2008
Puzzeling error with package: Hi All, today I ran into an 'interesting' problem and wanted to ask for advice/feedback from others as I am having problems understanding how it occured. The platform is Oracle 10.2.0.3 running on 64bit Linux in a RAC configuration. I have a package which in the (...)
30 October 2008
Oracle 9i-10g init.ora parameters: Hi, I have a database, which was recently migrated from 9i to 10g. Current Version : 10.2.0.3.0 I checked some of the init.ora parameters in current 10g database. They were as follows : optimizer_mode : choose statistics_level : typical timed_statistics : TRUE From the above (...)
30 October 2008
comptech: Complete Internet Protection With Automatic Virus Removal. Prevents virus infection from Email,Internet,Network,File execution/copying ... Click below for more details ****************************** ********* [link] [link] [link] (...)
30 October 2008
please refresh my memory on ora-12514: Created a 10GR2 dev db, created the db by restoring database files from prod offline user backup, recreated control files and set database to ivcust50 Now, when originally creating the database, used the name ivcust502 for all of the names, and it truncated it to ivcust50 for the (...)
29 October 2008
Oracle 10g Temporary Tablespace OCA Question: Hello a OCA question!!! A system tablespace can have a dictionary management or a local management. is it true that in case of a local management of the SYSTEM tablespace the creation of a temporary tablespace is mandatory?
29 October 2008
Reverse query to find Foreign Key: I have a ID primary key that is used across many tables as fk, I want to find a sql (run as sysadmin) that can find all tables who have that id as fk and change it to something else, maintaining all constraints and ref integrity etc. i.e. I want to change the fk value in all tables to (...)
29 October 2008
FREE SOFTWARE: [link]
29 October 2008
Oracle Left Outer Join problem - first occurance of a match: I am trying to left outer join to a table with mismatched results... let me explain Table: first_names id first 1 Tom 2 Mike 3 Jack Table: last_names id last 1 Jones 2 Smith 2 Smiths When I query the tables here is what I get SELECT a.id, a.first, b.last FROM (...)
28 October 2008
Oracle Left Outer Join problem: I am trying to do a left outer join with mismatched tables and want to just pull the first occurance... Let me explain Table: first_names id first 1 Tom 2 Mike 3 Tony Table: last_names id last 1 jones 2 jennings (...)
28 October 2008
Standby db Real Time Apply (10gR2): Hi, I started Real Time Apply using the "using current logfile disconnect" clause. It appeared that Real Time Apply was started successfully in the alert.log. "Managed Standby Recovery starting Real Time Apply parallel recovery started with 2 processes" But (...)
28 October 2008
Oracle Designer 2000: Oracle used to have a CASE tool named "Oracle Designer 2000". Does anybody know what has happened to that tool? Was it discontinued? If it wasn't, what is the name of the follow-on product?
28 October 2008
Tool for CSV dump?: Hi experts, are there tools to make a fast dump of complete databases to CSV? Without needing any additional licenses from Oracle...? TIA Tellie
28 October 2008
VB - API call to execute procedure, not using bind variables?: We are executing the below statement through a visual basic API and it's executing the SP with the literal values instead of bind variables, thus filling up our library cache with multiple unique statements and hard parsing over and over and over again... Does anyone know how we can (...)
27 October 2008
Two tables are quite the same, but size of theirs ORA datafiles are different!: I've got two tables in Oracle 10.1g, Windows 2003. TableA 16,594,824 records CREATE TABLE TableA ( NUMDLE NCHAR(8) NOT NULL, DIGVER NCHAR(1) NOT NULL, NUMLIB NCHAR(6) NOT NULL, CODDEP NCHAR(2) NOT NULL,
27 October 2008
Inserting records into table makes UNDOTBS1 very big: Hello Experts, I've got two tables in Oracle 10.1g TableA 16,594,824 records TableB 0 records, same structure as TableA I don't have too much free space in my disk, so I need to get tablespace UNDOTBS1 as small as possible. When I try to insert the 16 millions rows of (...)
27 October 2008
11g or not to 11g ?: Hello, we are currently in a project for setting up a new production environment, based on EMC documentum and as backend oracle. What are pros and cons for using the 11g ? Do you have any experiences, good as bad, with the new release of oracle ? Thanks for your opinion. Regards (...)
27 October 2008
database auditing: Hi, I have lately turned on database auditing (audit_trail=db and audit_sys_operations=true) but didn't activate any auditing options (no records in sys.aud$). From this time I see that 'current open cursors' statistic have increased about 20% and average system load is (...)
27 October 2008
dbms_stats no invalidate Parameter: dbms_stats.gather_schema_stats (.., no invalidate=>FALSE, …) I am on 10.2.0.4 on HP UNIX. I am trying to understand the pupose of no_invalidate parameter. It is my understanding that default value of this parameter used to be FALSE, but in Oracle 10g it is AUTO_INVAIDATE i.e., (...)
25 October 2008
dbms_stats no_invalidate parameter: dbms_stats.gather_schema_stats (.., no invalidate=>FALSE, …) I am on 10.2.0.4 on HP UNIX. I am trying to understand the pupose of no_invalidate parameter. It is my understanding that default value of this parameter used to be FALSE, but in Oracle 10g it is AUTO_INVAIDATE i.e., (...)
25 October 2008
oracle: Oracle9i: New Features for Administrators [link] ooracle see [link] oracle interview questions 1 [link]
25 October 2008
Which Oracle book was this?: Years ago, I skimmed an Oracle book at the bookstore. I'm sure it was written by Tom Kyte. In it, he critiqued a system that would store data in rows, instead of simple columns! One criticism being that it performed very badly. So, instead of a typical table structure: field1 (...)
25 October 2008
Initialization Error: Failed to read POST response: Guys, I need some help, I am cloning ,my PROD DB to a test environment, I did first using my test database and it worked, but running with my PROD failed. I am using OEMGrid Control, Wind2003, DBOracle9i, I am trying to connect using OEMGC and when start trasnfering "One (...)
24 October 2008
Data Guard 10g: RAC switchover to single instance: Hi, I have a 2-node primary RAC and a single physical standby instance. If I perform a switchover, I would like to know what's the new configuration will be: 1) single primary instance and single standby instance or 2) single primary instance and 2-node standby instance I (...)
24 October 2008
set_session_longops in perl: I've posted this in the perl group also, but not really sure which group would be better to get an answer from. Is it possible to use dbms_application_info.set_sess ion_longops for 10.2.0.2 in a code loop of a perl script? I've only seen it used in pl/sql loops and I'm (...)
24 October 2008
Strange sequence of error messages during recovery: Hi, I am trying to do an incomplete recovery as follows: "alter database recover automatic from 'C:\logsdir' using backup controlfile until change 2192315;" which results in the following error messages: ---- ERROR at line 1: ORA-00279: change 2169480 generated (...)
24 October 2008
Need help with query in Oracle 8.1.7: I have an older database system which I have inherited and need to extract some data on. I am having trouble with a query. The query in question runs against a table with five columns: Primary key: FACID CHAR(10) DEPTID CHAR(5) Additional columns: CENUPD DATE CENUPT CHAR(8) (...)
24 October 2008
IN/NOT IN Parsing: I'd never noticed until today that Oracle doesn't check if columns used in an in/not in clause are valid. Is this common knowledge that I've somehow missed out on? Strikes me as being very dangerous as you could typo a column name & never know about it - at least not (...)
24 October 2008
Question re e-business suite integration: Hi slightly OT I know but where would you start if you were considering integrating your app with the Oracle E-Business Suite? Looking to understand their support for 3rd party apps, utilising their authentication and running alongside their own apps in the same instance. Where would (...)
24 October 2008
oracle books: Oracle9i: New Features for Administrators [link] ooracle see [link] oracle interview questions 1 [link]
23 October 2008
ACL with roles.: 11.1.0.6.0 on Vista 64 Ultimate. I've created a new ACL, assigned a host & added a privilege for a role, and can now do a utl_http.request when logged in as a user with that role. However if I put the utl_http.request in a procedure & try to run that, it fails with (...)
23 October 2008
Upgrading OAS: Is there an Oracle document that gives the steps needing to be done to upgrade to a newer version of OAS? Robert
23 October 2008
ORACLE_BASE and $ORACLE_HOME: Hi In the past I recall using both $ORACLE_BASE and $ORACLE_HOME, but when reading Administrator's Guide 10g Release 1 (10.1) Part No. B10739-01 I find that it suggests ORACLE_BASE is only windows platform. the manual states: This release complies with Optimal Flexible (...)
23 October 2008
Is it safe to rebuild an index during an RMAN full backup?: My database is used most heavily between 06:00 and 20:00. An RMAN full backup runs nightly from 20:00 to 23:00. If I execute command "alter index <name> rebuild online;" during the backup will that cause a problem? Thank you, (...)
22 October 2008
Oracle Expressions: Hi, i am having a doubt considering what is a proper oracle expression. [link] In the select referene, there is a number of times where the expr statemnt appears. I am trying to figure out what an expr is: is it simply a sequence of Varibles, Constants, function and (...)
22 October 2008
Oracle Model Operator - Question: Hello, I've been trying to use the model operator, but although this operator could have the potential for what I want, the way it ends up working seems to be too simplistic. I'd like some help figuring out if what I'd like to a chieve is simple impossible for now, or if (...)
22 October 2008
PLS-00103 Encountered the symbol CREATE: Please help, I amd trying to create a script for patching the database. the script works with INSERT or SELECT, but when i try to execute a package (*pkb). I get an error: "PLS-00103 Encountered the symbol CREATE when expecting on of the following: begin ...." The logic is (...)
22 October 2008
system update: I've found an oracle bug (NOTE:731599.1) which may affect my system. The workaround is to update glibc library. Can I do that without any risk (this is production system) ? thanks
21 October 2008
How to read parent session data - without forcing a commit in the parent: Hi Folks, I have an interesting problem. Basically, I have an oracle job that I need to speed up as we are exceeding our allocated time window. The oracle job consists of a large number of small changes across multiple 'source' tables and then one of my functions is called to (...)
21 October 2008
OEM agent problem ping Ser1(OEM) - > Ser2 -> Ser3(DB): hi All, I have this strange problem, but anyone please help me in it. I have three server... server1 can ping server2 and server2 can ping and connect on server3.. now I have OEM grid control installed on server1 and database install on server3.. is there any way I can monitor (...)
21 October 2008
Location Intelligence, the mashup of GIS and Business Intelligence: Location Intelligence, the mashup of GIS and Business Intelligence (GIS) A Business Intelligence (BI) system enables better decision making by combining the extraction, analysis and presentation of business information. It typically consists of a web browser dashboard that provides a (...)
21 October 2008
http://www.pass4exams.com with best quality/price of Oracle exam dumps: [link] is the best website for IT certification resources, $25 only for each exam: 1. 100% cover and pass for sure guranteed. 2. always the latest questions and answers with the best quality. 3. $25 for each exam questions & answers, best value/price. Same product, only 1/5 price (...)
21 October 2008
ORACLE SILENT MODE INSTALLATION: You can automate the installation and configuration of Oracle software, either fully or partially, by specifying a response file when you start the Oracle Universal Installer. The Installer uses the values contained in the response file to provide answers to some or all of the Installer (...)
21 October 2008
Very Large Database, dont know what my options are: Hi, Im a newbie DBA and a little bit stuck with a problem with an Oracle Database and I would appreciate your help. I have a database of billions of records. I need to dump a set of data for investigation. I was using SELECT * OUTFILE... Because of the size of the DB and lack of (...)
21 October 2008
Combining snapclones with DataGuard: I read quotes from Ari Kaplan explaining how enterprises if possible should (if possible and appropriate) combine the use of snapclones (for SAN-to-SAN replication) with DataGuard. I am confused how an organization could use both of these though. If I am using snapclones, how can I also (...)
20 October 2008
How to restore to a new database: Hi All, I have a cold RMAN backup (2 pieces - the main body and the controlfile piece) from another server. My mission is to recreate / restore it to a new server under new db name. Connectivity to the other server does not exists as this is from a customer's site. Environment (...)
20 October 2008
left a database in recover mode, why is it not recognizing archive logs now?: I cloned a 10G database last thursday from an user managed online backup, rebuilt the control files, started up nomount and did the recover until cancel after copying over archivelogs from the production database the online backup was taken from. I left the database in this state, then (...)
20 October 2008
^^ Army Introduces Hot Plating Breast Armor Plates ^^: [link] Particulary desined to protect womens breasts watch video of these plating protect against a gun shot.
20 October 2008
Going mad - outer join problem: Oracle 10g 10.2.0.1.0 Take two tables A and B. ** ensure you don't have a table A and B before running the following! drop table a; drop table b; create table A (id number, name varchar2(10)); create table B (id number, code varchar2(10), descrip varchar2(10)); (...)
19 October 2008
How is the best way to send data from local database into remote database ?: Hi gurus, I need to send data and receive data from local Oracle database into remote oracle database. Both sites connected via 128 kbps frame relay connection. The send and receive is as follow : - RECEIVE Customers data from remote Database -> this to be done if there is new or (...)
19 October 2008
### Hot Naked Army Chicks Firing Guns: Download [link] - hot video pics and more.
18 October 2008
insert values in a table using procedures: I have 3 tables i.e. SQL> desc sales; Name Null? Type ------------------------------ ----------- -------- ---------------- PROD_ID NOT NULL NUMBER(6) CUST_ID NOT NULL NUMBER TIME_ID NOT NULL DATE
18 October 2008
Eliminating Rows In Complex Query: Hi, been on this for more than 3 days. In the below query I am looking to look at each group of orders for each customer. Within that I only want the product type of 197 which is coded. What I want to do next is to eliminate any groups or partitions that contain an 'Active' (...)
17 October 2008
FREE ONLINE TEST at http://www.yfrindia.com/resources/Tests : DATA STRUCTURE, OPERATING SYSTEM, COMPUTER NETWORK, JAVA, .NET, C, C++, MANY MORE: Dear Friend, Preparing to GET A JOB? Applying for a competitive exam? Heading for GATE, CAT, XAT, MAT, TOEFL, GRE? Want to clear a certification, like MCP, SCJP? We have solution to all your answers. YFRIndia.com presents you a new approach in online education for all your preparation (...)
17 October 2008
Update trigger: hi, I need to write a history record for certain fields that change on a table. I am not sure whether it is better to write a single AFTER UPDATE OF column1,column2,column3 etc trigger that then uses if statements to check each specific field whether it has changed OR to create an (...)
17 October 2008
Firewall?: Hi! It is interesting to know, is there companies at the market offers Oracle RDBMS specific firewalls. Please drop me a note to climber....@gmail.com, if this information is not suitable to this newsgroup.
17 October 2008
Server unexpect shutdown: Hi all. Help me please! what is may be ? SYSTEM REDHAT 4 uname -a Linux edw1 2.6.9-67.0.0.0.1.ELsmp #1 SMP Sun Nov 18 01:06:10 EST 2007 x86_64 x86_64 x86_64 GNU/Linux Oracle 10.2.0.4 I`m look in all log files. once suspected in dmesg ACPI: Processor [CPU0] (supports C1) (...)
17 October 2008
Oracle 10g AWR Report - Analysis/Interpretation: Hi, I am using oracle 10g, i want to know how to interpret the AWR Report. I searched in google, but cant find any documents on it. Could any one please help me on it, any documents/URLs regarding the interpretation of AWR Report would be helpful to me. Thanks in Advance. With (...)
16 October 2008
Indexing pdf/doc file contents AND other text data: Hello, I am indexing the text from some pdfs and doc files uploaded by the user. This is easy enough to do with CREATE INDEX file_index ON reports(file_path) INDEXTYPE IS ctxsys.context PARAMETERS ('datastore ctxsys.file_datastore format column file_path') However, I would (...)
16 October 2008
import/export: Hi, i have 2 Oracle 10.2 Servers, both linux. Now i want to "copy" a schema from one database to the other. Whats the easiest way? - expdp / impdp? - database link? - other way ? a good howto for a non database expert would be (...)
16 October 2008
quest spootlight and changind default orahome: Hello! In subject how can i do this? Becouse if i have two orahome with Oracle 9 and Oralce 10 a need to coonect to specify database by usig specify orahome how can i chenge it in Spootligth? Regards MJ
16 October 2008
Oracle Certification - Suggestion: Hi, I have already completed oracle 9i oca - developer track by completing 007, 047. Now i am moving into dba track. can i proceed with oracle 9i oca - dba track by completing 031 ? (or) can i proceed with oracle 10g oca - dba track by completing 042 ( am i correct ) ? I (...)
16 October 2008
LOB Segments: As I understand it oracle tables link the LOB column to a a LOB segment that actually stores the LOB. My question is when you archive/export/delete/etc. that table does that also affect the LOB segment? So, in other words if you archived it would that also archive the LOB segments? My (...)
15 October 2008
Reviews of Certification study material - where?: Does anyone know of any Websites that have reviews of certification study material? ex, self study softwate, measure up, crammaster, etc. Also, what do you read to keep abreast of the most maketable IT skills in the US (...)
15 October 2008
Opening at USA!!: Hello All, If you are interested for any of the position of the below position please mention the Job Number and send the updated profile to sow...@datadynamicssytems.com Job #258: Test Engineer, IP network testing Additional Keywords: - IP networking - BGP - (...)
15 October 2008
Oracle Heterogeneous Services: Hi! What is best driver to make Heterogenous services to sqlServer2005 Linux platform, 9.2.0.8 Any advices? Jack
15 October 2008
UTL_FILE Permissions: Peace all, I am working with an application which needs to execute UTL_FILE to read a certain file from a certain directory. Assume that the schema of this application is APP, the directory is / oradata/app/dir/files, and the DIRECTORY object is APP_DIR. Assume that the file to be (...)
15 October 2008
How do you check if Enterprise manager is up and running?: As with many of you, we use Enterprise manager to send alerts. It hasn't happened to me but what if the management service infrastructure goes down? How do you make sure Enterprise manager is up and running. Thanks, (...)
15 October 2008
Simple Security Questions: Can I safely lock the following accounts (10.2.0.4)? SYSTEM MGMT_VIEW OUTLN None of these ever log in, according to DBA_AUDIT_TRAIL. I have session auditing on. Also, should I create a new role, with various system privileges, to replace the "burned in" DBA role, and (...)
15 October 2008
CPU Patches to old versions: Hi All, Please clear my one doubt, Does oracle provide CPU patches to quarterly for all the supported versions or it is only for the latest version. We have few 8i and 9i databases in our env. can we apply latest cpu pathes to these env. as well. Regards, (...)
14 October 2008
Ref cursor in stored proc: Hello If I call a function from a stored procedure and the function returns a ref cursor. The only info I have and want is that this ref cursor has a field, "NAME", but I know nothing of all other fields, how do I fetch this field name? E.g. this does not work since the ref (...)
14 October 2008
Dynamic query in stored procedure: Hi This question is about stored procedures. I know i can make a query such as: query := SELECT A, B, C FROM USERS WHERE NAME = :a AND SURNAME = :b OPEN my_cursor FOR query USING var_a, var_b But my question is, if I don't know how many parameters I have in the where part, how (...)
14 October 2008
how do i split a string: group, I have a record like this 12**5*** I need to know the 1st occurance of *, and length of it the 2nd occurance of * and the length of it for example, for 12**5***, I need to get 3263 meaning the 1st one start at 3, length is 2, the 2nd one start at 6, the length is 2 Your (...)
14 October 2008
10g datapump: When exporting to multiple files using options like filesize=100m and dumpfile=filename%U, is there a way to definitively know when oracle is finished writing to a specific dump file? Here's why I ask. I need to compress the dump files, but don't want to wait until the entire (...)
13 October 2008
Mutual Relationship: What do you guys think about the following situation: A Person has a Department and a Department has a boss that is a Person. Can I make a mutual relationship like this? [has a] Person --------------------> Department [Boss] Department --------------> Person What do you (...)
13 October 2008
Download Free Oracle 11g, 10g, 9i eBooks, Mock Tests, Interview, Guides etc: Oracle Database 11g [link] Oracle Database 10g [link] Oracle 9i Database [link]
13 October 2008
expdp dump file and CLOB column: I have to import a 9GB dump file produced by expdp. My problem is space allocation. One of the columns is of the CLOB type and, for some reason, it produced a 45GB LOB segment. The obvious question is how do 45GB fit into 9GB export file? Is there an underlying compression? Are LOB (...)
12 October 2008
good/bad statistics: From time to time I am called in to investigate performance problems as last week. In this case there was one bad performing query. Instead of using indexes the optimizer chose full table scans. When looking at the statistics I thought that the optimizer should have used available (...)
11 October 2008
HOw to introduce a proactive approach on DB use?: hello everyone, I just arrived at a shop where there are monthly performance problems. At every end of the month, endusers are running reports (business objects) and Peoplesoft batches. Problem is, that there is no overview with the DBA-team of the database use, e.g. : - a (...)
11 October 2008
EM db control secured after patch 10.2.0.4 ?: I noticed that the Enterprise Manager db control is changed from unsecured (http) to secured (https) access during the installation of patch 10.2.0.4. But I couldn't find this in the patch notes ? Matthias
10 October 2008
Need some help on Normalization: You identify the following attributes, in part, for the Employee entity: Employee number (Primary key) Full name Phone number Supervisor number What change should you make to ensure that the entity is normalized to the 1st normal form (1NF)? A) Separate the full name into first, (...)
10 October 2008
Looking for "gaps" (from a time perspective) in data: This is on 10gR2 standard edition. We have a table defined like this: txn_id date_start date_end url_called which contains a record for every time our application processes a request from a browser. We would like to be able to spot any "gaps" in the data - which would (...)
10 October 2008
Policy on Oracle Versions and Patches: What would be your policy on Oracle versions and patches in an environment with 500 - 1000 databases and 20 - 50 databases per DBA? Let me clarify the question. Oracle states that Patch Sets include only bug fixes and