Difference Between Dictionary Managed and Local Managed Table space.
By: Sugandh | 27 Mar 2015 5:14 pm | 842 times viewed | 1 Comments
What is difference between dictionary managed and local managed tablespace?
Please assist me.
Thanks in advance.
SAP to Boost Up the Oil and Gas SectorSAP as we all know is the market leader the of e-business software solutions in the world. By virtue of using mySAP.com e-business platform, all around the globe the businesses are improving their relationships with their esteemed partners as well as customers. The application allows them to...
SAP ECC6 IDES installation on Windows Server and Oracle 10.2 DatabaseSAP ECC6 IDES installation Before starting the SAP ECC6 IDES Installation u need to check your system wither it is ready for SAP Installation. System Hardware Requirements SAP ECC6 IDES Installation steps Installing Microsoft Loopbck Adapter Update Hosts file. (host name , saptranshost) ...
SAP Installation Hardware Requierment for SAP 4.7, ECC5, ECC6 IDES Non IDESSAP Installation Hardware/System RequirementsSAP 4.7 IDESHDD: 80 GBProcessor: PVI and aboveRAM: 512 MBSAP 4.7 NON IDESHDD: 80 GBProcessor: PVI and aboveRAM: 512 MBSAP ECC5 IDESHDD: 150 GBProcessor: PVI and aboveRAM: 2 GBSAP ECC5 NON IDESHDD: 150 GBProcessor: PVI and aboveRAM: 2 GBSAP ECC6 IDESHDD:...
Dictionary vs Locally Managed Table-Spaces
Hello Experts,May I know what is the difference between dictionary managed tablespace and locally managed tablespace with example?Please share your valuable thoughts so i can proceed further.Thanks...
Query About Single Table-space.
Hello Experts A single tablespace supports maximum of 65,536 datafiles. If i created 10 tablespaces then 10X65,536. Is it right. Another thing is upt to how much size of datafile is...
How to Make Release Space of Table?
Hello Experts, May I know If there is a 10 million rows in table of oracle database and i have deleted 2 million rows and table is not releasing space even after shrinking the table. what to do ? ...
Difference Between NETCA & NETMGR.
Hello Everyone, What is difference between NETCA & NETMGR. Both Utilities work on oracle 10g and 11g. Then what is the differences ? Please share your valuable thoughts.
Comparison Between Two Queries in Oracle?
Hello Oracle Experts,I have two tables one is TAB1 (1000 rows) and other one is TAB2 (10 rows) now select tab1.*,tab2.* from TAB1 ,TAB2 where (tab1.col=tab2.col);select tab1.*,tab2.* from TAB2 ,TAB1...
How to Differentiate Two Tables In Oracle?
Hello SAP Experts,I want to differentiate Tables Identification:There are two types of Data in SAP:1. Master data (GL accounts, customers, vendors, assets, cost elements, cost centers, profit centers...
Query Regarding Temp and Undo Table Space?
Hello Everyone, Can any body provide me the query regarding temp and undo table space? I want to know that, Who is using temp table space and undo. How many session are active, and how many...