1)What is the use of inventory?
2) Global inventory is found by checking the oraInst.loc file. How to find the location of Local inventory?
3)Why is every patchset(11.2.0.2) now a full release?
What is the use of Local and Global Partition Index?
View 1 Replies View RelatedRDMS Version : 11.2.0.2
Platfomrm : AIX 6.1
For partitioned tables (RANGE, LIST types ) what are circumstances when a Global or a Local Index become UNUSABLE ? I was told that in some circumstances where the Indexes become UNUSABLE , not even a SELECT query against the table will work. Is this true ? For partitioned tables with Global Index, the global index will be listed in DBA_INDEXES . Right ?
I'm trying to split a table partition.
whether the below syntax are correct.
If local index used
ALTER TABLE SNYT.PART_ESTD
SPLIT PARTITION ESTD_M13_S22 AT ('ESTD', 13, '22')
INTO (PARTITION ESTD_M13_S21, PARTITION ESTD_M13_S22)
update indexes;
(per http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1401247200346349807)
=================================================================
If Global index used
ALTER TABLE SNYT.PART_ESTD
SPLIT PARTITION ESTD_M13_S22 AT ('ESTD', 13, '22')
INTO (PARTITION ESTD_M13_S21, PARTITION ESTD_M13_S22)
UPDATE GLOBAL INDEXES;
Version Info: 11.2 on Solaris 10
I have a partitioned table like below. I want to create a B-Tree index on SALES_RGN column which is neither the part of Primary key or the Partitioned key. Should I create this index as local or Global ?
CREATE TABLE sales_dtl
(
txn_id number (9),
salesman_id number(5),
salesman_name varchar2(30),
sales_rgn varchar2(10), -----------------------------> This column needs to be indexed
sales_amount number(10),
sales_date date,
constraint pk_sales_dtl primary key (txn_id)
[code]....
getting how many local and global indexes on particular oracle table
View 2 Replies View RelatedI have a huge table (about 60 gb) partition over range. The index on this table is global index created on 4 columns together. I have a query which is running very slowly. The explain plan is showing the use of this global index.Explain plan is not showing pstart and pend because the index is global.
View 6 Replies View RelatedI have a global index and I want to convert it to local index.Is there a way to recreate local index with out dropping the global index.
I can create a local index first and then drop the global index. But is there a way to create it with out dropping the global index, just convert it.
SNRCTL> stat LISTENER
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
Start Date 19-JAN-2013 00:50:10
Uptime 0 days 0 hr. 29 min. 51 sec
Trace Level off
Security ON: Local OS Authentication
[code]....
In every oracle documentation for e.g:11.2 Scan and Node TNS Listener Setup Examples [ID 1070607.1] we found the local listener status showing both local-ip and vip. Why is not showing in our case?
How to apply patchset (10.2.5) with no downtime?
My db version is 10.2.4 and OS is hp-ux
I have one query regarding ORACLE 10g RAC.
I have installed 10gRAC [10.2.0.1] on VMware.
now I have requirement to upgarde it this existing RAC setup to 10.2.0.4.
options for me the steps or sequence I need to follow in upgrade path? like first needs to upgarde crs,then fro ASM and lastly for DB something like this.
Platform: windows 64 bit
Oracle database 11.2.0.3
I successfully upgraded my database from oracle 11.2.0.1.0 to 11.2.0.3.0 and the upgrade worked fine. I installed the 11.2.0.3.0 in a new oracle home.
Now my task is to install the latest patch set release on the new oracle home(Make database upto date with latest fixes indeed). I am confused with the available documentations in my oracle support.
As CPU is now considered as a subset of PSU patch, i believe i have to apply the latest PSU only.Is this correct? Is there a step by step guide for applying latest patch?I saw there are 5 PSUs released (latest 11.2.0.3.5), do i need to apply each of them or just this final one?
Give me the latest available patchset/patch(Still not clear) install guide and latest available patch download links.
where I can download patchset to upgrade my database from 10.2.0.3 to 10.2.0.5?
View 1 Replies View RelatedI am testing upgrade from 11.1.0.6 to 11.2.0.2 patchset on linux X86-64 version. And facing the following component related issue.
The following components cannot be upgraded as the corresponding upgrade scripts are missing:
OLAP Analytic Workspace ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/apsdbmig.sql )
OLAP Catalog ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/amddbmig.sql )
Spatial ( /u01/app/oracle/product/11.2.0/dbhome_3/md/admin/sdodbmig.sql )
Oracle OLAP API ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/xoqdbmig.sql )
If you want to upgrade these components, you must first install them, using the OUI, and then re-run the Upgrade Assistant. Do you want to continue with upgrade? Note: If you continue, the above components will not be considered as part of the upgrade process.*
Following is the status of the specified components from 11.1.0.6
COMP_ID COMP_NAME VERSION STATUS
AMD OLAP Catalog 11.1.0.6.0 VALID
SDO Spatial 11.1.0.6.0 VALID
APS OLAP Analytic Workspace 11.1.0.6.0 VALID
Should I install these components while installing 11.2.0.2 patchset prior upgrading? I was unable to find any component installation on OUI.
Also DBUA pre-upgrade asked to remove existing UltraSearch from 11.1.0.6 prior upgrading. Though I removed it, but not sure is that going to hamper the upgraded DB, as I'm not sure of the usage of this component as well.
I have one requirement.I am populating LOV dynamically for the subinventory field in the order form through custom.pll.
If Dropship flag= 'Y' then populate suninv LOV with D1,d2..values.If it is 'N' then populate suninv LOV with w01,w02,....values.This is done and working fine in the form.But If i save dropship flag='Y' and Subinv value is D1 then it saves the record.Now I am changing Drop ship flag as 'N' then 'D1' value appearing in the SUBINV field.and it allow the save changes.
So How can i refresh Lov at the time of making drop ship flag as 'Y'/'N'?
There are two oracle inventory tables, I found that used to pull up data before but not anymore . It is
�INVFV_INV_BY_PERIOD_AND_ITEM�
and �MTL_BIS_INV_BY_PERIOD� .
I need to use all the columns/data that are in these two tables. I am not finding any equivalent table. where can I retrieve these information from?
Select * from INVFV_INV_BY_PERIOD_AND_ITEM;
Select * from MTL_BIS_INV_BY_PERIOD;
I have made the inventory sale program in oracle. Its working from 7 years. Now its speed is very slow.It take much time to execute query.
View 17 Replies View RelatedI have been asked this question once.
How will you find out the list of patches applied to Oracle Database Home without using commands like opatch lsinventory -detal etc...
I think registry$history is a view from where we can find out the list of patches applied.
But I think it will not include all the bug fixes,stand alone or one-off patches.It will mainly list out the CPU patches applied(correct me if I am wrong).
I am trying create one Inventory label report with bar code ,This reports working fine stand alone,Once i am added this report on Oracle Apps concurrent Program ,Output came without bar code.
View 6 Replies View Relatedwhich table do I have to use to get the Inventory On Hand Packed Quantity based on Oracle EBS Suite using backend?
View 2 Replies View Related--- Current Oracle Inventory pointing to the location of C:program FilesOracleInventory.
We are plannig to creat a central inventory for all Oralcle installations into to C:oraagentorainventory.
Does EM have a utility that I can get to scan a set of host machines and their disks and tell me what oracle products are installed? Sort of like that common inventory tool used on windows desktops, but just for Oracle products.
If not EM then any third party tool or some other Oracle tool?
I am having a problem with auto populating different fields based on inventory no. field.. This is a bug giving to me to work on and i not able to figure out how to populate the other fields.
How to set any triggers for the items to auto populate and i am suppose to finish this work today.
I am working on SLES 11 SP2 on zLinux and I am trying to install oracle 11gr2 silently. I was able to install the GI and it is running but when I try to install the oracle binaries I keep getting this error:
[FATAL] [INS-32035] Unable to create a new central inventory directory : /opt/oraInventory.
CAUSE: The central inventory location provided is not empty.
The GI install created /opt/oraInventory and all the files are in there. I even changed the owner from grid:oinstall to oracle:oinstall but that did not work. When I did the install on SLES 11 SP1 I did not get this error.
I am running this command to install oracle:
/runInstaller -silent -ignorePrereq -showProgress -waitForCompletion -responseFile /tmp/db_install.rsp
drwxrwx--- 6 oracle oinstall 4096 Apr 2 10:42 oraInventory
drwxrwx--- 2 oracle oinstall 4096 Apr 2 10:39 ContentsXML
drwxrwx--- 3 oracle oinstall 4096 Apr 2 10:41 backup
drwxrwx--- 2 oracle oinstall 4096 Apr 2 10:41 logs
[code]....
Know the Patch set number to upgrade a Oracle 10.2.0.1 to 10.2.0.5 on Solaris 10 Spark 64bits?
View 1 Replies View RelatedExplain about Global variables in Plsql? What is use of these global variables and where do use these variables?
View 1 Replies View RelatedWhen I installed Oracle 11.g I set 'GlobalDataBaseName' ("orcl.net").SID was "orcl". from where can I invoke 'GlobalDataBaseName' value ?
View 1 Replies View RelatedI have two database DB1 for EBS database and DB2 for Portal database. DB2 is always up.
DB1 uses some Global Temporary tables to write and store session level information.
I have Secondary database also for DB1. Whenever DB1 is down and its secondary database base is up, my requirement is to enable write operation to these Global Temporary Tables. Since secondary database we open Read-Only mode , I can't write to these GTTs.
DB2 is always up so I want to create the copies of these GTTs in DB2 portal database. Is there any harm on doing this.
Is there any harm storing session level information of DB1 database In DB2 database through DB-Link.
If I have owner, table_name is there a query I can issue that will tell me if I have to add the "update global indexes" clause when dropping a partition from a table?
View 1 Replies View Relatedwhat are minimum privilege required to create GTT (Global Temp Table)?
View 7 Replies View Related