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
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
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
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
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
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
For some reason it works for me if I tnsping the instance and then try again..
View Answer | March 23, 2005 6:14 PM
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
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
View Answer | March 15, 2005 2:24 PM
Database Management Systems, MySQL, Oracle, SQL Server
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
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
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
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
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
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
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, 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
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
Try putting single quotes around your path: ‘c:Program Filesoracle’
View Answer | March 10, 2005 8:36 AM
Database Management Systems, Oracle