Sign in or 
Location: Database
Page Threads
| Started By | Thread Subject | Replies | Last Post | ||||
|---|---|---|---|---|---|---|---|
| dbagilbert | I am seeking for a new contract | 0 | Oct 28 2009, 10:40 AM EDT by dbagilbert | ||||
|
Thread started: Oct 28 2009, 10:40 AM EDT
Watch
I am recahing for a new opportunity in Paris France as freelance senior oracle dba, to migration project or performance intervention or technical assistance for critical project.
you could see my complete profil on Viadeo I am available now +33 6 89 36 70 15 |
||||||
| collip | Why can't we build wiki's on Oracle. | 15 | Sep 28 2009, 8:41 AM EDT by minervino | ||||
|
Thread started: Nov 8 2007, 2:16 PM EST
Watch
Wiki's are multiplying in my company but they are all on MySQL using open source Wiki software. Does anyone have Wiki built on Oracle DB?
Show Last Reply
|
|||||||
| NotHenryPorter | 11g versions | 19 | Apr 17 2009, 6:57 AM EDT by cacruden | ||||
|
Thread started: Oct 15 2007, 1:04 PM EDT
Watch
What's the rationale for only having 11g available as 32bit Linux. Doesn't that somewhat contradict the ubiquity that Oracle would like to portray?
Show Last Reply
|
||||||
| knvrsatyaveer | errors while migrating from Oracle 9i to Oracle 10g | 3 | Mar 9 2009, 6:29 AM EDT by linlasj | ||||
|
Thread started: Feb 18 2009, 6:11 AM EST
Watch
hi . i am getting some data type mismatch error when i am running my application after migrating teh data base from 9i to Oracle 10G .. Any one has a solution for this .
i am getting the following exception >> java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got - ORA-06512: at "NBUAT_4.ROLLBACK_DOCUMENT", line 116 ORA-06512: at line 1 The code is perfectly working with my previous version . Please suggest me if you have any solution for this .
Show Last Reply
|
|||||||
| bhkrmv | ORA-01741 error | 1 | Mar 5 2009, 2:42 PM EST by luciofer | ||||
|
Thread started: Mar 5 2009, 5:34 AM EST
Watch
Hi Experts,
I request you to explain the ORA-01741 error "illegal zero-length identifier". Thanks in advance Bharath Kumar V
Show Last Reply
|
||||||
| chettiarsandip | Indexing | 1 | Mar 2 2009, 11:00 AM EST by luciofer | ||||
|
Thread started: Mar 2 2009, 4:59 AM EST
Watch
I am creating a table and then loading approx 1.5 million records into this table.
The insert statement that I use is something like this: insert into tgt_tablename select * from source_tablename My question is: would it be advisable to create the index after the insert or before the insert. I feel creating the index before or after the load will not cause any difference if the table is a new one. Kindly advise. Thanks
Show Last Reply
|
|||||||
| smit_sign | Downgrade Apex | 0 | Jan 23 2009, 11:18 AM EST by smit_sign | ||||
|
Thread started: Jan 23 2009, 11:18 AM EST
Watch
I wants the steps to carry the Apex downgrade form 3.1 to 2.0
It was recently upgraded to 3.1 bu8t due to application demands we need to turn it back. Please suggest. Thanks smita
out of
found this valuable.
Do you find this valuable?
Keyword tags:
Downgrade Apex
|
|||||||
| pbourieau | & parameters in a SQL script within DBartisan | 0 | Jan 12 2009, 8:28 AM EST by pbourieau | ||||
|
Thread started: Jan 12 2009, 8:28 AM EST
Watch
How parameters inside a sql script (set define on) can be done within DBartisan ? What can be done within SqlNqvigator or SqlPlus cannot be within DBartisan ? Does someone know how-to ?
Regards and Happy new year 2009
out of
found this valuable.
Do you find this valuable?
Keyword tags:
&
DBartisan
script
set define
SQL
|
|||||||
| TonyR_NZ | Oracle Roles and Privileges | 13 | Jan 3 2009, 8:41 PM EST by monowar94ru | ||||
|
Thread started: May 5 2008, 10:42 PM EDT
Watch
I have created a database in Oracle 9i that has numerous application packages, tables and views that reside on separate schema.
The development staff require access to multiple schema objects on the db but I am loathed to assign the 'ALL' to the DDL privileges as I would like to restrict access to a specific schema without limiting the developers to their own schema. Does anyone have any detail on a good model for this level of security? Regards
Show Last Reply
|
||||||
| Airborne_Ranger | Best Practices for troubleshooting ORA-01591,ORA-02049 errors | 1 | May 13 2008, 9:07 AM EDT by chemacomes | ||||
|
Thread started: Mar 21 2008, 3:22 PM EDT
Watch
The error description seem to indicate that at least the deadlock error is the result of a frozen two-phase commit. I get this error message when trying to run these transactions through WLS 8.1SP5 with JDBC connection pools set up and pointing to a single Oracle DBMS 9.2.1 instance. I'm not sure if the origin of the problem is the Oracle init or WebLogic JDBC Connection Pool settings or both.
Any help would be great.
Show Last Reply
|
||||||
| jcmoaz | I can use any version for educational purporse? | 8 | Apr 12 2008, 3:32 AM EDT by porushh | ||||
|
Thread started: Mar 8 2008, 1:39 PM EST
Watch
I'am teacher and i want use Oracle Standard Edition in my class. This is possible? Or my unique solution is Express Edition?.
Thank you.
Show Last Reply
|
|||||||
| jeegar | Inactive sessions | 9 | Apr 2 2008, 10:20 AM EDT by rogermiller2006@yaho | ||||
|
Thread started: Feb 7 2008, 5:02 AM EST
Watch
Dear Experts,
We are using EMC SQUARE documentum application , and oracle 10g R2 database in sun solaris on seperate servers. Apps connects database unsing oracle client . In peak hours , oracle's inactive sessions are very high. How to overcome this issue ? I am looking for solution , which automatically disconnects after some time. I have one solution that is sqlnet.expiray_time wil it help me ?/
Show Last Reply
|
|||||||
| erick_gonzalez | ora-12203 | 2 | Mar 18 2008, 12:11 PM EDT by albrico | ||||
|
Thread started: Dec 10 2007, 5:08 PM EST
Watch
hola tengo instalado en una sucursal developer y de repente un dia me dio el errror ora-12203. En oficina central funciona perfectamente y el listener esta corriendo bien, certifique y tengo conexión de red en la sucursal que puedo hacer ...saludos ?
Show Last Reply
|
|||||||
| camposa | CRS 2.0 with 10gR1 | 2 | Mar 10 2008, 10:21 AM EDT by camposa | ||||
|
Thread started: Jan 30 2008, 1:50 PM EST
Watch
I have a third party application running in 9i (non-RAC) that we are about to upgrade to 10g RAC. The product vendor indicated that since the application is only certified for 10gR1 we can only go to 10gR1 RAC but also indicated that we can go to CRS 2.0 to avoid upgrading that portion later. I'm aware that this "should" work but I'm interested in day-to-day issues with the mismatched versions, if there are any. Does this make sense? Please advise. Thanks in advance.
Show Last Reply
|
|||||||
| martinem | resonance | 0 | Feb 15 2008, 11:45 AM EST by martinem | ||||
|
Thread started: Feb 15 2008, 11:45 AM EST
Watch
in a WP "Oracle Database 10g: The Database for the Grid, An Oracle White Paper November 2003"
the authors said: "Resonance will dynamically grow and shrink the number of servers your individual databes are running on in this cluster to meet your service-level objectives. This is done automatically without requiring any user intervention. ..." In my knowledge, these amazing feature never was implemented in 10g. Does someone know something about this in 11g ? |
||||||
| hardeep.singh | RMAN Backup | 6 | Jan 25 2008, 10:12 AM EST by rucknrun | ||||
|
Thread started: Jan 1 2008, 10:31 AM EST
Watch
Hi,
I have an oracle Applications DB which has size of 70 GB Approx. When i backup the Database using RMAN, backup goes beyond 70 GB. I am using RMAN for full Backup. Please advise.
Show Last Reply
|
|||||||
| ynixon | Wish List | 0 | Jan 24 2008, 3:07 AM EST by ynixon | ||||
| pierre.frances | Oracle 11g and the new DIAGNOSTIC_DEST parameter | 3 | Jan 20 2008, 11:20 PM EST by virag_sh | ||||
|
Thread started: Nov 9 2007, 5:39 AM EST
Watch
hi all,
I would like to discuss about the new diagnostic_dest parameter. It could be a good idea but i am surprised that it can't be possible to keep old dump parameters as deprecated parameters (they are directly obsolete parameters in 11g). Most of dba startup/shutdowns & supervision scripts parse the alert.log file to return an exit code. So they need to be changed during the migration. It seems that Oracle developpement teams didn't feel that this new feature has serious consequencies on production database.
0
out of
4 found this valuable.
Do you find this valuable?
Do you?
Keyword tags:
10g
11g
diagnostic_dest
migration
Show Last Reply
|
||||||
| hardeys | RMAN - Applying Retention Policy | 2 | Jan 15 2008, 6:56 AM EST by peterkins | ||||
|
Thread started: Jan 9 2008, 6:57 AM EST
Watch
Hi All,
I am using RMAN to backup my Apps 11i Database. When RMAN applies the Retention Policy which is set to redundacy 1, its takes more than one hour. So the Whole backup takes 1 hour 30 mins. If i apply the same script on the test environment, the backup finishes within 30 mins. What can be the reasons.
Show Last Reply
|
||||||
| Tramontane | Best practices for sending email from the database | 1 | Jan 8 2008, 6:15 PM EST by skhochay | ||||
|
Thread started: Jan 4 2008, 3:41 PM EST
Watch
I am searching to find any best practices or discussions on sending email from an Oracle database. So far, I can find many tutorials and HowTo guides for the syntax of calling UTL_MAIL (which I am already familiar with).
Does anyone know of any reference which digs a bit deeper into design tips or recommendations? Such as using a queue table to send mail asyncronously (locking or failing a nightly batch job due to a mail server problem does not seem that wise to me). -Thanx
4
out of
6 found this valuable.
Do you find this valuable?
Do you?
Keyword tags:
10g
11g
database
sql utl_mail
Show Last Reply
|
|||||||
