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...
CURSOR amd
IS
SELECT SID, NAME, phoneno, CLASS
FROM (SELECT ROWNUM c, SID, NAME, CLASS, phoneno
FROM student
WHERE CLASS = :clas...
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...
I keep getting an error when I tried to create a materialized view. Can someone tell me what is wrong with the sql statement.
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...
Hi, i have exported oracle schema with:
exp system/password file=filename.dmp owner=schema
The export completed successfully with warnings. The warnings were:
Exporting questionable stati...
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...
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...
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 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 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....
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...
