How can I update a huge Oracle table containing 4 billion records
You can use the following Merge Statment to update the table, the for loop will take huge resources. The INSERT INTO Clause is optional if you are using Oracle 10g and the Merge Statment only work with versions above 9i. MERGE INTO cdrdata_new a USING (SELECT rowid, to_date(to_char(to_date(cdr_rec.charging_date,’dd-mon-rr’)||’ ‘||cdr_rec.timestamp),’dd-mon-rrrr hh24miss’) ntime FROM cdrdata_new ) b [...]
View Answer
| November 16, 2006 10:00 AM
Oracle, Oracle 10g
You can use the following Merge Statment to update the table, the for loop will take huge resources. The INSERT INTO Clause is optional if you are using Oracle 10g and the Merge Statment only work with versions above 9i. MERGE INTO cdrdata_new a USING (SELECT rowid, to_date(to_char(to_date(cdr_rec.charging_date,’dd-mon-rr’)||’ ‘||cdr_rec.timestamp),’dd-mon-rrrr hh24miss’) ntime FROM cdrdata_new ) b [...]
View Answer
| November 16, 2006 10:00 AM
Oracle, Oracle 10g
DB Migration from 8.1.7 to 10gR1
Think backwards. Leave 8i up as production and progress your changes to the 10g database, using 10g as parallel. Once you are assured that all transactions work, then convert finally to 10g and archive the old 8i database. Do not be too fast to make 10g production. Second question – best practices. Create a test [...]
View Answer
| November 15, 2006 2:46 PM
CRM, Database, DB2, Oracle
Think backwards. Leave 8i up as production and progress your changes to the 10g database, using 10g as parallel. Once you are assured that all transactions work, then convert finally to 10g and archive the old 8i database. Do not be too fast to make 10g production. Second question – best practices. Create a test [...]
View Answer
| November 15, 2006 2:46 PM
CRM, Database, DB2, Oracle
Oracle Parse – Instr
To get two results back, use two functions, a function that returns a composite object (such as a record), or a procedure with two OUT parameters. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linkersystems.com) 800-315-1174 (+1-949-552-1904)
View Answer
| November 15, 2006 10:48 AM
Database, DB2, Oracle, SQL
To get two results back, use two functions, a function that returns a composite object (such as a record), or a procedure with two OUT parameters. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linkersystems.com) 800-315-1174 (+1-949-552-1904)
View Answer
| November 15, 2006 10:48 AM
Database, DB2, Oracle, SQL
How to update a oracle table containing 4 billion records
To get the best possible speed, (1) use a single update instead of a cursor loop and (2) convert the timestamp to a fraction of a day, and add that to a date without TO_CHAR or TO_DATE conversion. (If you were to use such conversions, YYYY is better than RR, and numeric months are better [...]
View Answer
| November 15, 2006 10:44 AM
Oracle, Oracle 10g
To get the best possible speed, (1) use a single update instead of a cursor loop and (2) convert the timestamp to a fraction of a day, and add that to a date without TO_CHAR or TO_DATE conversion. (If you were to use such conversions, YYYY is better than RR, and numeric months are better [...]
View Answer
| November 15, 2006 10:44 AM
Oracle, Oracle 10g
Executing a Function or Procedure from ouside Oracle
consider the following: declare …. v_passfail interger ; TIRE_ID_EXTRACT integer ; begin …. SELECT V_TIRE_ID_EXTRACT into TIRE_ID_EXTRACT FROM T_TOTALE where rownum = 1 ; v_passfail := F_T_TOTALE_TO_T_SCRAP_SC(TIRE_ID_EXTRACT) ; ….
View Answer
| November 14, 2006 10:41 AM
Oracle, Oracle 9i, Oracle development, SQL, Windows
consider the following: declare …. v_passfail interger ; TIRE_ID_EXTRACT integer ; begin …. SELECT V_TIRE_ID_EXTRACT into TIRE_ID_EXTRACT FROM T_TOTALE where rownum = 1 ; v_passfail := F_T_TOTALE_TO_T_SCRAP_SC(TIRE_ID_EXTRACT) ; ….
View Answer
| November 14, 2006 10:41 AM
Oracle, Oracle 9i, Oracle development, SQL, Windows
Table not using index
Hi, You get no index usage because you indexed a column but you are querying it via an expression. To enable the usage of an index you must not use the index expression (here: the column) in an expression. From the way your query is written I assume the type of the new date_time column [...]
View Answer
| November 13, 2006 5:03 AM
Oracle, Oracle development
Hi, You get no index usage because you indexed a column but you are querying it via an expression. To enable the usage of an index you must not use the index expression (here: the column) in an expression. From the way your query is written I assume the type of the new date_time column [...]
View Answer
| November 13, 2006 5:03 AM
Oracle, Oracle development
Testing how long an SQL script will takfe to run
Test the scripts in a test environment (wiht small proportionally tables) and turn on the timing session parameter with “set timing on;” or capture the begining and the end of the execution whit a “spool command” or “set serveroutput on 10000; and the dbms_output package.” to printscreen the result.
View Answer
| November 8, 2006 3:12 PM
Database, DB2, Oracle
Test the scripts in a test environment (wiht small proportionally tables) and turn on the timing session parameter with “set timing on;” or capture the begining and the end of the execution whit a “spool command” or “set serveroutput on 10000; and the dbms_output package.” to printscreen the result.
View Answer
| November 8, 2006 3:12 PM
Database, DB2, Oracle
OPNQRYF’s MAPFLD
MAPFLD(@NEW ‘%max(A,B)’)
View Answer
| November 8, 2006 9:04 AM
Application development, AS/400, Data analysis, Database, DB2, DB2 Universal Database, IBM, IBM Marketing Sound Off, Oracle, RPGLE
MAPFLD(@NEW ‘%max(A,B)’)
View Answer
| November 8, 2006 9:04 AM
Application development, AS/400, Data analysis, Database, DB2, DB2 Universal Database, IBM, IBM Marketing Sound Off, Oracle, RPGLE
MS SQL Server 2000
You need public IP for that SQL server machine if your server is located behide firewall u need to config your firewall to redirect to SQL server machine with specific port that sql server use.
View Answer
| November 8, 2006 1:37 AM
Access, Application development, Backup & recovery, CLP, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, DB2 Universal Database, Desktops, Email, IBM Marketing Sound Off, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Servers, SQL, SQL Server, Web development
You need public IP for that SQL server machine if your server is located behide firewall u need to config your firewall to redirect to SQL server machine with specific port that sql server use.
View Answer
| November 8, 2006 1:37 AM
Access, Application development, Backup & recovery, CLP, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, DB2 Universal Database, Desktops, Email, IBM Marketing Sound Off, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Servers, SQL, SQL Server, Web development
Table Level Triggers – Triggers on Two Fields Within the Same Table
It may sound obvious, but have you verified that the trigger has been added to the file and if so that it has not been disabled. (re: http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/dbp/rbafotrgncmd.htm)
View Answer
| November 1, 2006 9:49 AM
Development, Geographic information systems applications, Oracle
It may sound obvious, but have you verified that the trigger has been added to the file and if so that it has not been disabled. (re: http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/dbp/rbafotrgncmd.htm)
View Answer
| November 1, 2006 9:49 AM
Development, Geographic information systems applications, Oracle
security problem
The answer is simple. The company who owns the computer has the right to monitor all business conducted on that computer wheather it is business related or not. Most employees think that the pc belongs to them and the have the right to do with it as they please. The pc is there as a [...]
View Answer
| October 31, 2006 7:00 AM
Access control, Application security, backdoors, Backup & recovery, Biometrics, Browsers, Career development, Compliance, configuration, CRM, Current threats, Data analysis, Database, DataCenter, DataManagement, DB2, Desktop management applications, Development, DHCP, Digital certificates, Disaster Recovery, DNS, Ecommerce applications, Encryption, Enterprise Desktop, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intel, Interoperability, Intrusion management, LANDesk, Lotus Domino, McAfee, Microsoft Systems Management Server, Microsoft Windows, Mobile security, Network security, Networking, Networking services, Oracle, patching, PC/Windows Connectivity, PEN testing, Platform Security, Policies, Postini, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Software, Spam, Spyware, SSL/TLS, Symantec, Systems management software, Tech support, Trojans, Vector Networks, Viruses, VPN, vulnerability management, Web security, Wireless, worms
The answer is simple. The company who owns the computer has the right to monitor all business conducted on that computer wheather it is business related or not. Most employees think that the pc belongs to them and the have the right to do with it as they please. The pc is there as a [...]
View Answer
| October 31, 2006 7:00 AM
Access control, Application security, backdoors, Backup & recovery, Biometrics, Browsers, Career development, Compliance, configuration, CRM, Current threats, Data analysis, Database, DataCenter, DataManagement, DB2, Desktop management applications, Development, DHCP, Digital certificates, Disaster Recovery, DNS, Ecommerce applications, Encryption, Enterprise Desktop, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intel, Interoperability, Intrusion management, LANDesk, Lotus Domino, McAfee, Microsoft Systems Management Server, Microsoft Windows, Mobile security, Network security, Networking, Networking services, Oracle, patching, PC/Windows Connectivity, PEN testing, Platform Security, Policies, Postini, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Software, Spam, Spyware, SSL/TLS, Symantec, Systems management software, Tech support, Trojans, Vector Networks, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Thin Provisioning ?
Hi! Ther’re different suppliers from these FC sites, the vendors are EMC and SUN/STK. Personally I am very contented with both, since they give to a correct solution and apropiedad for each enviroments. EMC with SUN, we can say, that they aregiving solutions to great level, multi-platform. Pep
View Answer
| October 30, 2006 2:35 AM
AIX, FC SAN, Oracle SQL, Thin provisioning, Windows Server 2003
Hi! Ther’re different suppliers from these FC sites, the vendors are EMC and SUN/STK. Personally I am very contented with both, since they give to a correct solution and apropiedad for each enviroments. EMC with SUN, we can say, that they aregiving solutions to great level, multi-platform. Pep
View Answer
| October 30, 2006 2:35 AM
AIX, FC SAN, Oracle SQL, Thin provisioning, Windows Server 2003
ORA-12535
Good morning. Have you checked your sqlnet.log files on the remote systems? Any errors encountered during connections should be logged there. Also, have you turned on tracing? This could also help diagnose the problem. One last question: Has anything changed in your environment (network, Oracle upgrades, DNS routing) which could potentially impact this? I hope [...]
View Answer
| October 27, 2006 7:14 AM
Architecture/Design, Availability, Data/Application Integration, Oracle 9i, Performance/Tuning, Windows
Good morning. Have you checked your sqlnet.log files on the remote systems? Any errors encountered during connections should be logged there. Also, have you turned on tracing? This could also help diagnose the problem. One last question: Has anything changed in your environment (network, Oracle upgrades, DNS routing) which could potentially impact this? I hope [...]
View Answer
| October 27, 2006 7:14 AM
Architecture/Design, Availability, Data/Application Integration, Oracle 9i, Performance/Tuning, Windows
ODBC connections
you have to know what kind of database it is so you can pick the correct provider when creating an ODBC data source. Once you create the data source, you can use Access to open up that data source.
View Answer
| October 25, 2006 9:36 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
you have to know what kind of database it is so you can pick the correct provider when creating an ODBC data source. Once you create the data source, you can use Access to open up that data source.
View Answer
| October 25, 2006 9:36 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
Tools for DDS to DDL migration
You should not have to migrate your DDS to DDL or create special indexes. When running your SQL the system will look for similar LF’s or create an index on the fly using your where and order by statements. You can do SQL statements from the iSeries to get data off other platforms and should [...]
View Answer
| October 24, 2006 4:21 PM
Application development, Database, DB2, DB2 Universal Database, Oracle
You should not have to migrate your DDS to DDL or create special indexes. When running your SQL the system will look for similar LF’s or create an index on the fly using your where and order by statements. You can do SQL statements from the iSeries to get data off other platforms and should [...]
View Answer
| October 24, 2006 4:21 PM
Application development, Database, DB2, DB2 Universal Database, Oracle
Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g
If you can, start up the old 8i database and see if the application connects to it. That way you’ll at least know if something is still looking for the old one or if the error is caused by a misconfiguration with the new one.
View Answer
| October 24, 2006 3:14 PM
Architecture/Design, Backup & recovery, Data/Application Integration, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, SQL, Tech support, Windows
If you can, start up the old 8i database and see if the application connects to it. That way you’ll at least know if something is still looking for the old one or if the error is caused by a misconfiguration with the new one.
View Answer
| October 24, 2006 3:14 PM
Architecture/Design, Backup & recovery, Data/Application Integration, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, SQL, Tech support, Windows
VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition
I’m in the process of migrating to VB.Net from VB 6 and I’ve seen this functionality in the Express Ddition. From what I can tell the Express Edition is the same as the Pro Edition of VS 2005 without all the other tools of VS. Good luck.
View Answer
| October 24, 2006 8:13 AM
7 and earlier, Access, ASP.NET, Database, DataCenter, DB2, Desktops, Development, Lifecycle development, Management, Microsoft Office, Microsoft Windows, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle Database Versions, OS, Patch management, Programming Languages, Security, Servers, SQL, SQL Server, Visual Basic, Windows
I’m in the process of migrating to VB.Net from VB 6 and I’ve seen this functionality in the Express Ddition. From what I can tell the Express Edition is the same as the Pro Edition of VS 2005 without all the other tools of VS. Good luck.
View Answer
| October 24, 2006 8:13 AM
7 and earlier, Access, ASP.NET, Database, DataCenter, DB2, Desktops, Development, Lifecycle development, Management, Microsoft Office, Microsoft Windows, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle Database Versions, OS, Patch management, Programming Languages, Security, Servers, SQL, SQL Server, Visual Basic, Windows
R2
I’m assuming your referring to Windows Server Longhorn, the next generation of server after Win2k3 Server. The answer is yes, it is compatible.
View Answer
| October 21, 2006 1:33 AM
Application security, Backup & recovery, Billing and customer care, Billing Support Systems, BlackBerry, Cabling, Database, DataCenter, DB2, Desktops, Development, Encryption, Exchange, Handheld, Hardware, Hewlett-Packard Application Server, Instant Messaging, Linux, Management, Microprocessors, Microsoft Windows, Networking, NIC, Oracle, OS, Palm OS, Power management, Printers, Remote management, Routers, Secure Coding, Security, Servers, Software, SQL Server, Storage, Tech support, Veritas, Windows Mobile, Wireless
I’m assuming your referring to Windows Server Longhorn, the next generation of server after Win2k3 Server. The answer is yes, it is compatible.
View Answer
| October 21, 2006 1:33 AM
Application security, Backup & recovery, Billing and customer care, Billing Support Systems, BlackBerry, Cabling, Database, DataCenter, DB2, Desktops, Development, Encryption, Exchange, Handheld, Hardware, Hewlett-Packard Application Server, Instant Messaging, Linux, Management, Microprocessors, Microsoft Windows, Networking, NIC, Oracle, OS, Palm OS, Power management, Printers, Remote management, Routers, Secure Coding, Security, Servers, Software, SQL Server, Storage, Tech support, Veritas, Windows Mobile, Wireless
dynamic visual basic form based on access database table
Have you looked at the listview control. it has many different styles that probably would fit the bill. it certainly would make programming it a lot easier.
View Answer
| October 18, 2006 4:07 PM
Access, Database, DB2, Development, Oracle, VBA, Visual Basic
Have you looked at the listview control. it has many different styles that probably would fit the bill. it certainly would make programming it a lot easier.
View Answer
| October 18, 2006 4:07 PM
Access, Database, DB2, Development, Oracle, VBA, Visual Basic
Urgent Help
There is no answer to this question. Performance is affected by space definitions for each table (INITIAL/NEXT) or for the entire tablespace. Read Oracle’s documentation on CREATE TABLE and CREATE TABLESPACE for clarification. Performance on a database with only ONE tablespace will depend on the placement physically of tables and indexes (i.e., primary and foreign [...]
View Answer
| October 18, 2006 12:08 PM
ECC5, Oracle administration, Oracle database administration, Oracle database availability
There is no answer to this question. Performance is affected by space definitions for each table (INITIAL/NEXT) or for the entire tablespace. Read Oracle’s documentation on CREATE TABLE and CREATE TABLESPACE for clarification. Performance on a database with only ONE tablespace will depend on the placement physically of tables and indexes (i.e., primary and foreign [...]
View Answer
| October 18, 2006 12:08 PM
ECC5, Oracle administration, Oracle database administration, Oracle database availability
