Why numeric data truncated to be integer when declaring NUMBER data type in Oracle 10g
Hello, My company recently upgraded Oracle server form 9i to 10g and I was requested to load all tables data from 9i to 10g. Most data transfer are good except this situation: If 9i table with date type declared as NUMBER, all numeric data will be truncated as integer in 10g (I used the same [...]

Answer Question   |  December 3, 2007  9:55 PM
Oracle 10, Oracle NUMBER data type

Recovering and restoring database
I have taken a rman backup without controlfiles and i am not using recovery catalog i am uisng target database. NOw i lost all datafile s,controlfiles and redolog files.How do i get my databse up and running.

Answer Question   |  November 30, 2007  7:03 PM
Oracle, Recovery, Recovery Manager, Restore

Oracle sys and system passwords
I have a database that was created by a person who is no longer with the company. They changed the sys and system passwords but told no one. Is there a way to change (find) the sys and system passwords.

Answer Question   |  December 4, 2007  12:29 AM
Oracle, Oracle administration

How do you get around an ORA-06550 error?
I am making a program that will ask the user to enter a customer number. All of the customer numbers are numbers only. If the user enters in a customer number with a letter in it by mistake they will receive an ora-06550 error on that line number. How can I create an exception that [...]

Answer Question   |  April 18, 2013  4:52 PM
ORA-06550, Oracle 10g, Oracle error messages

Oracle / EADH
Can someone please explain to me what EADH (Enterprise Agent Data Hub) works?

Answer Question   |  November 27, 2007  11:30 PM
EADH, Oracle Business Applications, Oracle developers

Oracle Cross Schema View
I am creating a cross schema view and am receiving the error ‘Table or View does not exist’ on the second table of one schema in my view. Here is the View: CREATE OR REPLACE VIEW WORKMGMT.VIEW_WORKMGMT_USERS( USER_ID, USER_VALID_FROM, USER_VALID_TO, DEFAULT_UNIT, LANGUAGE_PREFERENCE) AS SELECT SU.ORGANIZATION_USER_ID “USER_ID”, TO_TIMESTAMP(TO_CHAR(SU.EFFECTIVE_FROM,’YYYY_MON_DD’),’YYYY-MON-DD HH24:MI:SS’) “USER_VALID_FROM”, TO_TIMESTAMP(TO_CHAR(SU.EFFECTIVE_TO, ‘YYYY_MON_DD’), ‘YYYY-MON-DD HH24:MI:SS’) “USER_VALID_TO”, WM.DEFAULT_UNIT_ID [...]

Answer Question   |  November 20, 2007  9:08 PM
cross schema, Oracle, Oracle error messages, Oracle Views, SQL

e business and e commerce
what is the difference between e business and e commerce

Answer Question   |  November 20, 2007  10:58 AM
Ebusiness, Ecommerce

saving text files in oracle database
how to save text files in oracle database

Answer Question   |  December 4, 2007  10:59 AM
Database, Oracle

Future of ERP?
What is the future of ERP, i.e. the so called next wave?

Answer Question   |  December 5, 2007  10:10 PM
ERP, Oracle, SAP, Scm

Oracle Application Server
I need to install Oracle Application Server 10g on HP Proliant DL580 with dual-core 64-bit Intel Xeon processor (7140M), & with Windows 2003 64-bit. I couldn’t find any version or release for such environment, but I found for the Itanium processors. Kindly advise me about the right version & release for OAS & if I [...]

Answer Question   |  February 21, 2008  8:56 AM
Oracle 10g, Oracle Application Server

retrieving data/tables through ODBC to Oracle
HI I need to pull up oracle tables through ODBC in access is that possible? help.

Answer Question   |  February 1, 2008  9:41 PM
Database, ODBC Oracle Access, Oracle

Oracle table column names starting with a number
Hello, I just finished creating MANY tables that have column names starting with a number. I didn’t realize it was an issue until I started trying to select data from my tables using the column names in the where clause. Inserts work. Selects without where work. Is there any way to keep the column names [...]

Answer Question   |  November 7, 2007  12:56 AM
Oracle, PL/SQL, Query

PeopleSoft Admin & Portal Admin Roles
We are in the process of limiting access to our prod with the PeopleSoft Administrator Role. What we have been told by out tech guys is that when they run the PORTAL_CSS they need the PeopleSoft administrator role. If they use the Portal Administrator role to run it, you are suppose to not be able [...]

Answer Question   |  November 1, 2007  9:43 PM
PeopleSoft, Peoplesoft (product)

How to capture error stack when using forall in PL/SQL?
How do you capture all the errors in an error stack when using forall/bulk processing within PL/SQL? This is the error stack: ORA-12801: error signaled in parallel query server P000 ORA-01722: invalid number The only error captured in PL/SQL is the first error message but the second is actually more important because it gives specifics: [...]

Answer Question   |  October 31, 2007  11:58 PM
Oracle, PL/SQL

RAC and Sun cluster
We are installing 5 Sun Solaris servers (T2000′s) for Oracle databases(no applications) in a RAC environment on EMC disk drives. The argument has come up as to whether using the Sun Cluster v3.2 is necessary when RAC is installed. One group states that the Sun Clustering complicates the environment, while the other group states that [...]

Answer Question   |  January 23, 2008  2:15 PM
EMC, Oracle, Solaris

Problem Faced While Installing Oracle 9i on Linux
Hello All, While Installing Oracle 9i (9.2.0.6) on Red Hat Linux AS4, I received the following error: - RPM to install the Legato Single Server Version (LSSV) product. Form more information, please refer to the Linux installation section in the LSSV Installation Guide at http://www.legato.com/LSSV error: Failed dependencies: libncurses.so.4 is needed by orclclnt-nw_lssv.Build.71-1.i386 error: Failed [...]

Answer Question   |  November 16, 2007  10:57 AM
Linux, Oracle

Query SYSTEM tablespace Privileges
I am trying to figure out what privileges two users have to the SYSTEM tablespace… However quering the “user_sys_pivs” table will only give me the privs of the user I am logged onto the system with. Is there anyway I can find out that information without logging to their account. I am using orcl 8i [...]

Answer Question   |  October 29, 2007  9:15 AM
Oracle, SYSTEM TABLESPACE

query
how to write a trigger in oracle

Answer Question   |  November 1, 2009  8:27 AM
Oracle

Oracle:Concat multiple rows using XML
Hi There I am using the following to concatenate multiple rows in an Oracle 9 table: SELECT column1 , RTRIM ( xmlagg (xmlelement (column2 || ‘ ‘) order by column1, column3).extract (‘//text()’) , ‘ ‘ ) AS concatenated FROM mytable where (column4 = ‘XXXXXXX’) and (column5 = ‘XXXXXXX’) and (column6 = ‘XXXXXXX’) group by column1 [...]

Answer Question   |  June 8, 2012  6:06 AM
Oracle

%rowcount in 10G
Can we use %rowcount in oracle 10G and if not what is the solution?

Answer Question   |  February 5, 2008  8:57 AM
Oracle, Oracle 10g