Home
Search results “Alter index rebuild compress oracle”
How to Shrink table in Oracle..
 
11:52
this video will help how to reclaim space from the table.
Views: 1886 oracdb
Table Shrinking in Oracle Database
 
14:15
1.Shrink the Table: Shrinking is started from 10g. In this method I’m using user u1 and table name sm1. Now I’m deleting some rows in sm1 COUNT ---------- 1048576 Table sm1 has 1048576 rows. [email protected]: delete from sm1 where deptno=10; 262144 rows deleted. I deleted above number of rows. Rows COUNT ---------- 786432 And I’m giving commit [email protected]: commit; Commit complete. So now we have 786432 rows in sm1 table. Now see the following command [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 After I deleted some rows in sm1 table still above result showing same values, so now our duty is shrink this table. This is done by following 2 ways, i By using COMPACT key word: In this method shrinking is done in two phases. In the first phase all fragmented space are just defragmented, but still the High Water Mark is persist with last used block only. That mean used free blocks are not de allocated and HWM is not updated here. Issue the following command before use shrink command. [email protected] alter table sm1 enable row movement; Table altered. There is particular use with above command, when we shrink the table all rows are moves to contiguous blocks, so here row movement should be done. By default the row movement is disabled for any table, so above command enabled the row movement. Then execute shrink command now. [email protected]: alter table sm1 shrink space compact; Table altered. Now see the space of table by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 So here seems nothing happened with above shrink command, but internally the fragmented space is defragmented. But the high water mark is not updated, used free blocks are also not de allocated. For de allocating the used blocks we have to execute below command. This is the second phase. [email protected]: alter table sm1 shrink space; Table altered. Now see the space by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ---------- ---------- ---------- U1 U1TS SM1 TABLE 20.8125 mb 2664 36 So now the space of sm1 table is reduced. Note: Actually the alter table sm1 shrink space command will complete these two phases of the shrinking of table at a time. But here we done shrink process in two phases because when we use alter table sm1 shrink space command the table locked temporarily some time period, during this period users unable to access the table. So if we use alter table sm1 shrink space compact command the table is not locked but space is defragmented. When we not in business hours issue the second phase shrink command then users are won’t get any problem. ii Because of above method the table dependent objects are goes to invalid state, to overcome this problem we have to use below command. [email protected]: alter table sm1 shrink space cascade; Table altered. The above command also shrinks the space of all dependent objects. We also do this in two phases like above two phases. See the below command. [email protected]: alter table sm1 shrink space compact cascade; Table altered. And then [email protected]: alter table sm1 shrink space cascade; Table altered. Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8
Views: 7124 BhagyaRaj Katta
Reorganizing Tables in Oracle
 
07:45
The clip explains why reorganizing of tables may or may not be required and how to do it. Text version is here: https://uhesse.com/2010/08/23/reorganizing-tables-in-oracle-is-it-worth-the-effort/
exchange Partition , Move partition in oracle
 
08:42
exchange Partition , Move partition in oracle Possible operations with partitions SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial Add Drop Rename Split Move ( Moving from Tablespace to tablespace) Exchange (Table to Table(non Partitioned table)) not partitioned only exchanging data (p)
Views: 1513 TechLake
【VDEDU】Unusable indexes use
 
06:29
Unusable indexes in Oracle, DML statements are not use the index to its maintenance, at the same time the optimizer will not use the index. Unusable indexes no segment exists. Unavailable index index becomes available methods are: 1. Place the index can not be truncate operation corresponding table; 2.rebuild index; In addition, the query optimizer can use conversion method expand table so that the SQL statement has encountered unusable index partition table to generate better execution plans.
Views: 65 崔旭
Oracle Database 12c: Partitioning Improvements with Tom Kyte
 
08:08
Tom Kyte introduces the new partitioning improvements in Oracle Database 12c, followed by a demo of global index maintenance. For more information: "Asynchronous Global Index Maintenance for Dropping and Truncating Partitions" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=VLDBG14107 "Changes for Very Large Databases and Partitioning in Oracle Database 12c Release 1" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=VLDBG14100 "ALTER INDEX COALESCE Clause" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF52782 "DBMS_PART.CLEANUP_GIDX Procedure" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=ARPLS74409
Views: 13736 OracleDBVision
Shrink Space
 
06:33
#Oracle #ShrinkSpace
Views: 1892 Hemant K Chitale
3. MS SQL - Adding Indexes to a Table in Management Studio
 
04:02
Adding Indexes to a Table in Management Studio using Microsoft SQL Server
Views: 1684 Barry Solomon
SQL Snacks - Table Partitioning 101
 
10:54
Ayman El-Ghazali www.TheSQLPro.com @TheSQLPro SQL Snacks -Table Partitioning 101 Original Blog Post: http://thesqlpro.com/2014/04/08/sql-snacks-video-sql-server-table-partitioning-101/
Views: 3191 Ayman El-Ghazali
TSQL: ARITHABORT ON and Query Speed
 
04:33
Past video series about this: https://www.youtube.com/watch?v=QRNQG4pC3xc Article mentioned in video: http://www.sommarskog.se/query-plan-mysteries.html
Views: 274 SQLInSix Minutes
SQL Server tutorial 66: Data Manipulation Triggers
 
04:50
How to view triggers on tables. For more info, or a copy of any of the scripts used in any of my tutorials, please email me at [email protected]
Views: 207 Johnny Deluca
SQL Server tutorial 72: How to configure a transactional publisher.
 
06:51
How to configure a transactional publisher with SQL Server 2012. For more info, or a copy of any of the scripts used in any of my tutorials, please email me at [email protected]
Views: 228 Johnny Deluca
How to fix error Could not load file or assembly
 
00:52
Example that shows how to fix the following error Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win64_x64\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified. More Info: http://howtodomssqlcsharpexcelaccess.blogspot.ca/2012/12/how-to-fix-error-cannot-create-activex.html
Views: 79887 Vis Dotnet
File system
 
52:39
In computing, a file system (or filesystem) is used to control how data is stored and retrieved. Without a file system, information placed in a storage area would be one large body of data with no way to tell where one piece of information stops and the next begins. By separating the data into individual pieces, and giving each piece a name, the information is easily separated and identified. Taking its name from the way paper-based information systems are named, each piece of data is called a "file". The structure and logic rules used to manage the groups of information and their names is called a "file system". There are many different kinds of file systems. Each one has different structure and logic, properties of speed, flexibility, security, size and more. Some file systems have been designed to be used for specific applications. For example, the ISO 9660 file system is designed specifically for optical discs. This video is targeted to blind users. Attribution: Article text available under CC-BY-SA Creative Commons image source in video
Views: 374 Audiopedia
Fix CRC Error in RAR Files & Extract Data
 
02:26
http://www.winrarrepair.net/file-crc-error.html - Hello Everyone, This video will show you simple 4-step procedure to extract data from inaccessible RAR file, after encountering CRC errors; which may occur due to bad sectors in the storage disk, virus infection during download or transmission errors. As some people recommend, you may try the Repair tool provided in Winrar under Tools section. However, I didn't find this tool efficient enough to repair the CRC error affected archives. It didn't gave any errors when I tried, but my RAR file was in the same state of corruption. So, what I suggest is, you must try any third-party repair utilities available on the internet. Subscribe my channel to view more about repair process of different types of files. To get the software, visit the site, I have mentioned its link above. Hope I helped you in some way. Good Bye.
Views: 179561 Samuel Acorn