oar-01033
My first thought without looking anything up is that your password file is corrupt. Can you get to the server and log in as “sqlplus / as sysdba”? If so, then you need to recreate your password file or change the parameter <b>remote_login_passwordfile</b> to be “NONE”.
View Answer
| April 21, 2008 2:11 PM
ORA-01031, ORA-01033, Oracle error messages, SQLPlus
My first thought without looking anything up is that your password file is corrupt. Can you get to the server and log in as “sqlplus / as sysdba”? If so, then you need to recreate your password file or change the parameter <b>remote_login_passwordfile</b> to be “NONE”.
View Answer
| April 21, 2008 2:11 PM
ORA-01031, ORA-01033, Oracle error messages, SQLPlus
About oracle editions
The Express edition is the free version which can be downloaded and used at no cost. The Standard and Enterprise editions require that you purchase a license to use them.
View Answer
| April 17, 2008 11:32 PM
Oracle, Oracle 10g
The Express edition is the free version which can be downloaded and used at no cost. The Standard and Enterprise editions require that you purchase a license to use them.
View Answer
| April 17, 2008 11:32 PM
Oracle, Oracle 10g
i need help urgently
Hello, Just send the error messages across.. hope u tried cmd> sqlplus /nolog >conn / as sysdba and >startup k . hope it helps you. <b>Enterprise Manager aka OEM? </b> This is a web page that you should have a link for in you Start | All Programs | Oracle – Ora10 folder. A java [...]
View Answer
| April 17, 2008 3:41 PM
Oracle 10g, Oracle Enterprise Manager, Oracle installation
Hello, Just send the error messages across.. hope u tried cmd> sqlplus /nolog >conn / as sysdba and >startup k . hope it helps you. <b>Enterprise Manager aka OEM? </b> This is a web page that you should have a link for in you Start | All Programs | Oracle – Ora10 folder. A java [...]
View Answer
| April 17, 2008 3:41 PM
Oracle 10g, Oracle Enterprise Manager, Oracle installation
Subquery?
OK, if I understand correctly you want a query to show the first 10 characters of a name and its location. My first thought is you don’t specify the join column between customer.detail and customer.general. I am going to assume it is customercode. That makes the query look like this: select substr(b.customername,1,10) name from ( [...]
View Answer
| April 17, 2008 3:37 PM
Oracle, SQLPlus, Subquery
OK, if I understand correctly you want a query to show the first 10 characters of a name and its location. My first thought is you don’t specify the join column between customer.detail and customer.general. I am going to assume it is customercode. That makes the query look like this: select substr(b.customername,1,10) name from ( [...]
View Answer
| April 17, 2008 3:37 PM
Oracle, SQLPlus, Subquery
Truncate or not Truncate SQL
Truncate deletes all your data (w/o using rollback/undo) retaining the definition of the table (and the storage it used, if desired). Dropping the table deletes the data (w/o using rollback/undo) and removes the definition from the data dictionary and de-allocates the storage that was assigned to the table. Which one you want to use depends [...]
View Answer
| April 14, 2008 2:23 PM
PL/SQL, SQL
Truncate deletes all your data (w/o using rollback/undo) retaining the definition of the table (and the storage it used, if desired). Dropping the table deletes the data (w/o using rollback/undo) and removes the definition from the data dictionary and de-allocates the storage that was assigned to the table. Which one you want to use depends [...]
View Answer
| April 14, 2008 2:23 PM
PL/SQL, SQL
My Oracle server is corrupt, and can’t start using Oracle 8i
hi, What is the error message? It is possible to repair and start a corrupt database. you can use these utilities : <b>dbverify</b> To veryfiy if they are block corruptions <a href=”http://download.oracle.com/docs/cd/B10501_01/server.920/a96572/osbackups.htm#8467″> <b>DBMS_REPAIR </b> to correct block corruption <a href=”http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/repair.htm”>
View Answer
| April 12, 2008 11:29 AM
Oracle, Oracle 8i, Windows 2000 Server
hi, What is the error message? It is possible to repair and start a corrupt database. you can use these utilities : <b>dbverify</b> To veryfiy if they are block corruptions <a href=”http://download.oracle.com/docs/cd/B10501_01/server.920/a96572/osbackups.htm#8467″> <b>DBMS_REPAIR </b> to correct block corruption <a href=”http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/repair.htm”>
View Answer
| April 12, 2008 11:29 AM
Oracle, Oracle 8i, Windows 2000 Server
How to import .doc files into Oracle 10g
You say that you have tables in a .doc file, but don’t really say what is in the doc file. Are the table descriptions in the .doc file? Are the descriptions and data in the doc file? is just lots of data in the doc file? It’s difficult to give a good answer without detailed [...]
View Answer
| April 12, 2008 7:45 AM
Oracle 10g
You say that you have tables in a .doc file, but don’t really say what is in the doc file. Are the table descriptions in the .doc file? Are the descriptions and data in the doc file? is just lots of data in the doc file? It’s difficult to give a good answer without detailed [...]
View Answer
| April 12, 2008 7:45 AM
Oracle 10g
view color codes
Please read about color columns in the Designer help.
View Answer
| April 11, 2008 3:41 PM
Formula Language, Lotus Notes, Oracle Views
Please read about color columns in the Designer help.
View Answer
| April 11, 2008 3:41 PM
Formula Language, Lotus Notes, Oracle Views
What is the PRAGMA_INIT exception?
Hi, Do you mean PRAGMA EXCEPTION_INIT? It’s a way of associating names with user-defined exceptions, so you that exception handlers can refer to them by name. Here’s an example from the Database Administrator’s Guide: <pre> DECLARE null_salary EXCEPTION; PRAGMA EXCEPTION_INIT(null_salary, -20101); BEGIN … RAISE_APPLICATION_ERROR(-20101, ‘salary is missing’); … EXCEPTION WHEN null_salary THEN … END; </pre>
View Answer
| April 10, 2008 5:30 PM
Oracle, Oracle error messages, pragma EXCEPTION_INIT
Hi, Do you mean PRAGMA EXCEPTION_INIT? It’s a way of associating names with user-defined exceptions, so you that exception handlers can refer to them by name. Here’s an example from the Database Administrator’s Guide: <pre> DECLARE null_salary EXCEPTION; PRAGMA EXCEPTION_INIT(null_salary, -20101); BEGIN … RAISE_APPLICATION_ERROR(-20101, ‘salary is missing’); … EXCEPTION WHEN null_salary THEN … END; </pre>
View Answer
| April 10, 2008 5:30 PM
Oracle, Oracle error messages, pragma EXCEPTION_INIT
Oracle Application Express Item
This depends upon the primary key of the child table. If a record already exists in the child table with the given foreign key value and the parent record is updated, then a “post update trigger” on the parent table can be written to update the foreign key value of the child table. All key [...]
View Answer
| April 9, 2008 7:22 PM
Database, Foreign keys, Oracle, Primary keys
This depends upon the primary key of the child table. If a record already exists in the child table with the given foreign key value and the parent record is updated, then a “post update trigger” on the parent table can be written to update the foreign key value of the child table. All key [...]
View Answer
| April 9, 2008 7:22 PM
Database, Foreign keys, Oracle, Primary keys
Oracle View
Your where clause should read something like this: WHERE event.cdts >= TO_CHAR ((SYSDATE-4/24), ‘yyyymmdd’) Another issue is the data type of event.cdts. It should be a date field. This to_char statement strips off all the time elements of sysdate so it will show all records for the day that sysdate -4/24 equates to. If event.cdts [...]
View Answer
| April 3, 2008 2:28 PM
Oracle Views
Your where clause should read something like this: WHERE event.cdts >= TO_CHAR ((SYSDATE-4/24), ‘yyyymmdd’) Another issue is the data type of event.cdts. It should be a date field. This to_char statement strips off all the time elements of sysdate so it will show all records for the day that sysdate -4/24 equates to. If event.cdts [...]
View Answer
| April 3, 2008 2:28 PM
Oracle Views
Oracle listener
You can find what listeners are running in Unix by typing the following command. <b>ps -ef | grep tns</b> oracle 18873 1 0 Dec12 ? 00:00:00 /u02/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit oracle 18876 18873 0 Dec12 ? 00:00:00 /u02/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit root 21779 8976 0 08:06 pts/1 00:00:00 grep tnslsnr Check all listeners returned for the correct [...]
View Answer
| April 3, 2008 2:41 AM
Oracle 10g, Oracle Listener, PL/SQL
You can find what listeners are running in Unix by typing the following command. <b>ps -ef | grep tns</b> oracle 18873 1 0 Dec12 ? 00:00:00 /u02/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit oracle 18876 18873 0 Dec12 ? 00:00:00 /u02/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit root 21779 8976 0 08:06 pts/1 00:00:00 grep tnslsnr Check all listeners returned for the correct [...]
View Answer
| April 3, 2008 2:41 AM
Oracle 10g, Oracle Listener, PL/SQL
list sales by year
Sorry, Kkd777, that’s a homework assignment question, and it would be inappropriate for us just to hand you the answer. If you show what you have tried, and it doesn’t work correctly, then we can offer suggestions as to why. Otherwise we cannot just do your homework for you. Besides, you forgot to copy/paste the [...]
View Answer
| March 28, 2008 5:19 PM
Oracle, SQL
Sorry, Kkd777, that’s a homework assignment question, and it would be inappropriate for us just to hand you the answer. If you show what you have tried, and it doesn’t work correctly, then we can offer suggestions as to why. Otherwise we cannot just do your homework for you. Besides, you forgot to copy/paste the [...]
View Answer
| March 28, 2008 5:19 PM
Oracle, SQL
SAP HR
To get the name, use SAP Table PA0002. Also make sure to get the Personnel number as that is the key to the other PA tables. SAP Table PA008 holds the salary, you’ll need to use the Personnel number you got from PA0002. Thanks. Chris
View Answer
| March 26, 2008 1:16 PM
Oracle, SAP HR, SQL
To get the name, use SAP Table PA0002. Also make sure to get the Personnel number as that is the key to the other PA tables. SAP Table PA008 holds the salary, you’ll need to use the Personnel number you got from PA0002. Thanks. Chris
View Answer
| March 26, 2008 1:16 PM
Oracle, SAP HR, SQL
Connecting oracle forms 6i with 10g XE database
Hi, i have the same problem, but i solve this installing two oracle homes in the client. Regards Marco
View Answer
| March 22, 2008 3:16 PM
Oracle 10g, Oracle 6i
Hi, i have the same problem, but i solve this installing two oracle homes in the client. Regards Marco
View Answer
| March 22, 2008 3:16 PM
Oracle 10g, Oracle 6i
Oracle 8i to Oracle 10g Export /Import
I’m not positive. Saw this <a href=”http://searchoracle.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid41_gci1192247,00.html”>question</a> which indicates that a direct upgrade to 10g release 2 is supported from 8.1.7.4 so I would guess that what you are trying with export/import from 8.1.6.0 would be possible. I think it’s worth trying first. After you use the 8i export, the 10g import utility will complain [...]
View Answer
| March 19, 2008 3:11 PM
Oracle 10g, Oracle 8i, Oracle import/export
I’m not positive. Saw this <a href=”http://searchoracle.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid41_gci1192247,00.html”>question</a> which indicates that a direct upgrade to 10g release 2 is supported from 8.1.7.4 so I would guess that what you are trying with export/import from 8.1.6.0 would be possible. I think it’s worth trying first. After you use the 8i export, the 10g import utility will complain [...]
View Answer
| March 19, 2008 3:11 PM
Oracle 10g, Oracle 8i, Oracle import/export
Export Oracle 10g and Import to Oracle 9i
If you have 10g and 9i clients installed on the same workstation, open up each tnsnames.ora file using notepad and copy the tns entry for your 10g server into your 9i tnsnames.ora. Save the file, then make sure your Oracle Home is set to your 9i directory. You should be able to connect to the [...]
View Answer
| March 18, 2008 2:42 PM
Data warehouse, Oracle 10, Oracle 9, Oracle import/export, Red Hat Enterprise Linux
If you have 10g and 9i clients installed on the same workstation, open up each tnsnames.ora file using notepad and copy the tns entry for your 10g server into your 9i tnsnames.ora. Save the file, then make sure your Oracle Home is set to your 9i directory. You should be able to connect to the [...]
View Answer
| March 18, 2008 2:42 PM
Data warehouse, Oracle 10, Oracle 9, Oracle import/export, Red Hat Enterprise Linux
ORA-06550 error: the function is undefined or not a procedure, yet I have defined the function
Have you granted rights to the function? Do you have the case of the object correct?
View Answer
| March 13, 2008 6:52 AM
ORA-06550, PL/SQL, Undefined Function
Have you granted rights to the function? Do you have the case of the object correct?
View Answer
| March 13, 2008 6:52 AM
ORA-06550, PL/SQL, Undefined Function
SQL (Oracle) Date Constraints
Hi , You can use check constraint on column which will check date is grater than 1 jan 2007 or you can create trigger before insert or update which will check that date is grater than 1 jan 2007 . easy way to use check constraint on column below is example CREATE TABLE test ( [...]
View Answer
| March 12, 2008 4:38 AM
Oracle development, SQL
Hi , You can use check constraint on column which will check date is grater than 1 jan 2007 or you can create trigger before insert or update which will check that date is grater than 1 jan 2007 . easy way to use check constraint on column below is example CREATE TABLE test ( [...]
View Answer
| March 12, 2008 4:38 AM
Oracle development, SQL
If I am Exporting Oracle 8i Database to new Oracle10g there is any problem with Oracle block sizes during import
Hi, There’s no problem exporting from a database with one block size and importing into a database with another block size. Export/import is a logical operation, and it makes no attempt to copy physical characteristics (like ROWID).
View Answer
| March 11, 2008 3:29 PM
Export utility, Oracle 10g, Oracle 8i
Hi, There’s no problem exporting from a database with one block size and importing into a database with another block size. Export/import is a logical operation, and it makes no attempt to copy physical characteristics (like ROWID).
View Answer
| March 11, 2008 3:29 PM
Export utility, Oracle 10g, Oracle 8i
