Search results “Alter index rebuild compress oracle”
How to Move Object from one Table Space to Another Table Space? | How to Rebuild the Index ?
This Video will teach you How to Move Object one Table Space to Another | How to Rebuild the Index ? move table from one tablespace to another in oracle 11g oracle move schema to another tablespace oracle how to move objects to another tablespace oracle 11g move schema to another tablespace alter table move tablespace oracle 8i oracle move table script oracle move cluster to new tablespace oracle move table example rebuild index oracle script alter index rebuild online parallel oracle rebuild all indexes oracle index rebuild online vs offline oracle rebuild partitioned index index rebuild oracle best practice index rebuild script in oracle 11g
Views: 812 Oracle PL/SQL World
Table Shrinking in Oracle Database
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: 6512 BhagyaRaj Katta
08 09 Demo   Invisible Indexes
Views: 150 oracle ocm
How to Shrink table in Oracle..
this video will help how to reclaim space from the table.
Views: 1626 oracdb
Oracle Database 12c: Partitioning Improvements with Tom Kyte
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: 12749 OracleDBVision
SQL Server Tutorial 20:  Table, Index and Row Compression
How to use table, index and row compresson with SSMS or T-SQL. For more info, or a copy of the scripts used in this tutorial, please email me at [email protected]
Views: 2871 Johnny Deluca
Checkpoint Revalidate
The REVALIDATE option regenerates the table headers for a partitioned table or uncompressed join index and optionally verifies and corrects the row partitioning for a table (but not for a join index) if you specify the WITH DELETE or WITH INSERT null partition handling options. You can specify the REVALIDATE option for unpartitioned tables and join indexes without also specifying PRIMARY INDEX. This makes revalidation applicable whether or not the table or join index has a primary index. You must specify the REVALIDATE option without also specifying PRIMARY INDEX for NoPI tables and column‑partitioned tables and join indexes. Otherwise, Teradata Database aborts the request and returns an error to the requestor. The REVALIDATE option also provides the ability to revalidate some data dictionary columns. REVALIDATE requests do not verify the column partitioning of a column‑partitioned table or join index. If partitioning errors are detected for a table (but not a join index), an ALTER TABLE REVALIDATE request corrects them. REVALIDATE also revalidates the following Data Dictionary table columns. wave web technology was established in 2012, and has a dynamic team of professional web developers, web designers, SEO experts and customer support . website : www.wavewebtech.com https://www.facebook.com/wavewebtechnologies https://twitter.com/wavewebtechnolo https://plus.google.com/collections/
Views: 5 vikas verma
SQL 2012 Data Compression
Implementing page and row level compression in SQL 2012
Views: 69 DataGriff
SQL Snacks - Table Partitioning 101
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: 2980 Ayman El-Ghazali
SQL Advanced #12: DELETE under the hood
Hi, in this session i finalize my serious about heaps and clustered index. This time it is about delete statements in both table types. Learn about Ghost records (boo!) and stubborn heaps not giving us the precious space back!
Views: 304 SQL TV
Reclaiming free space from innodb tables
Reclaiming free space from innodb tables
Views: 100 Ask Guru
How to fix error Could not load file or assembly
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: 71935 Vis Dotnet
DB2 LUW v10.5: Moving data to DB2 with BLU Acceleration
Video Description: This Skill Builder Video discusses the DB2 tools that can be used to move data to BLU Acceleration, column organized tables. The use of Infosphere Optim Query Workload Tuner for selecting tables to convert to BLU Acceleration based on performance mprovement is demonstrated. Course Links: Implementation and Use of DB2 BLU Acceleration (CL450) http://www-304.ibm.com/services/learning/ites.wss/zz/en?pageType=course_description&courseCode=CL450G&cc= DB2 10.5 for LUW Advanced Database Administration with DB2 BLU Acceleration (CL463) http://www-304.ibm.com/services/learning/ites.wss/zz/en?pageType=course_description&courseCode=CL463G&cc= Other links: Training Paths: http://www-304.ibm.com/services/learning/ites.wss/zz/en?pageType=page&c=P988117I97898D08 Certification Program: http://www.ibm.com/software/data/education/certification.html IBM Certified Database Administrator - DB2 10.5 DBA for LUW Upgrade from DB2 10.1 http://www-03.ibm.com/certify/certs/08002108.shtml IM Certification and Skills: http://www.ibm.com/software/data/education Copyright 2015 IBM Corporation. All rights reserved. IBM, the IBM logo, Cognos, the Cognos logo and other IBM products and services are trademarks of International Business Machines Corporation in the United States, other countries, or both. Excel, Internet Explorer, PowerPoint, SharePoint and Windows are registered trademarks of Microsoft Corporation. Mozilla, the Mozilla logo, Firefox and the Firefox logo are registered trademarks of Mozilla Corporation. Other company, product or service names may be trademarks or service marks of others. iPad® and Apple® are registered trademarks of Apple Inc. The information contained in this video is provided for informational purposes only, and is provided AS IS without warranty of any kind, express or implied. IBM shall not be responsible for any damages arising out of the use of, or otherwise related to, these materials. Nothing contained in these materials is intended to, nor shall have the effect of, creating any warranties or representations from IBM or its suppliers or licensors, or altering the terms and conditions of the applicable license agreement governing the use of IBM software. References in these materials to IBM products, programs, or services do not imply that they will be available in all countries in which IBM operates. Product release dates and/or capabilities referenced in these materials may change at any time at IBM's sole discretion based on market opportunities or other factors, and are not intended to be a commitment to future product or feature availability in any way. Sample data is used in this video to develop sample applications of the IBM Program. These records may contain fictional data manually or machine generated, or factual data compiled from academic or public sources, or data used with permission of the copyright holder. These fictitious records include sample data for sales transactions, product distribution, finance, and human resources. Any resemblance to actual names, addresses, contact numbers, or transaction values is coincidental. Other sample files may contain fictional data manually or machine generated, factual data compiled from academic or public sources, or data used with permission of the copyright holder, for use as sample data to develop sample applications. Product names referenced may be the trademarks of their respective owners. Unauthorized duplication is prohibited.
Views: 98 Dusko Bjelic
Auburn Coach Wife Kristi Malzahn Agrees with Match & eHarmony: Men are Jerks
My advice is this: Settle! That's right. Don't worry about passion or intense connection. Don't nix a guy based on his annoying habit of yelling "Bravo!" in movie theaters. Overlook his halitosis or abysmal sense of aesthetics. Because if you want to have the infrastructure in place to have a family, settling is the way to go. Based on my observations, in fact, settling will probably make you happier in the long run, since many of those who marry with great expectations become more disillusioned with each passing year. (It's hard to maintain that level of zing when the conversation morphs into discussions about who's changing the diapers or balancing the checkbook.) Obviously, I wasn't always an advocate of settling. In fact, it took not settling to make me realize that settling is the better option, and even though settling is a rampant phenomenon, talking about it in a positive light makes people profoundly uncomfortable. Whenever I make the case for settling, people look at me with creased brows of disapproval or frowns of disappointment, the way a child might look at an older sibling who just informed her that Jerry's Kids aren't going to walk, even if you send them money. It's not only politically incorrect to get behind settling, it's downright un-American. Our culture tells us to keep our eyes on the prize (while our mothers, who know better, tell us not to be so picky), and the theme of holding out for true love (whatever that is—look at the divorce rate) permeates our collective mentality. Even situation comedies, starting in the 1970s with The Mary Tyler Moore Show and going all the way to Friends, feature endearing single women in the dating trenches, and there's supposed to be something romantic and even heroic about their search for true love. Of course, the crucial difference is that, whereas the earlier series begins after Mary has been jilted by her fiancé, the more modern-day Friends opens as Rachel Green leaves her nice-guy orthodontist fiancé at the altar simply because she isn't feeling it. But either way, in episode after episode, as both women continue to be unlucky in love, settling starts to look pretty darn appealing. Mary is supposed to be contentedly independent and fulfilled by her newsroom family, but in fact her life seems lonely. Are we to assume that at the end of the series, Mary, by then in her late 30s, found her soul mate after the lights in the newsroom went out and her work family was disbanded? If her experience was anything like mine or that of my single friends, it's unlikely. And while Rachel and her supposed soul mate, Ross, finally get together (for the umpteenth time) in the finale of Friends, do we feel confident that she'll be happier with Ross than she would have been had she settled down with Barry, the orthodontist, 10 years earlier? She and Ross have passion but have never had long-term stability, and the fireworks she experiences with him but not with Barry might actually turn out to be a liability, given how many times their relationship has already gone up in flames. It's equally questionable whether Sex and the City's Carrie Bradshaw, who cheated on her kindhearted and generous boyfriend, Aidan, only to end up with the more exciting but self-absorbed Mr. Big, will be better off in the framework of marriage and family. (Some time after the breakup, when Carrie ran into Aidan on the street, he was carrying his infant in a Baby Björn. Can anyone imagine Mr. Big walking around with a Björn?)
Views: 185345 Shari Wing

A cover letter images
Tk102 application letters
Examples of cover letter for finance jobs
Cover letter for job searching
Custom writing service reviews