tuning
One thing you could try would be to create the indexes after you insert the records. This will speed up the inserts. Depending on the number of records in the tables and the number of indexes on the tables, the index creation process will probably take longer.
View Answer
| August 31, 2005 5:24 PM
Billing and customer care, Billing Support Systems, Data analysis, Database, DB2, Oracle
One thing you could try would be to create the indexes after you insert the records. This will speed up the inserts. Depending on the number of records in the tables and the number of indexes on the tables, the index creation process will probably take longer.
View Answer
| August 31, 2005 5:24 PM
Billing and customer care, Billing Support Systems, Data analysis, Database, DB2, Oracle
Oracle / ccess
No way I’m aware of to directly access MS Access from Oracle. Oracle has the OMWB (Migration Workbench) utility which will help to convert MS Access to Oracle. http://www.oracle.com/technology/oramag/oracle/02-may/o32tools.html Could also use SQL Loader utility or read as External table (9i) after saving MS Access data as delimited text. Also saw this utility that moves [...]
View Answer
| August 31, 2005 1:15 PM
Oracle
No way I’m aware of to directly access MS Access from Oracle. Oracle has the OMWB (Migration Workbench) utility which will help to convert MS Access to Oracle. http://www.oracle.com/technology/oramag/oracle/02-may/o32tools.html Could also use SQL Loader utility or read as External table (9i) after saving MS Access data as delimited text. Also saw this utility that moves [...]
View Answer
| August 31, 2005 1:15 PM
Oracle
Allow users to kill their own Oracle Sessions
Can you install a Tool (e.g. TOAD) on the End-User’s desktop which they could use to kill their own session through.
View Answer
| August 31, 2005 9:08 AM
Oracle
Can you install a Tool (e.g. TOAD) on the End-User’s desktop which they could use to kill their own session through.
View Answer
| August 31, 2005 9:08 AM
Oracle
oracle cold backup 8.1.7.4 restore to oracle8.1.7.4 Can it be done.
By “cold backup” I assume that you’ve shut down the database and used OS commands to copy the datafiles, logfiles, controlfiles, and parameter file(s). Now, if you restore these files to a machine that is running 8.1.7.4, you will in effect have an incomplete upgrade, as 8.1.7.4 has data dictionary changes as well as program [...]
View Answer
| August 31, 2005 8:05 AM
Oracle 8, Oracle backup, Oracle Cold Backup
By “cold backup” I assume that you’ve shut down the database and used OS commands to copy the datafiles, logfiles, controlfiles, and parameter file(s). Now, if you restore these files to a machine that is running 8.1.7.4, you will in effect have an incomplete upgrade, as 8.1.7.4 has data dictionary changes as well as program [...]
View Answer
| August 31, 2005 8:05 AM
Oracle 8, Oracle backup, Oracle Cold Backup
Help
In what context? When googled you get over 1.2 million hits.
View Answer
| August 30, 2005 4:09 PM
AS/400, Avaya, Business Objects, Call Centers, Career development, Certifications, Cognos, Crystal Reports, Data analysis, Data Junction, Data mining/analysis, Database, DataCenter, Hyperion, IBM, Informatica, Information Builders, Microsoft Windows, NCR, Oracle, PeopleSoft, Sales force automation applications, Salesforce.com, SalesLogix, SAP, Siebel, Training
In what context? When googled you get over 1.2 million hits.
View Answer
| August 30, 2005 4:09 PM
AS/400, Avaya, Business Objects, Call Centers, Career development, Certifications, Cognos, Crystal Reports, Data analysis, Data Junction, Data mining/analysis, Database, DataCenter, Hyperion, IBM, Informatica, Information Builders, Microsoft Windows, NCR, Oracle, PeopleSoft, Sales force automation applications, Salesforce.com, SalesLogix, SAP, Siebel, Training
Utility for copying tables w/constraints and indexes?
Could use Oracle’s Export/Import utility. Tools such as TOAD or HORA will generate this could for you as well.
View Answer
| August 30, 2005 1:11 PM
Oracle
Could use Oracle’s Export/Import utility. Tools such as TOAD or HORA will generate this could for you as well.
View Answer
| August 30, 2005 1:11 PM
Oracle
MS Access – AS400 file transfer
You failed to state which method you want to use to accomplish this, Maually Get external data. Via a Macro or via visual basic.
View Answer
| August 30, 2005 10:37 AM
Database, DB2, Oracle
You failed to state which method you want to use to accomplish this, Maually Get external data. Via a Macro or via visual basic.
View Answer
| August 30, 2005 10:37 AM
Database, DB2, Oracle
The UNIX Idiot
Your DBA is right. Additionally, it be wise to invest about twenty dollars on a small Unix shells book. It will give you details of various switches to those commands: ls, mv, du, grep, more, ps, e.t.c. The kill command can be handy at times. ++ Olu
View Answer
| August 29, 2005 10:27 PM
Database, DB2, Oracle
Your DBA is right. Additionally, it be wise to invest about twenty dollars on a small Unix shells book. It will give you details of various switches to those commands: ls, mv, du, grep, more, ps, e.t.c. The kill command can be handy at times. ++ Olu
View Answer
| August 29, 2005 10:27 PM
Database, DB2, Oracle
IMP / EXP statements from DOS prompt
You’ll probably have to ensure that the environment variable is set to search the oracle installation for EXP and IMP. Control Panel, System, then the advanced tab, and environment variables. The system variables PATH would need to have the ‘oracle_bin’ directory. Example, my install is into C:oracleora92bin Add this, and it’ll find the exp and [...]
View Answer
| August 25, 2005 3:18 AM
Oracle
You’ll probably have to ensure that the environment variable is set to search the oracle installation for EXP and IMP. Control Panel, System, then the advanced tab, and environment variables. The system variables PATH would need to have the ‘oracle_bin’ directory. Example, my install is into C:oracleora92bin Add this, and it’ll find the exp and [...]
View Answer
| August 25, 2005 3:18 AM
Oracle
Export/Import schemas
Q1, Export using statement OWNER=(user1), then import using statement FROMUSER=(user1) and statement TOUSER=(user2). Q2, No need to give authority, as the user1.table1 will become user2.table1. Q3, If OWNER has given grants to their tables, views, etc. then TOUSER would need to do the same if required. Example if user3 has access to user1.table1, they’ll lose [...]
View Answer
| August 25, 2005 3:13 AM
Oracle
Q1, Export using statement OWNER=(user1), then import using statement FROMUSER=(user1) and statement TOUSER=(user2). Q2, No need to give authority, as the user1.table1 will become user2.table1. Q3, If OWNER has given grants to their tables, views, etc. then TOUSER would need to do the same if required. Example if user3 has access to user1.table1, they’ll lose [...]
View Answer
| August 25, 2005 3:13 AM
Oracle
Flashback query
Follow the instructions in ‘Application Developer’s Guide – Fundamentals’, which suggest giving execute privileges on the package to particular users.
View Answer
| August 22, 2005 10:53 AM
Oracle
Follow the instructions in ‘Application Developer’s Guide – Fundamentals’, which suggest giving execute privileges on the package to particular users.
View Answer
| August 22, 2005 10:53 AM
Oracle
Implementing and configuring VPN Server
I would look into buying a SonicWall router and the necessary licenses. There configurations are very easy to set up and their hardware is very reliable and secure. Adding global VPN clients is very easy as well and the documentation on their website is what I use when setting up the VPNs for our various [...]
View Answer
| August 22, 2005 12:59 AM
Availability, Bandwidth, Cabling, DataCenter, Desktop management applications, Desktops, Ethernet, FDDI, Frame Relay, H.323, Hardware, IBM, Intel, Interoperability, InterSystems, IPv4, IPv6, LANDesk, Management, Microsoft Systems Management Server, Microsoft Windows, MPLS, NetBIOS, Network protocols, Networking, Online transaction processing, Oracle, OS, Performance management, Ping, Printers, Routers, Security, Servers, SIP, Software, SQL Server, Sybase, TCP, Tech support
I would look into buying a SonicWall router and the necessary licenses. There configurations are very easy to set up and their hardware is very reliable and secure. Adding global VPN clients is very easy as well and the documentation on their website is what I use when setting up the VPNs for our various [...]
View Answer
| August 22, 2005 12:59 AM
Availability, Bandwidth, Cabling, DataCenter, Desktop management applications, Desktops, Ethernet, FDDI, Frame Relay, H.323, Hardware, IBM, Intel, Interoperability, InterSystems, IPv4, IPv6, LANDesk, Management, Microsoft Systems Management Server, Microsoft Windows, MPLS, NetBIOS, Network protocols, Networking, Online transaction processing, Oracle, OS, Performance management, Ping, Printers, Routers, Security, Servers, SIP, Software, SQL Server, Sybase, TCP, Tech support
Installing Seperate Internet Connection for Managers
Frankly, installing a separate Internet connection for managers only sounds like you’re trying to please management so that they don’t notice that you have a more serious problem. I’m not sure what you mean by “wireless server room”, but it implies that you are running much of your infrastructure over wireless. This is not good [...]
View Answer
| August 21, 2005 2:23 PM
Availability, Bandwidth, Cabling, DataCenter, Desktop management applications, Desktops, Ethernet, FDDI, Frame Relay, H.323, Hardware, IBM, Intel, Interoperability, InterSystems, IPv4, IPv6, LANDesk, Management, Microsoft Systems Management Server, Microsoft Windows, MPLS, NetBIOS, Network protocols, Networking, Online transaction processing, Oracle, OS, Performance management, Ping, Printers, Routers, Security, Servers, SIP, Software, SQL Server, Sybase, TCP, Tech support
Frankly, installing a separate Internet connection for managers only sounds like you’re trying to please management so that they don’t notice that you have a more serious problem. I’m not sure what you mean by “wireless server room”, but it implies that you are running much of your infrastructure over wireless. This is not good [...]
View Answer
| August 21, 2005 2:23 PM
Availability, Bandwidth, Cabling, DataCenter, Desktop management applications, Desktops, Ethernet, FDDI, Frame Relay, H.323, Hardware, IBM, Intel, Interoperability, InterSystems, IPv4, IPv6, LANDesk, Management, Microsoft Systems Management Server, Microsoft Windows, MPLS, NetBIOS, Network protocols, Networking, Online transaction processing, Oracle, OS, Performance management, Ping, Printers, Routers, Security, Servers, SIP, Software, SQL Server, Sybase, TCP, Tech support
Querying GIS Data
You can try something like this: SELECT Street1||? `||Street2||? `||Intersection address FROM your_table group by Street1||? `||Street2||? `||Intersection
View Answer
| August 19, 2005 1:40 PM
Data analysis, Database, DB2, Development, Oracle, Software
You can try something like this: SELECT Street1||? `||Street2||? `||Intersection address FROM your_table group by Street1||? `||Street2||? `||Intersection
View Answer
| August 19, 2005 1:40 PM
Data analysis, Database, DB2, Development, Oracle, Software
Oracle Foreign Keys to Drop
Hi, Just a thought. There are R and P types of constraint. If you use – select a.table_name from user_constraints a where a.constraint_type =’R’ and a.table_name not in (select b.table_name from user_constraints b where b.constraint_type = ‘P’) you might get all lowest child tables.
View Answer
| August 19, 2005 12:30 PM
Oracle, Windows
Hi, Just a thought. There are R and P types of constraint. If you use – select a.table_name from user_constraints a where a.constraint_type =’R’ and a.table_name not in (select b.table_name from user_constraints b where b.constraint_type = ‘P’) you might get all lowest child tables.
View Answer
| August 19, 2005 12:30 PM
Oracle, Windows
Fields indexing
Hi, The table indexing comes to what columns require index. The where clause in DML statement is the first indicator what column or columns need to be indexed. If you have repeated the same set of columns then you might want to use concatenated index up to 5 columns.
View Answer
| August 19, 2005 9:18 AM
Oracle
Hi, The table indexing comes to what columns require index. The where clause in DML statement is the first indicator what column or columns need to be indexed. If you have repeated the same set of columns then you might want to use concatenated index up to 5 columns.
View Answer
| August 19, 2005 9:18 AM
Oracle
Extracting SAP R3 data in custom DW
The question of “best” has to do with what fits your larger process and Enterpise Integration architecture as well as with the character of your data warehouse refreshes (e.g., monthly?, nightly?, transaction by transaction?. For example, if for you Business Objects is the center of multiple feeds from diverse systems, maybe you should think about [...]
View Answer
| August 18, 2005 9:45 AM
Business Objects, Data warehousing applications, Database, DB2, Development, Microsoft Windows, Oracle, SAP, SQL, SQL Server
The question of “best” has to do with what fits your larger process and Enterpise Integration architecture as well as with the character of your data warehouse refreshes (e.g., monthly?, nightly?, transaction by transaction?. For example, if for you Business Objects is the center of multiple feeds from diverse systems, maybe you should think about [...]
View Answer
| August 18, 2005 9:45 AM
Business Objects, Data warehousing applications, Database, DB2, Development, Microsoft Windows, Oracle, SAP, SQL, SQL Server
Synchronization of application servers
What OS? If it’s unix, you might consider rsync
View Answer
| August 16, 2005 8:57 AM
3Com, Access, Active Directory, Apache, AS/400, Availability, Avaya, Bandwidth, Benchmarking, Bind, Cabling, Cisco, Database, DataCenter, DB2, Dell, Desktops, DHCP, DNS, Enterasys, Enterprise Desktop, Ethernet, Exchange, Exchange security, Fault isolation, FDDI, Foundry, Frame Relay, General Directories, Hardware, Hewlett-Packard Application Server, Hubs, IPv4, IPv6, Juniper Networks, LDAP, Linux, Lotus Domino, Lucent, Management, Microsoft Office, Microsoft Windows, MySQL, NetBIOS, Network applications management, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Nortel, Novell NDS, Oracle, OS, Patch management, Performance management, Ping, Protocol analysis, Remote management, Routers, Security, Servers, SQL, SQL Server, Switches, TCP, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, Windows, WINS
What OS? If it’s unix, you might consider rsync
View Answer
| August 16, 2005 8:57 AM
3Com, Access, Active Directory, Apache, AS/400, Availability, Avaya, Bandwidth, Benchmarking, Bind, Cabling, Cisco, Database, DataCenter, DB2, Dell, Desktops, DHCP, DNS, Enterasys, Enterprise Desktop, Ethernet, Exchange, Exchange security, Fault isolation, FDDI, Foundry, Frame Relay, General Directories, Hardware, Hewlett-Packard Application Server, Hubs, IPv4, IPv6, Juniper Networks, LDAP, Linux, Lotus Domino, Lucent, Management, Microsoft Office, Microsoft Windows, MySQL, NetBIOS, Network applications management, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Nortel, Novell NDS, Oracle, OS, Patch management, Performance management, Ping, Protocol analysis, Remote management, Routers, Security, Servers, SQL, SQL Server, Switches, TCP, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, Windows, WINS
ASE Trigger
I don’t know much about ASE, but from what I know about programming for the web in general and sql, I think you need to declare that inserted is a variable, and if it isn’t, then rather than calling for all the records from inserted, you need to call the records from the table. I [...]
View Answer
| August 16, 2005 4:55 AM
Database, DB2, Oracle, SQL
I don’t know much about ASE, but from what I know about programming for the web in general and sql, I think you need to declare that inserted is a variable, and if it isn’t, then rather than calling for all the records from inserted, you need to call the records from the table. I [...]
View Answer
| August 16, 2005 4:55 AM
Database, DB2, Oracle, SQL
Library management system
Try this http://www.mlasolutions.com/
View Answer
| August 15, 2005 4:43 PM
3Com, ABAP, Access, Active Directory, ActiveX, ADA, ASP, ASP.NET, Availability, Avaya, Bandwidth, BASIC, Benchmarking, Bind, C, Cabling, CGI, Cisco, COBOL, ColdFusion, Computer Associates, DataCenter, Dell, Desktops, Development, DHCP, Distribution/logistics applications, DNS, Enterasys, Enterprise Desktop, Ethernet, Fault isolation, FDDI, Foundry, Frame Relay, General Directories, H.323, Hardware, HEAT, Help Desk, Hewlett-Packard, Hubs, IPv4, IPv6, Juniper Networks, LDAP, Lifecycle development, Lotus Domino, Lucent, Management, Microsoft Office, Microsoft Operations Manager, Microsoft Windows, MPLS, NetBIOS, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Nortel, Novell IPX/SPX, Novell NDS, Oracle, OS, Patch management, Performance management, PHP, Ping, Programming Languages, Protocol analysis, Remote management, Routers, SAP, Security, Servers, SIP, Software Quality Assurance, SQL Server, Switches, Systems management software, T-SQL, TCP, Tech support, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, VB.NET, VBA, VBScript, Visual Basic, Windows, WINS, XML
Try this http://www.mlasolutions.com/
View Answer
| August 15, 2005 4:43 PM
3Com, ABAP, Access, Active Directory, ActiveX, ADA, ASP, ASP.NET, Availability, Avaya, Bandwidth, BASIC, Benchmarking, Bind, C, Cabling, CGI, Cisco, COBOL, ColdFusion, Computer Associates, DataCenter, Dell, Desktops, Development, DHCP, Distribution/logistics applications, DNS, Enterasys, Enterprise Desktop, Ethernet, Fault isolation, FDDI, Foundry, Frame Relay, General Directories, H.323, Hardware, HEAT, Help Desk, Hewlett-Packard, Hubs, IPv4, IPv6, Juniper Networks, LDAP, Lifecycle development, Lotus Domino, Lucent, Management, Microsoft Office, Microsoft Operations Manager, Microsoft Windows, MPLS, NetBIOS, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Nortel, Novell IPX/SPX, Novell NDS, Oracle, OS, Patch management, Performance management, PHP, Ping, Programming Languages, Protocol analysis, Remote management, Routers, SAP, Security, Servers, SIP, Software Quality Assurance, SQL Server, Switches, Systems management software, T-SQL, TCP, Tech support, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, VB.NET, VBA, VBScript, Visual Basic, Windows, WINS, XML
