Oracle Import
Hi, Can you try compiling following 2 files logging as sys. $ORACLE_HOME/rdbms/admin/dbmsread.sql $ORACLE_HOME/rdbms/admin/prvtread.plb I am not very sure that this will work. But it may resolve the issue. Regards.
View Answer
| October 28, 2005 12:40 AM
Database, DB2, Oracle
Hi, Can you try compiling following 2 files logging as sys. $ORACLE_HOME/rdbms/admin/dbmsread.sql $ORACLE_HOME/rdbms/admin/prvtread.plb I am not very sure that this will work. But it may resolve the issue. Regards.
View Answer
| October 28, 2005 12:40 AM
Database, DB2, Oracle
Oracle Import to Linux
1). FTP this file from your VAX system to your Linux system. 2). Make sure you copy it as a BINARY file. 3). Run the import function from Linux. It shoud be that easy….
View Answer
| October 26, 2005 7:48 AM
Database, DB2, Oracle
1). FTP this file from your VAX system to your Linux system. 2). Make sure you copy it as a BINARY file. 3). Run the import function from Linux. It shoud be that easy….
View Answer
| October 26, 2005 7:48 AM
Database, DB2, Oracle
Knowing the number of rows in a cursor
I doubt that such a function exists. What you want is essentially to retrieve count(*) in place of your selected column(s). Oracle appears to handle cursors very efficiently by not bringing back all of the rows at once, but only as it needs more to satisfy a fetch request. You could could do that “SELECT [...]
View Answer
| October 25, 2005 7:00 PM
Database, DB2, Oracle, SQL, Windows
I doubt that such a function exists. What you want is essentially to retrieve count(*) in place of your selected column(s). Oracle appears to handle cursors very efficiently by not bringing back all of the rows at once, but only as it needs more to satisfy a fetch request. You could could do that “SELECT [...]
View Answer
| October 25, 2005 7:00 PM
Database, DB2, Oracle, SQL, Windows
oracle error
Check your code to see if you have used RAISE_APPLICATION_ERROR (probably somewhere around line 19)in your code. What is the error number you have specified? Use an error number in the range of -20000 to -20999, inclusive. Hope this helps.
View Answer
| October 25, 2005 1:30 PM
Oracle, Windows
Check your code to see if you have used RAISE_APPLICATION_ERROR (probably somewhere around line 19)in your code. What is the error number you have specified? Use an error number in the range of -20000 to -20999, inclusive. Hope this helps.
View Answer
| October 25, 2005 1:30 PM
Oracle, Windows
Deleting duplicate rows based on timestamps
I’ll show you the SQL to do this below, but first I have to explain something. During any two separate SQL executions, each timestamp will have a different value. For example, (examples shown in DB2 syntax): INSERT INTO xxx VALUES(CURRENT TIMESTAMP); INSERT INTO xxx VALUES(CURRENT TIMESTAMP); The two timestamps will have different values, even if [...]
View Answer
| October 22, 2005 3:55 PM
Database, DB2, Oracle, SQL
I’ll show you the SQL to do this below, but first I have to explain something. During any two separate SQL executions, each timestamp will have a different value. For example, (examples shown in DB2 syntax): INSERT INTO xxx VALUES(CURRENT TIMESTAMP); INSERT INTO xxx VALUES(CURRENT TIMESTAMP); The two timestamps will have different values, even if [...]
View Answer
| October 22, 2005 3:55 PM
Database, DB2, Oracle, SQL
Database Upgrade
As far as your database server migration, it sounds like you’re on the right track. TNSName entry mods are essential ofcourse. Ensure that your destination tablespaces have similar storage capacities as your source so you won’t get import errors. Make sure you’ve got the same Oracle schema/users setup on your destination Oracle database server, and [...]
View Answer
| October 21, 2005 10:24 AM
Oracle, Windows
As far as your database server migration, it sounds like you’re on the right track. TNSName entry mods are essential ofcourse. Ensure that your destination tablespaces have similar storage capacities as your source so you won’t get import errors. Make sure you’ve got the same Oracle schema/users setup on your destination Oracle database server, and [...]
View Answer
| October 21, 2005 10:24 AM
Oracle, Windows
Database cleanup
Hi, Not sure about q1. But for q2 and q3, you can easily check the same using TOAD. It provides you the TAB (Referentials / Used By) for the dependant and referenced objects. You would be able to get information on procedures / packages written in database. But with reference to the proc*c or c++, [...]
View Answer
| October 21, 2005 4:06 AM
Database, DB2, Oracle
Hi, Not sure about q1. But for q2 and q3, you can easily check the same using TOAD. It provides you the TAB (Referentials / Used By) for the dependant and referenced objects. You would be able to get information on procedures / packages written in database. But with reference to the proc*c or c++, [...]
View Answer
| October 21, 2005 4:06 AM
Database, DB2, Oracle
What is wrong with my code?
pass this connection string to oracle:- “Provider=MSDAORA.1;Password=;User ID= ;Data Source= Oracle’s Host String ;Persist Security Info=True”
View Answer
| October 19, 2005 9:42 AM
Oracle
pass this connection string to oracle:- “Provider=MSDAORA.1;Password=;User ID= ;Data Source= Oracle’s Host String ;Persist Security Info=True”
View Answer
| October 19, 2005 9:42 AM
Oracle
Need help with max function within a left outer join
What does your SQL statement look like ?
View Answer
| October 19, 2005 5:17 AM
Database, DB2, Oracle, SQL
What does your SQL statement look like ?
View Answer
| October 19, 2005 5:17 AM
Database, DB2, Oracle, SQL
EMCA
you need to specify database version you are working with? In 9i Database releases It need to create repositery in a different database to configure OMS.
View Answer
| October 14, 2005 1:02 AM
Oracle
you need to specify database version you are working with? In 9i Database releases It need to create repositery in a different database to configure OMS.
View Answer
| October 14, 2005 1:02 AM
Oracle
Oracle Hash Partitioning.
The point of hash partitioning is: let the DB manage the partitioning automatically. Therefore I do not think you can control it. If you want to control partitions within each range, you could use range-list partitioning, as long as you are working at least with Oracle 9iR2, which is recommendable for data warehousing, anyway.
View Answer
| October 13, 2005 3:07 AM
Business Objects, Data analysis, Data warehousing applications, Database, DB2, Oracle, Windows
The point of hash partitioning is: let the DB manage the partitioning automatically. Therefore I do not think you can control it. If you want to control partitions within each range, you could use range-list partitioning, as long as you are working at least with Oracle 9iR2, which is recommendable for data warehousing, anyway.
View Answer
| October 13, 2005 3:07 AM
Business Objects, Data analysis, Data warehousing applications, Database, DB2, Oracle, Windows
9i and 10g installation on the same server
There will not be any type of issues in installing both 9i and 10g on the same machine only thing is tat you need to have higher grade server ie a minimum of 4gb RAM is required to run both the instances on the same machine.Apart from the memory consumption you will not face any [...]
View Answer
| October 12, 2005 12:33 AM
Database, DB2, Oracle
There will not be any type of issues in installing both 9i and 10g on the same machine only thing is tat you need to have higher grade server ie a minimum of 4gb RAM is required to run both the instances on the same machine.Apart from the memory consumption you will not face any [...]
View Answer
| October 12, 2005 12:33 AM
Database, DB2, Oracle
Oracle 8.1.7 Rman commands
The Oracle8i Recovery Manager User’s Guide and Reference has syntax, instructions, examples, etc. Also check your ORACLE_HOME/rdbms/demo directory, there should be a .sh file (e.g., rman2.sh) that is an example shell script for rman backups.
View Answer
| October 11, 2005 12:40 PM
Database, DB2, Oracle
The Oracle8i Recovery Manager User’s Guide and Reference has syntax, instructions, examples, etc. Also check your ORACLE_HOME/rdbms/demo directory, there should be a .sh file (e.g., rman2.sh) that is an example shell script for rman backups.
View Answer
| October 11, 2005 12:40 PM
Database, DB2, Oracle
Installing Oracle 10g on an external USB drive
I onced moved Oracle from one server to another by using the installation program to basically set up the Windows registry and anything that ends up on the c:windows drive during installation. Then I shutdown and deleted all Oracle directories. Next I copied the entire drive that contained the entire Oracle setup to the new [...]
View Answer
| October 10, 2005 9:36 AM
Oracle
I onced moved Oracle from one server to another by using the installation program to basically set up the Windows registry and anything that ends up on the c:windows drive during installation. Then I shutdown and deleted all Oracle directories. Next I copied the entire drive that contained the entire Oracle setup to the new [...]
View Answer
| October 10, 2005 9:36 AM
Oracle
ORACLE
You could save the file in Excel as a .CSV file. Then use Oracle SQL Loader utility to import it into Oracle. Another way could be to use MS Access as the exporter from Excel and Importer to Oracle. Link the Excel table into Access. Use ODBC to link the Oracle table. Then make an [...]
View Answer
| October 10, 2005 9:12 AM
Development, Oracle
You could save the file in Excel as a .CSV file. Then use Oracle SQL Loader utility to import it into Oracle. Another way could be to use MS Access as the exporter from Excel and Importer to Oracle. Link the Excel table into Access. Use ODBC to link the Oracle table. Then make an [...]
View Answer
| October 10, 2005 9:12 AM
Development, Oracle
Why do IT projects fail?-2
Baseline Magazine (www.baselinemag.com) covers both successfull and other IT projects.
View Answer
| October 9, 2005 6:02 PM
390, Business/IT alignment, Cabling, Career development, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Desktops, Development, Hardware, Hubs, Linux, Mainframe, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Patch management, Routers, Security, Servers, Software Quality Assurance, Software testing, SQL Server, Switches, Tech support
Baseline Magazine (www.baselinemag.com) covers both successfull and other IT projects.
View Answer
| October 9, 2005 6:02 PM
390, Business/IT alignment, Cabling, Career development, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Desktops, Development, Hardware, Hubs, Linux, Mainframe, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Patch management, Routers, Security, Servers, Software Quality Assurance, Software testing, SQL Server, Switches, Tech support
Oracle 10G tuning statements
The first thing that you need to do is familiarize yourself with any of the new features that were made in 10g from a SQL perspective What type of environment are we speaking about here? OLTP, Data Warehousing? Let me know, I will be able to provide better direction. Thanks Scott
View Answer
| October 5, 2005 10:15 AM
Oracle, SQL, Windows
The first thing that you need to do is familiarize yourself with any of the new features that were made in 10g from a SQL perspective What type of environment are we speaking about here? OLTP, Data Warehousing? Let me know, I will be able to provide better direction. Thanks Scott
View Answer
| October 5, 2005 10:15 AM
Oracle, SQL, Windows
Security/ Audit Check list for DB2
The only one I was able to find was the general DISA STIG for databases, however appendix D is dedicated to DB2. the link is below http://csrc.nist.gov/pcig/STIGs/DATABASE-STIG-V7R1.pdf
View Answer
| October 3, 2005 10:29 AM
Application security, Database, DB2, Encryption, Exchange, Instant Messaging, Oracle, Secure Coding, SQL
The only one I was able to find was the general DISA STIG for databases, however appendix D is dedicated to DB2. the link is below http://csrc.nist.gov/pcig/STIGs/DATABASE-STIG-V7R1.pdf
View Answer
| October 3, 2005 10:29 AM
Application security, Database, DB2, Encryption, Exchange, Instant Messaging, Oracle, Secure Coding, SQL
ASP with Unicode records -
havent done much programming but is there an option to enable double char or unicode for strings? As to me it looks like that the string is been returned as a single character block and its in the upper or lower (the very low) ranges for 0–>FF This is my $2.50 piece
View Answer
| September 26, 2005 9:07 AM
Content management applications, Database, DB2, Desktops, Development, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server, Web development tools, Web services, Web site design & management
havent done much programming but is there an option to enable double char or unicode for strings? As to me it looks like that the string is been returned as a single character block and its in the upper or lower (the very low) ranges for 0–>FF This is my $2.50 piece
View Answer
| September 26, 2005 9:07 AM
Content management applications, Database, DB2, Desktops, Development, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server, Web development tools, Web services, Web site design & management
Enabling Java in Oracle 8.1.7 – ORA-29540
I had the exact same problem. What version of 8.1.7 do you have? The problem may be that the plsql.jar file, provided in the 8.1.7.1 patchset, contains an invalid TCPConnection class. The invalid class was fixed in 8.1.7.2. This does not automatically get loaded back into the database when doing an upgrade. You will need [...]
View Answer
| September 26, 2005 5:36 AM
Oracle, Windows
I had the exact same problem. What version of 8.1.7 do you have? The problem may be that the plsql.jar file, provided in the 8.1.7.1 patchset, contains an invalid TCPConnection class. The invalid class was fixed in 8.1.7.2. This does not automatically get loaded back into the database when doing an upgrade. You will need [...]
View Answer
| September 26, 2005 5:36 AM
Oracle, Windows
