Database Diagram Tool
Depends on what you already have on your PC. If you have Microsoft Visio, it will work. Also If you are using Sql Server 2000 for you DB, it has a diagram tool in it. Look at the apps you have before you try to find a third party program.
View Answer
| November 16, 2005 8:24 AM
Data analysis, Data warehousing applications, Database, DB2, Oracle
Depends on what you already have on your PC. If you have Microsoft Visio, it will work. Also If you are using Sql Server 2000 for you DB, it has a diagram tool in it. Look at the apps you have before you try to find a third party program.
View Answer
| November 16, 2005 8:24 AM
Data analysis, Data warehousing applications, Database, DB2, Oracle
Delete maximum records in a table
Although there are a number of ways to do this in a single SQL statement, it’s best to use a cursor loop, since any such SQL statement would rely on order of execution, and that’s called a “pornographic specification”, since it can be version-dependent. Here’s how I’d do it: Assuming: CREATE TABLE myTable( major INTEGER, [...]
View Answer
| November 16, 2005 1:32 AM
Database, DB2, Oracle
Although there are a number of ways to do this in a single SQL statement, it’s best to use a cursor loop, since any such SQL statement would rely on order of execution, and that’s called a “pornographic specification”, since it can be version-dependent. Here’s how I’d do it: Assuming: CREATE TABLE myTable( major INTEGER, [...]
View Answer
| November 16, 2005 1:32 AM
Database, DB2, Oracle
sql query
The following rudimentary script will show you the basics. You can expand on this to show what you need. select b.sid, b.username, a.sql_text from v$sqlarea a, v$session b where a.address=b.sql_address Oracle’s Enterprise Manager ‘Top Sessions’, ‘Top SQL’ provides a good gui interface.
View Answer
| November 15, 2005 1:05 PM
Database, DB2, Oracle
The following rudimentary script will show you the basics. You can expand on this to show what you need. select b.sid, b.username, a.sql_text from v$sqlarea a, v$session b where a.address=b.sql_address Oracle’s Enterprise Manager ‘Top Sessions’, ‘Top SQL’ provides a good gui interface.
View Answer
| November 15, 2005 1:05 PM
Database, DB2, Oracle
database down
Have a look in the oracle/admin/[sid]/bdump directory at the alert_[sid].log file. Should see entries of when a database is started or shutdown.
View Answer
| November 15, 2005 11:09 AM
Database, DB2, Oracle
Have a look in the oracle/admin/[sid]/bdump directory at the alert_[sid].log file. Should see entries of when a database is started or shutdown.
View Answer
| November 15, 2005 11:09 AM
Database, DB2, Oracle
DB Replication with Oracle
Actually, Oracle light is meant to do excatly what you are describing. A low maintenance db on devices that travel. http://download-east.oracle.com/docs/cd/B19188_01/doc/B15921/toc.htm Take a look. For details on what Oracle supports of replication (which is the term Oracle uses for DB-DB sync – not DB-user) check out the RDBMS manual for replication. There are restrictions based [...]
View Answer
| November 14, 2005 1:17 PM
Oracle
Actually, Oracle light is meant to do excatly what you are describing. A low maintenance db on devices that travel. http://download-east.oracle.com/docs/cd/B19188_01/doc/B15921/toc.htm Take a look. For details on what Oracle supports of replication (which is the term Oracle uses for DB-DB sync – not DB-user) check out the RDBMS manual for replication. There are restrictions based [...]
View Answer
| November 14, 2005 1:17 PM
Oracle
sqlplus killed
I seem to remember this behaviour when you don’t have the correct environment set up. $ORACLE_HOME amongst others must be set up. Talk to your DBA, there should be a script to set up all your necessary environment.
View Answer
| November 14, 2005 4:05 AM
Database, DB2, Oracle
I seem to remember this behaviour when you don’t have the correct environment set up. $ORACLE_HOME amongst others must be set up. Talk to your DBA, there should be a script to set up all your necessary environment.
View Answer
| November 14, 2005 4:05 AM
Database, DB2, Oracle
Effect of DB migration on Interfaces
SAP has a OS/DB migrations guide/checklist and a go-live check that has to be performed before you go live on the new system. I have done this several time for different DB and OS. Seeing that this will be a hetrogenius migration you can run the R/3 Inst. on the DEV system and export the [...]
View Answer
| November 13, 2005 4:42 PM
Basis, Database, DB2, Oracle, Upgrades / implementations
SAP has a OS/DB migrations guide/checklist and a go-live check that has to be performed before you go live on the new system. I have done this several time for different DB and OS. Seeing that this will be a hetrogenius migration you can run the R/3 Inst. on the DEV system and export the [...]
View Answer
| November 13, 2005 4:42 PM
Basis, Database, DB2, Oracle, Upgrades / implementations
Connecting to the Database
Have you verified that you have the latest DAO drivers? For development purposes could you make a start with ODBC?
View Answer
| November 10, 2005 4:38 AM
Automated, Data analysis, Database, DataCenter, DB2, DB2 Universal Database, Development, Oracle, Software Quality Assurance, Software testing, Software testing tools, SQL
Have you verified that you have the latest DAO drivers? For development purposes could you make a start with ODBC?
View Answer
| November 10, 2005 4:38 AM
Automated, Data analysis, Database, DataCenter, DB2, DB2 Universal Database, Development, Oracle, Software Quality Assurance, Software testing, Software testing tools, SQL
Java and Oracle
I assume from your question, that you’re not using Java within Oracle. You’re “just” using JDBC to access Oracle. In case of performance problems, it important that you identify the wait causes. Is it the DB that’s busy, or your frontend application that’s slowing things down – or a combination. Reasons for performance problems are [...]
View Answer
| November 9, 2005 11:34 AM
Database, DB2, Oracle, SQL
I assume from your question, that you’re not using Java within Oracle. You’re “just” using JDBC to access Oracle. In case of performance problems, it important that you identify the wait causes. Is it the DB that’s busy, or your frontend application that’s slowing things down – or a combination. Reasons for performance problems are [...]
View Answer
| November 9, 2005 11:34 AM
Database, DB2, Oracle, SQL
To add a column to an oracle(8i) table someplace other than the end of the list?
One way (maybe the only way) would be to recreate the table. You could do that by first creating the new table with the columns in the order you want them. Then insert the rows of the old table into the new table (using “Insert into table2 (col1,col2..) select col1,col2.. from table1″). Then rename or [...]
View Answer
| November 9, 2005 9:00 AM
Oracle, SQL
One way (maybe the only way) would be to recreate the table. You could do that by first creating the new table with the columns in the order you want them. Then insert the rows of the old table into the new table (using “Insert into table2 (col1,col2..) select col1,col2.. from table1″). Then rename or [...]
View Answer
| November 9, 2005 9:00 AM
Oracle, SQL
installation of oracle8i
Hi, First check, if the 8i database is mounted. If the database is not mounted use SVRMGRL oracle command to mount the database. If database is mounted then check access to the database using userid – ‘sys’ or ‘system’
View Answer
| November 9, 2005 7:00 AM
Oracle
Hi, First check, if the 8i database is mounted. If the database is not mounted use SVRMGRL oracle command to mount the database. If database is mounted then check access to the database using userid – ‘sys’ or ‘system’
View Answer
| November 9, 2005 7:00 AM
Oracle
Accessing Oracle database on Linux from Mainframe
Do you have Oracle s/w for installing the client on the linux box? That’s the first step. Then is configuring the tnsnames.ora, listener.ora and sqlnet.ora files (help is around, such as http://www.orafaq.com/faqnet.htm). (I assume you ping the box, if not, you should get that to work first) You will need to ask for the database [...]
View Answer
| November 3, 2005 11:14 AM
AS/400, DB2 Universal Database, Linux, Oracle
Do you have Oracle s/w for installing the client on the linux box? That’s the first step. Then is configuring the tnsnames.ora, listener.ora and sqlnet.ora files (help is around, such as http://www.orafaq.com/faqnet.htm). (I assume you ping the box, if not, you should get that to work first) You will need to ask for the database [...]
View Answer
| November 3, 2005 11:14 AM
AS/400, DB2 Universal Database, Linux, Oracle
accessing oracle application thru internet
If it is an extranet: A) You need to set up a public IP for the server. You can do that in your firewall (it will do the NAT translation of the public IP to the internal network IP of the server) B) In your firewall, you need to open port 8000 for that public [...]
View Answer
| November 3, 2005 3:31 AM
E-business, Oracle
If it is an extranet: A) You need to set up a public IP for the server. You can do that in your firewall (it will do the NAT translation of the public IP to the internal network IP of the server) B) In your firewall, you need to open port 8000 for that public [...]
View Answer
| November 3, 2005 3:31 AM
E-business, Oracle
Is java better thab vb ?
It’s best to know both. Working as a consultant, I’ve had to write a lot of code, and rescue a lot of projects in trouble. I’ve never had to fix bad Java code; just add to it. VB code often involves a lot of fixing. Either way, I have to know both. Where’s the future? [...]
View Answer
| November 3, 2005 2:44 AM
Database, DB2, Oracle
It’s best to know both. Working as a consultant, I’ve had to write a lot of code, and rescue a lot of projects in trouble. I’ve never had to fix bad Java code; just add to it. VB code often involves a lot of fixing. Either way, I have to know both. Where’s the future? [...]
View Answer
| November 3, 2005 2:44 AM
Database, DB2, Oracle
Question about a frequently changing column as primary key
There’s not a hard cutoff line. Having a changing element as a part of a key, primary or not, causes work. The only question is, are you better off indexed or not. You can work out the theory for weeks, or you can try the application with and without the index. Note also that having [...]
View Answer
| November 2, 2005 1:45 PM
Data analysis, Database, DB2, Development, E-business, Ecommerce applications, J2EE, Java, Lifecycle development, Oracle, Programming Languages, SQL, Windows
There’s not a hard cutoff line. Having a changing element as a part of a key, primary or not, causes work. The only question is, are you better off indexed or not. You can work out the theory for weeks, or you can try the application with and without the index. Note also that having [...]
View Answer
| November 2, 2005 1:45 PM
Data analysis, Database, DB2, Development, E-business, Ecommerce applications, J2EE, Java, Lifecycle development, Oracle, Programming Languages, SQL, Windows
VB app connecting to Oracle database
I also do this type of transactions. I don’t think it hurts the database to connect/disconnect. I have found that you have to weigh the problems of each option. The problem with connect/disconnect is that there is a certain amount of wait time for the application to make the connection. If the wait time is [...]
View Answer
| November 2, 2005 11:16 AM
Oracle
I also do this type of transactions. I don’t think it hurts the database to connect/disconnect. I have found that you have to weigh the problems of each option. The problem with connect/disconnect is that there is a certain amount of wait time for the application to make the connection. If the wait time is [...]
View Answer
| November 2, 2005 11:16 AM
Oracle
Performance degraded after changing optimizer mode
Hi, When optimizer values are changed for the instance and tables are analyzed, it takes the server sometime to settle down. Esp. if the tables are being analyzed after a long time. The parser has to generate new explain plan which may or may not be the best plan (depending on the options used with [...]
View Answer
| October 31, 2005 12:55 PM
Oracle, Windows
Hi, When optimizer values are changed for the instance and tables are analyzed, it takes the server sometime to settle down. Esp. if the tables are being analyzed after a long time. The parser has to generate new explain plan which may or may not be the best plan (depending on the options used with [...]
View Answer
| October 31, 2005 12:55 PM
Oracle, Windows
Synchronizing expired merge subscription database with publication database
Hi, Can u specify which database severs ur trying to merge.
View Answer
| October 28, 2005 2:32 PM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Updates from SearchSQLServer.com staff
Hi, Can u specify which database severs ur trying to merge.
View Answer
| October 28, 2005 2:32 PM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Updates from SearchSQLServer.com staff
Help using oracle Analytical function.
Analytic functions are cool; it is however tricky to get them right. The query skeleton below should work for you: select (select count(1) from tab_name where trans_date between sysdate – 7 and sysdate) seven_days_count, (select count(1) from tab_name where trans_date between sysdate – 180 and sysdate) six_month_count from dual ; ++ Olu
View Answer
| October 28, 2005 9:06 AM
Oracle, SQL, Windows
Analytic functions are cool; it is however tricky to get them right. The query skeleton below should work for you: select (select count(1) from tab_name where trans_date between sysdate – 7 and sysdate) seven_days_count, (select count(1) from tab_name where trans_date between sysdate – 180 and sysdate) six_month_count from dual ; ++ Olu
View Answer
| October 28, 2005 9:06 AM
Oracle, SQL, Windows
ORACLE Question – Split data in 90 days chunk
Hi, If you need to aggregate it in 90 days lot ,then just create MVs in oracle with your periodicity required, all further process can be continued from the MVs rather than complex scripts to extarct and calculate. If you are looking more please the full requirement. Regards Deva.
View Answer
| October 28, 2005 3:58 AM
Oracle
Hi, If you need to aggregate it in 90 days lot ,then just create MVs in oracle with your periodicity required, all further process can be continued from the MVs rather than complex scripts to extarct and calculate. If you are looking more please the full requirement. Regards Deva.
View Answer
| October 28, 2005 3:58 AM
Oracle
