We are trying to use the Oracle SQL Developer software to access an Oracle database. We successfully create a connection to the database, however we couldn't see any table under "Tables" folde...
DATABASE CAN NOT STARTUP AFTER RESTORE
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\Documents and Settings\tauadm>sqlplus /nolog
SQL*Plus: Re...
Hello Experts,
I am trying to create a table with name 123, but it returns me an error msg: ORA-00903: invalid table name. I googled ORA-00903, and it is an error for column names. Is there...
I created 3 materialized views that are not complex and do not have any depencies. I created log tables on all of the views. However, when I execute the refresh command on 2 of the mv I get th...
Hello Experts!
I have very old, relatively large (~80 GB taken by data and indexes) Oracle DB (Oracle8i Enterprise Edition Release 8.1.7.4.0).
Data files for tablespace where data and inde...
We are considering between Oracle 11g Standard Edition and Oracle 11g Standard Edition ONE.
Oracle 11g Standard Edition ONE is cheaper but in future if we upgrade to Oracle 11g Standard Ed...
For my a class project, I'm planning to build a simple web front using Oracle 10g Standard Edition One. One of the modules with be used for authenticating users with static username / passwor...
Hello Gurus,
I need to update three oracle EBS GL tables - GL_JE_BATCHES, GL_JE_HEADERS and GL_JR_LINES. Does anyone have any experience upating these tables? Any general recommendaitons ar...
Hello Experts
I need to recreate index that currently takes space 5,500,000,000 KB on column in table that has about 125 millon rows.
How do I determine minimum required free space in t...
hi experts...
i'm having problem to enable more than 1 column in data block.code attach is for enable 1 column only....
i want the output such:
let say,if i choose Quiz 1 and Quiz 2,th...
Am developing an application in Access 2003 for a pharmaceutical company. Now i have a combo list that shows the product name, quantity and expiry date.
How do i make the stockbalance get upd...
Hi I installed Linux on a x86 environment and Oracle 11g. However, I need to set the Oracle environment variables. Does anyone know how I would do this?
when I query a table that has timestamp in field I am selecting I get the following value:
26-OCT-09 07.36.03.191683 PM
All I want is the date. Is there a display option that would enabl...
I am using Sql Developer 1.5.1
I want to comapre files through file comaprison utility.
I click on the file folder, select two of the files to compare and do Compare With --> Each Other....
