Hi, Currently, I am using Oracle 9i (version 220.127.116.11) database now as per my business requirement, I need to upgrade it to Oracle 10g database. Operating System : Windows 2003 Server, 64 Bit I am looking for some help on this, what are the problems being faced at migration time, and finally how to migrate [...]
View Answer | June 4, 2008 11:47 AM
Oracle 10g, Oracle 9i, Oracle developers
Well, basically you have to reproduce in the new server the same layout you have in the original one. I mean paths for datafiles, redo log files, dump files, parameter and password files and so on. This is not mandatory, but it greatly simplifies the operations. So, the first thing you need to do is [...]
View Answer | June 4, 2008 9:18 AM
Clone database, Hot Backup, Oracle, Oracle 10g
You don’t need any specific tool to do a data mart compared to an OLTP database. Toad will work just fine. Many people including myself prefer to use Visio to do this. This gives you a second option.
View Answer | May 31, 2008 9:41 PM
Data mart, Data Model Diagram, Data modeling, Oracle, Oracle Data Mart, Relational databases, Snowflake Schema, Toad Data Modeler
do the following. backup ur alert.log file and then clear it. then run, sqlplus /nolog conn system/<system pwd> as sysdba shutdown abbort startup and then send me ur newly populated alert.log file. also check wether ur problem got fixed or not.
View Answer | May 30, 2008 5:20 AM
Domain management, ORA-01034, ORA-27101, Oracle 9, Oracle administration, Oracle error messages, Windows Server 2003
Hello, as you can read in <a href=”http://www.oracle.com/technology/tech/windows/faq.html”>this article</a> you cannot install it in WindowsXP, hereafter an excerpt of the article: <i> Note: For AMD64/EM64T platform information, refer to this certification matrix. Windows 2000 support indicates support for Professional, Server, Advanced Server, Datacenter editions. Windows XP support indicates support for Professional Edition (32-bit) and XP [...]
View Answer | May 28, 2008 4:53 PM
Oracle 7, Windows XP
You will want to check with Oracle to be sure, but the last I heard they change .75 CPUs per core. For for a single chip dual core machine they change the equivalent of 1.5 CPU licenses.
View Answer | May 27, 2008 9:19 PM
Oracle Enterprise Edition, Oracle licensing
It sounds to me like maybe the input parameters are not being passed in correctly. You might want to output the values of the variables you are passing in to make sure that they are being processed correctly.
View Answer | May 27, 2008 1:39 AM
Oracle 10g, Oracle stored procedures, SQL Server Reporting Services, SSRS 2005, Stored Procedures
You can use the SUBSTR and INSTR functions to do this. <pre>SELECT SUBSTR(NameColumn, 1, INSTR(NameColumn, ‘ ‘, 1, 1)) FROM Table;</pre> (This is untested.)
View Answer | May 26, 2008 7:36 PM
This will work but keeping the data synced between the two schemas will be difficult. It’s much easier to keep everything in a single schema. What’s the cause of the month end update statement taking so long? Are the tables indexed correctly? Are there indexes which can be removed? Are the disks queueing to much? [...]
View Answer | May 23, 2008 5:42 PM
It could be any number of things. Disk speed, CPU power, etc will probably be the biggest variables.
View Answer | May 23, 2008 4:59 PM
Linux, Oracle, Oracle performance, Windows NT
Use a for loop with an implicit cursor create or replace delete_procedure is begin For cost_rec in (first select statment) loop if cost_rec.active_date = cost_rec.bdate+5 then first delete statement; end if; end loop; For cost_rec in (second select) loop if (2nd delete criteria) then 2nd delete statement; end if; end loop; commit; end delete_procedure;
View Answer | May 22, 2008 7:45 PM
Oracle developers, PL/SQL
With about 99% of the applications out there, yes you can do this. You simply install the application on the second server and when configuring it set the database connection to be the remote database server name and username and password. Check with Oracle and make sure that the E-business suit supports being installed on [...]
View Answer | May 22, 2008 4:05 PM
Database administration, Database security, Oracle, Oracle 9, Oracle E-Business Suite, Oracle security, Shared databases, Solaris, Solaris 10
Your before and after datatype and data width are both the same. What’s the initial and working datatype and data width?
View Answer | May 22, 2008 4:02 PM
ASP.NET, C#, ORA-01406, Oracle, Oracle 9i, Oracle error messages
for setting preferred credentials, first on windows go to settings>control panel> administrative tools> local security policy>local policy> local right assignment and then select logon as batch job, and add ur windows user in that right group. then schedule ur job in EM control by providing the same windows user name as the prefered OS authentic [...]
View Answer | May 21, 2008 3:59 AM
DBCA, Oracle 10g, Oracle 10g R2, Preferred credentials, Windows Server 2003
INSERT INTO FILENAME1 (SELECT * FROM FILENAME2) Thanx Reshma
View Answer | May 19, 2008 12:14 PM
I found the quickest way to refresh a database is to copy all files (datafiles, control files, redo log files) via the operating system (UNIX in my case) and then startup the copied database via Oracle. If you need more details, I can provide you with necessary script files. Sitansu S. Mittra Could you please [...]
View Answer | May 19, 2008 9:48 AM
Running any database in a Virtual machine (either VMware or Microsoft) will not perform well under load. Virtual Machines use virtual disks for storage which adds an additional layer of processing which has to happen before the data can be written. In addition your memory and CPU are not all your own, so this can [...]
View Answer | May 17, 2008 12:31 AM
Database, Microsoft Virtual Server, Oracle 10g, SQL Server
The version of SQL Server that you are running will tell you which objects you need to look at. There were lots of changes between SQL 2000 and SQL 2005. In SQL 2000 you can use this SELECT statement <pre>select user_name(p.grantor) as GRANTOR ,user_name(p.uid) as GRANTEE ,db_name() as TABLE_CATALOG ,user_name(o.uid) as TABLE_SCHEMA ,o.name as TABLE_NAME [...]
View Answer | May 15, 2008 8:07 PM
Oracle, SQL Server
Update 5/14 Looks like the race is heating up. <a href=”http://itknowledgeexchange.techtarget.com/profile/Labnuke99″>Labnuke99</a> has taken the lead over <a href=”http://itknowledgeexchange.techtarget.com/profile/Gilly400″>Gilly400</a> but there is a battle starting for 3rd place between <a href=”http://itknowledgeexchange.techtarget.com/profile/Vlvpk”>Vlvpk</a> <a href=”http://itknowledgeexchange.techtarget.com/profile/Ysrd”>Ysrd</a> <a href=”http://itknowledgeexchange.techtarget.com/profile/Bvining”>Bvining</a> Still allot of time left so it is anyones contest to win. UPDATE 5/9 The contest is heating up between Labnuke99 [...]
View Answer | May 14, 2008 3:04 PM
AS/400, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Networking, Oracle, SAP, SQL Server, Storage, Virtualization, VoIP
You need to connect to the database using an internal database user id. If you don’t have a Management Server setup, try launching OEM, Standalone, and try connecting as SYSTEM or SYS or another internal userid.
View Answer | May 14, 2008 3:03 PM
Administrative privileges, Oracle, Windows Server 2003