Loading CSV files into Oracle tables
There are 6 ways to do it: 1. There is a software, called Oraxel (or something like that) which connect Excel tables with oracle (and vise versa) 2. You could export your Excel tables into Access and link Access – Oracle tables through ODBC 3. You could do such export with OEM (Oracle Enterprize Manager) [...]
View Answer
| April 19, 2013 4:13 PM
Corporate Financial Applications, Database Management Systems, ERP, Financials, Human resource applications, Informix, iReceivables, Microsoft Access, Oracle, Payables, Procurement, Projects
There are 6 ways to do it: 1. There is a software, called Oraxel (or something like that) which connect Excel tables with oracle (and vise versa) 2. You could export your Excel tables into Access and link Access – Oracle tables through ODBC 3. You could do such export with OEM (Oracle Enterprize Manager) [...]
View Answer
| April 19, 2013 4:13 PM
Corporate Financial Applications, Database Management Systems, ERP, Financials, Human resource applications, Informix, iReceivables, Microsoft Access, Oracle, Payables, Procurement, Projects
Oracle migration: What is the best approach to migrate a 24/7 8I database to a 9I database in a new box and minimize the downtime ?
Sounds tricky, not sure you can do anything clever with the Oracle redo log files you’d have to check with support, but I doubt it. You could always got for a logical replication type move, using snapshots, but it depends on your data volumes. All systems have quiter periods and you could use that time [...]
View Answer
| March 30, 2005 12:49 PM
Oracle
Sounds tricky, not sure you can do anything clever with the Oracle redo log files you’d have to check with support, but I doubt it. You could always got for a logical replication type move, using snapshots, but it depends on your data volumes. All systems have quiter periods and you could use that time [...]
View Answer
| March 30, 2005 12:49 PM
Oracle
Erros starting SQLPLUS after a no problems installation (oracle)
echo $ORACLE_HOME, $ORACLE_PATH and $PATH. It is likely that your environment is either not set, or is referencing the wrong Oracle Home.
View Answer
| March 30, 2005 5:20 AM
Oracle 10g
echo $ORACLE_HOME, $ORACLE_PATH and $PATH. It is likely that your environment is either not set, or is referencing the wrong Oracle Home.
View Answer
| March 30, 2005 5:20 AM
Oracle 10g
Help with VBA Code for retrieving data from a table in an MS Access Database
u can create a query to ur employee table with the where clause mentioning ur selected employee id, and then binding the fields with the recorset. also if u have the navigation buttons on ur form, u can use the find and move method of the recordset that binds to the navigation buttons, specifing ur [...]
View Answer
| March 30, 2005 3:51 AM
Database, DB2, Oracle, SQL, VBA, Visual Basic
u can create a query to ur employee table with the where clause mentioning ur selected employee id, and then binding the fields with the recorset. also if u have the navigation buttons on ur form, u can use the find and move method of the recordset that binds to the navigation buttons, specifing ur [...]
View Answer
| March 30, 2005 3:51 AM
Database, DB2, Oracle, SQL, VBA, Visual Basic
Locate similar data in different oracle schemas
Hi: You might find what you’re looking for in this guide to lots of Oracle freeware and shareware: http://searchoracle.techtarget.com/tip/1,289483,sid41_gci1057867,00.html Good lukc, Tim
View Answer
| March 24, 2005 10:10 AM
Oracle
Hi: You might find what you’re looking for in this guide to lots of Oracle freeware and shareware: http://searchoracle.techtarget.com/tip/1,289483,sid41_gci1057867,00.html Good lukc, Tim
View Answer
| March 24, 2005 10:10 AM
Oracle
Recovery to a Remote Site
If you still have the controlfile of the database you should be able to use that one instead of the cataloque.
View Answer
| March 24, 2005 2:54 AM
Oracle
If you still have the controlfile of the database you should be able to use that one instead of the cataloque.
View Answer
| March 24, 2005 2:54 AM
Oracle
Oracle 10g Standard on Win 2003 Server Standard – Shutdown database thereafter cannot Startup, require restart
For some reason it works for me if I tnsping the instance and then try again..
View Answer
| March 23, 2005 6:14 PM
Oracle
For some reason it works for me if I tnsping the instance and then try again..
View Answer
| March 23, 2005 6:14 PM
Oracle
Connecting Oracle to Microsoft SQL
If you want to see the Sql Server tables inside Oracle, Use Oracle Transparent gateway to establish the connection to Microsoft using either native Sql Server authentication services or ou can use ODBC. If it is the other way around (seeing Oracle tables from inside Ms Sql server), unfortunately I don’t know how to do [...]
View Answer
| March 23, 2005 4:41 AM
DataCenter, Oracle
If you want to see the Sql Server tables inside Oracle, Use Oracle Transparent gateway to establish the connection to Microsoft using either native Sql Server authentication services or ou can use ODBC. If it is the other way around (seeing Oracle tables from inside Ms Sql server), unfortunately I don’t know how to do [...]
View Answer
| March 23, 2005 4:41 AM
DataCenter, Oracle
TNS PROTOCOL ADAPTER ERROR
We encountered this problem. Make sure the IUSR account and the ASPNET worker process (if your app is .net) has read permissions on the TNSNames.ora file and its parent directories. Worked for us! Cheers!
View Answer
| March 21, 2005 6:57 AM
Oracle Application Server
We encountered this problem. Make sure the IUSR account and the ASPNET worker process (if your app is .net) has read permissions on the TNSNames.ora file and its parent directories. Worked for us! Cheers!
View Answer
| March 21, 2005 6:57 AM
Oracle Application Server
SQL Server equivalent of Oracle’s desc tablename command
sp_columns ‘tablename’
View Answer
| March 15, 2005 2:24 PM
Database Management Systems, MySQL, Oracle, SQL Server
sp_columns ‘tablename’
View Answer
| March 15, 2005 2:24 PM
Database Management Systems, MySQL, Oracle, SQL Server
Oracle 9i Instance and database creation from the command line in WIN NT 2000
First, Windows Authentication is only used if you are connected locally on the server. If you are connected remotely, it will use the password file. If you are issueing the command in a command prompt window, try setting oracle_sid to you SID name before connecting oracle_sid=SID. What version of Oracle are you running?
View Answer
| March 15, 2005 11:43 AM
Oracle 9i
First, Windows Authentication is only used if you are connected locally on the server. If you are connected remotely, it will use the password file. If you are issueing the command in a command prompt window, try setting oracle_sid to you SID name before connecting oracle_sid=SID. What version of Oracle are you running?
View Answer
| March 15, 2005 11:43 AM
Oracle 9i
Versioning and merging products for oracle
We use Harvest as a code repository for pl/sql code and it has served us well. It provides the ability to merge and promote code through multiple environments and install the code in the database via user written processes.
View Answer
| March 15, 2005 9:18 AM
Administration, Application software, Architecture/Design, Automated, Development, Functional, Knowledge management applications, Lifecycle development, Migration, Oracle, Oracle 9i, Performance/Load, Software testing, Software testing tools, Special-purpose software, SQL
We use Harvest as a code repository for pl/sql code and it has served us well. It provides the ability to merge and promote code through multiple environments and install the code in the database via user written processes.
View Answer
| March 15, 2005 9:18 AM
Administration, Application software, Architecture/Design, Automated, Development, Functional, Knowledge management applications, Lifecycle development, Migration, Oracle, Oracle 9i, Performance/Load, Software testing, Software testing tools, Special-purpose software, SQL
Oracle ./runInstaller problem
I have experience of Oracle 8.1.7 (on HP-Unix)- so I can share that with you. While installing Oracle 8.1.7 it asks for the Oracle Inventory and a folder is assigned for the same. The same folder is used as inventory if other patches or upgrades are installed. In your case, you have to check that [...]
View Answer
| March 14, 2005 3:18 AM
Database Management Systems, Oracle, Oracle 9i, Standard Edition
I have experience of Oracle 8.1.7 (on HP-Unix)- so I can share that with you. While installing Oracle 8.1.7 it asks for the Oracle Inventory and a folder is assigned for the same. The same folder is used as inventory if other patches or upgrades are installed. In your case, you have to check that [...]
View Answer
| March 14, 2005 3:18 AM
Database Management Systems, Oracle, Oracle 9i, Standard Edition
what is the best STORAGE solution for ORACLE db – SAN or NAS ?
It depends upon the NAS solution and how you handle failover. Oracle themselves run some large databases on NetApps. I wouldn’t necessarily head to the local computer store and get cheap switches, cheap NAS, and cheap server and expect it to work reliably.
View Answer
| March 13, 2005 5:24 PM
Linux servers, NAS, Oracle 10g, Oracle 9i, SAN
It depends upon the NAS solution and how you handle failover. Oracle themselves run some large databases on NetApps. I wouldn’t necessarily head to the local computer store and get cheap switches, cheap NAS, and cheap server and expect it to work reliably.
View Answer
| March 13, 2005 5:24 PM
Linux servers, NAS, Oracle 10g, Oracle 9i, SAN
Linux based CRM systems
There are several good ones that run in Domino R6.5.3 on top of Linux. http://searchdomino.techtarget.com/tip/1,289483,sid4_gci500563,00.html
View Answer
| March 11, 2005 5:54 PM
Call Centers, CRM, Customer relationship management applications, Data analysis, ERP, Exchange, Linux, Microsoft Windows, Oracle, PeopleSoft, Salesforce.com, SalesLogix, SAP, Siebel
There are several good ones that run in Domino R6.5.3 on top of Linux. http://searchdomino.techtarget.com/tip/1,289483,sid4_gci500563,00.html
View Answer
| March 11, 2005 5:54 PM
Call Centers, CRM, Customer relationship management applications, Data analysis, ERP, Exchange, Linux, Microsoft Windows, Oracle, PeopleSoft, Salesforce.com, SalesLogix, SAP, Siebel
SQL Question
in your WHERE clause there is a subselect that references a column y.CategoryID. the qualifier ‘y’ is not defined in that subselect or in the outer select. You have it defined in a subselect in the FROM clause and that definition is not global.
View Answer
| March 11, 2005 10:33 AM
Oracle
in your WHERE clause there is a subselect that references a column y.CategoryID. the qualifier ‘y’ is not defined in that subselect or in the outer select. You have it defined in a subselect in the FROM clause and that definition is not global.
View Answer
| March 11, 2005 10:33 AM
Oracle
PMP transitioning from tech oriented projects to business oriented projects
Hi It was good to see, your experience. But let me make one point clear, PMI methodologies is platform independant. The process is modified to suit the client’s need and also at same time quality should not be lost, that is best & tough changle in anyone’s career. I agree partical that if a person [...]
View Answer
| March 11, 2005 9:42 AM
Business/IT alignment, Customer relationship management applications, Data analysis, Development, ERP, Financial services applications, Human resource applications, Lifecycle development, Microsoft Windows, Oracle, PeopleSoft, Projects, Salesforce.com, SalesLogix, SAP, Sarbanes-Oxley Act, Siebel, Software Quality Assurance
Hi It was good to see, your experience. But let me make one point clear, PMI methodologies is platform independant. The process is modified to suit the client’s need and also at same time quality should not be lost, that is best & tough changle in anyone’s career. I agree partical that if a person [...]
View Answer
| March 11, 2005 9:42 AM
Business/IT alignment, Customer relationship management applications, Data analysis, Development, ERP, Financial services applications, Human resource applications, Lifecycle development, Microsoft Windows, Oracle, PeopleSoft, Projects, Salesforce.com, SalesLogix, SAP, Sarbanes-Oxley Act, Siebel, Software Quality Assurance
SAPDBA not working in ORACLE database
Hi, Check the Oracle confirguration file in your oracle directlory and also check the .dbenv* and .sapenv* file under your <SID>adm user and ora<SID> user and change the variable accordingly.
View Answer
| March 11, 2005 3:56 AM
Basis, Oracle, SAP
Hi, Check the Oracle confirguration file in your oracle directlory and also check the .dbenv* and .sapenv* file under your <SID>adm user and ora<SID> user and change the variable accordingly.
View Answer
| March 11, 2005 3:56 AM
Basis, Oracle, SAP
Problem Migrating from RBO to CBO.
Have you analyzed all the tables and indexes after migrating from RBO to CBO? If not, I suggest you do this first using DBMS_STAT package and then see the effect.
View Answer
| March 10, 2005 12:07 PM
Oracle
Have you analyzed all the tables and indexes after migrating from RBO to CBO? If not, I suggest you do this first using DBMS_STAT package and then see the effect.
View Answer
| March 10, 2005 12:07 PM
Oracle
Installation of Oracle9i client
Try putting single quotes around your path: ‘c:Program Filesoracle’
View Answer
| March 10, 2005 8:36 AM
Database Management Systems, Oracle
Try putting single quotes around your path: ‘c:Program Filesoracle’
View Answer
| March 10, 2005 8:36 AM
Database Management Systems, Oracle
