I am trying to write a select looking at DBA_TABLES and DBA_SYNONYMS that will list for me the tables that do not have a public synonym. I have tried using an outerjoin statement, but I get all ta...
http://www.experts-exchange.com/Database/Oracle/Q_24169673.html
Zones:
OracleDate Answered: 03/02/2009 Rating: 9.2 Views: 21
We have Oracle 10G standard edition running RAC, What options will we have to upscale to Enterprise edition in the furture if the need arises?
Any links to case studies and white papers would al...
http://www.experts-exchange.com/Database/Oracle/Q_21874598.html
Zones:
OracleDate Answered: 07/03/2006 Rating: 8.2 Views: 0
Hi Everyone,
My question is regarding the usage/benefits of Global index or local index.
We have 10-12 FACT tables paritioned by date column and have 12 monthly partitions.
Also ...
http://www.experts-exchange.com/Database/Oracle/Q_23623450.html
Hi Experts,
I'm looking into the options of Parallelism in our datawarehouse. We have 4 CPUs in development and 8 CPUs planned in the PROD environment.
The whole datawarehouse has 12 FACT...
http://www.experts-exchange.com/Database/Oracle/Q_23630276.html
Zones:
OracleDate Answered: 08/09/2008 Rating: 8.8 Views: 0
I have multiple Schemas. A combination of Public and Private Synonyms. Here is an example. I need to design Data Zap ID's that can access these objects. I have tried the following Design. Can you ...
http://www.experts-exchange.com/OS/Unix/Setup/Q_24263369.html
Hi,
I have an Oracle 11g instance that I am unable to connect to when I reboot the system. Prior to rebooting, it works fine. Following a reboot, when I go to log in via SQL Plus I get the fol...
http://www.experts-exchange.com/Database/Oracle/11.x/Q_23200061.html
i need link from where i can download
oracle 10g enterprise edition for windows vista 32-bit.
http://www.experts-exchange.com/Database/Oracle/Product_Info/Q_24430412.html
I have the following script to find the DB block location of objects...
SELECT
file_id "File",
block_id "Start",
blocks "Blocks",
owner || '.' || segment_name seg_name,
se...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23469930.html
Zones:
Oracle 10.xDate Answered: 06/10/2008 Rating: 9.3 Views: 0
uname pwd error. Tried sqlplus "/ as sysdba' alter user scott ..it worked, with sql window only. But not when I am trying Database Control - orcl (which opens a webpage, asking Uname pwd). Please ...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23244556.html
Zones:
Oracle 10.xDate Answered: 03/19/2008 Rating: 7.5 Views: 198
i jst installed oracle 10g ee, and i was wondering if someone could give me web-link, & preferable jst write me few steps, so that i could view, manipulate those tables from Database Control -orcl ...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23245559.html
