Home
Search results “Oracle partition table move”
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: 1775 TechLake
Oracle Tutorial || Oracle|Adv Sql | Partitioned Table Part - 1 by basha
 
33:26
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo.......
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: 7428 BhagyaRaj Katta
Oracle Partitioning
 
18:12
Oracle Partitioning watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
part 15 move partition
 
01:58
move partition, alter table, data warehousing
Oracle Database 12c: Moving Online Data Files
 
04:07
About moving online data files Oracle Database 12c new feature, with examples.
Views: 5399 OracleDBVision
Oracle Partition By clause, Oracle Analytic Functions tutorial
 
09:09
More about analytic functions, visit https://www.youtube.com/watch?v=Ukekis8C-SI&list=PL99-DcFspRUoscBHdh39T8EHENfm2VcQ3&index=2 Oracle Analytic Functions and Over By Partition clause enable calculating cumulative and moving aggregates returning multiple rows for each group.
Compression Options for Oracle Database
 
36:49
Held on August 9 2018 This session by Gregg Christman focuses on general questions and insights regarding Oracle Basic Compression, Oracle OLTP Table Compression and Oracle Advanced Row Compression. Here is a quick guide to the highlights: 2:25 Basic vs. Advanced Row Compression comparison 4:55 Should you expect the same compression ratio with Basic and Advanced Row Compression? 8:29 Should you compress all tables and partitions? 15:50 What is the overhead associated with Advanced Row Compression? 17:06 Do I need to change my application to use compression? 17:31 Who uses Advanced Row Compression? 18:35 Is there any ongoing administration with Advanced Row Compression 20:43 When does updated data get compressed? 26:30 What role does PCTFREE play in updates and compression? 28:44 Does Advanced Row Compression work with Oracle Encryption? 29:34 Does enabling compression online or offline make a difference? 31:38 What are the typical compression ratios with Basic and Advanced Row Compression? 32:56 Are there any suggested MOS notes related to compression? 34:12 Feedback about ACO from customers AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 683 Oracle Developers
Partitioning Basics: Treating your tables like Lego
 
01:03:29
Do you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered yes to any of these questions, partitioning may be for you! With partitioning, you can break a table or index down into smaller more manageable chunks. It can help you perform maintenance on just part of a table or index. You can even move data in and out of tables with quick and easy metadata only operations. We’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and full blown table partitioning. We’ll look at how partitioning affects things under the hood. Finally you'll see some cool demos/tricks around index maintenance and data movement. At the end of this session you’ll have a firm understanding of how partitioning works and know how to make decisions on how and when to implement. You'll learn… • The components of table partitioning and how they fit together • How to make your index maintenance partition aware • How Partition elimination can help your queries • How to split different parts of tables over different storage tiers • How to manage partitions. We'll demo this by implementing the sliding window technique. Brandon Leach is a senior DBA with SurveyMonkey in Palo Alto, CA. He is a frequent speaker at events such as SQLSaturdays, user groups, and more recently the PASS Summit. When not working or at events he can be found spending time with his family and tinkering in his home lab.
Views: 1751 DBAFundamentals
How to Move Object from one Table Space to Another Table Space? | How to Rebuild the Index ?
 
05:03
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: 1196 Oracle PL/SQL World
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/
Oracle Partition By clause, Oracle Analytic Functions tutorial
 
09:09
Oracle Analytic Functions and Over By Partition clause enable calculating cumulative and moving aggregates returning multiple rows for each group
What is a Partition in Oracle and Type of Partitions , Range Partition
 
10:52
What is Partition in Oracle and Type of Partitions Range Partition 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
Views: 3397 TechLake
Partitioning in Oracle - Performance Basics
 
28:35
This is the 2nd video from " Partitioning in Oracle " series, It explains how oracle stores and manages data. What is single Block IO and Multi Block IO ? Why full table scan is better than index access in few cases. The video is very elaborate, I have tried my level best to keep it as simple as possible
Views: 12995 Tech Coach
01 Overview of table Partition in oracle
 
07:26
Partitioning enhances the performance, manageability, and availability of a wide variety of applications and helps reduce the total cost of ownership for storing large amounts of data. Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity. Oracle provides a rich variety of partitioning strategies and extensions to address every business requirement. Moreover, since it is entirely transparent, partitioning can be applied to almost any application without the need for potentially expensive and time consuming application changes. Partitioning allows a table, index, or index-organized table to be subdivided into smaller pieces, where each piece of such a database object is called a partition. Each partition has its own name, and may optionally have its own storage characteristics. From the perspective of a database administrator, a partitioned object has multiple pieces that can be managed either collectively or individually. This gives the administrator considerable flexibility in managing partitioned objects. However, from the perspective of the application, a partitioned table is identical to a non-partitioned table; no modifications are necessary when accessing a partitioned table using SQL queries and DML statements. Partitioning Key ======================== Each row in a partitioned table is unambiguously assigned to a single partition. The partitioning key is comprised of one or more columns that determine the partition where each row will be stored. Oracle automatically directs insert, update, and delete operations to the appropriate partition through the use of the partitioning key. When to Partition a Table ========================== Here are some suggestions for when to partition a table: Tables greater than 2 GB should always be considered as candidates for partitioning. Tables containing historical data, in which new data is added into the newest partition. A typical example is a historical table where only the current month's data is updatable and the other 11 months are read only. When the contents of a table need to be distributed across different types of storage devices. When to Partition an Index ============================= Here are some suggestions for when to consider partitioning an index: Avoid rebuilding the entire index when data is removed. Perform maintenance on parts of the data without invalidating the entire index. Reduce the impact of index skew caused by an index on a column with a monotonically increasing value. Partitioned Index-Organized Tables =================================== Partitioned index-organized tables are very useful for providing improved performance, manageability, and availability for index-organized tables. For partitioning an index-organized table: ============================================ Partition columns must be a subset of the primary key columns Secondary indexes can be partitioned (both locally and globally) OVERFLOW data segments are always equi-partitioned with the table partitions See Also: Oracle Database Concepts for more information about index-organized tables System Partitioning System partitioning enables application-controlled partitioning without having the database controlling the data placement. The database simply provides the ability to break down a table into partitions without knowing what the individual partitions are going to be used for. All aspects of partitioning have to be controlled by the application. For example, an insertion into a system partitioned table without the explicit specification of a partition will fail. System partitioning provides the well-known benefits of partitioning (scalability, availability, and manageability), but the partitioning and actual data placement are controlled by the application. See Also: Oracle Database Data Cartridge Developer's Guide for more information about system partitioning Partitioning for Information Lifecycle Management Information Lifecycle Management (ILM) is concerned with managing data during its lifetime. Partitioning plays a key role in ILM because it enables groups of data (that is, partitions) to be distributed across different types of storage devices and managed individually.
Views: 7494 Md Arshad
Data Warehouse 13 Table Partition Switching
 
35:21
Use table partition switching to greatly improve the performance of DML operations (update,insert,deletes) on a fact table Script and more info: http://garrettedmondson.wordpress.com/2013/05/05/table-partitioning-with-fact-tables/
Views: 9563 Garrett Edmondson
Oracle Tutorial || Oracle|Adv Sql | Partitioned Table Part - 2 by basha
 
33:27
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
SQL Partition By Explained
 
06:42
Using Oracle's SQL, I'll explain how to use Partition By. This will be similar in other SQL engines that have the Partition By keyword.
Views: 35302 Pretty Printed
How to Convert a Non-Partitioned Table to Partitioned using Oracle Database 12c R2
 
05:02
Oracle Database 12c Release 2 New Feature! Learn how to convert a non-partitioned table to a partitioned table - Online! This new method - using ALTER TABLE MODIFY - is much simpler than DBMS_REDEFINITION. In this free tutorial from SkillBuilders and Oracle Certified Master DBA John Watson you'll see a demonstration of converting the table and the impact on the underlying table and indexes. See all our free Oracle Database Tutorials at http://www.skillbuilders.com/free-oracle-tutorials.
Views: 3719 SkillBuilders
PARTITION BY in Oracle SQL  | Oracle SQL Tutorials | By Mr.Murali
 
31:56
PARTITION BY in Oracle SQL | Oracle SQL Tutorials | By Mr.Murali ►For Registration : https://goo.gl/r6kJbB ►Call: +91-8179191999 ► Visit Our Website: http://nareshit.in/ http://nareshit.com/ ► About NareshIT: "Naresh IT is the Best Software Training Institute for Hadoop, Salesforce, AWS, DevOps, Sprak, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in Hyderabad, Chennai and Vijayawada, India which provides online and classroom training classes" ►For Registration : https://goo.gl/r6kJbB ►Call: India- 8179191999, USA- 404-232-9879 Email: [email protected] ►Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5.Share Video's of each and every session. Check The Below Links: ►For Course Reg : https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Visit Our Website: http://nareshit.in/ http://nareshit.com/
Views: 6456 Naresh i Technologies
IO4: Rename, Move, Copy Files with UTL_FILE
 
14:22
UTL_FILE offers a number of high-level subprograms to perform activities like copying a file, renaming a file, and removing a file. Download my demo.zip from v.gd/sfdemo to access and run all referenced scripts. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Overview row movement option with Partitioned table
 
14:56
Overview row movement option with Partitioned table, Oracle Database 11g
Views: 11633 Mahir M. Quluzade
Table Partitioning in Oracle Sql | Oracle Sql Partitioning | Oracle Sql Partitioning Step by Step
 
03:17
Table Partitioning in Oracle Sql | Oracle Sql Partitioning | Oracle Sql Partitioning Step by Step --------------------------------------------------------------------------------------------------------- oracle, partition, partitioning, sql, partitioning in oracle, hash, list, range, interval partition, reference partition, composite partition, index partition, performance, partition pruning, partition wise join, sql server, partition table, sql server table partitioning, table partitioning, sql server partitioning, sql server table partition, table partition, what is partition, partitioned table, advantages of partition, types of partitions, ,table partitioning in sql server 2012 step by step,table partitioning in sql server 2014 step by step,table partitioning in sql server 2016 step by step,partition table sql server 2012 example,sql server partition existing table,sql server partition table by month,table partitioning in sql server 2008 r2 step by step,sql server partitioning best practices,horizontal partitioning in sql server, sql tutorials for beginners, sql expert, sql expert tutorials, database, oracle, table, online training,insert into oracle,oracle insert into multiple rows,create table oracle,oracle 12c alter table add identity column,oracle create table default value sysdate,collections in oracle pl sql with examples,Oracle 12c, database, oracle database (software), sql, sql developer, sql tutorials, how to create database using dbca, how to create database in oracle,oracle cloud, database 12c, dba genesis,database services, database, create, 11g, dba, db, beginner, Please Subscribe My Channel Composite Range-Range Partitioning Composite range-range partitioning enables logical range partitioning along two dimensions; for example, partition by order_date and range subpartition by shipping_date. Composite Range-Hash Partitioning Composite range-hash partitioning partitions data using the range method, and within each partition, subpartitions it using the hash method. Composite range-hash partitioning provides the improved manageability of range partitioning and the data placement, striping, and parallelism advantages of hash partitioning. Composite Range-List Partitioning Composite range-list partitioning partitions data using the range method, and within each partition, subpartitions it using the list method. Composite range-list partitioning provides the manageability of range partitioning and the explicit control of list partitioning for the subpartitions. Composite List-Range Partitioning Composite list-range partitioning enables logical range subpartitioning within a given list partitioning strategy; for example, list partition by country_id and range subpartition by order_date. Composite List-Hash Partitioning Composite list-hash partitioning enables hash subpartitioning of a list-partitioned object; for example, to enable partition-wise joins. Composite List-List Partitioning Composite list-list partitioning enables logical list partitioning along two dimensions; for example, list partition by country_id and list subpartition by sales_channel. Composite Hash-Hash Partitioning Composite hash-hash partitioning enables hash partitioning along two dimensions. This technique is beneficial to enable partition-wise joins along two dimensions. Composite Hash-List Partitioning Composite hash-list partitioning enables hash partitioning along two dimensions. Composite Hash-Range Partitioning Composite hash-range partitioning enables hash partitioning along two dimensions.
Oracle Tutorial || Oracle|Adv Sql | Partitioned Table Part - 4 by basha
 
33:26
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
sub partitioning in oracle  or composite partitioning in Oracle RANGE-LIST, RANGE-HASH
 
07:24
sub partitioning in oracle or composite partitioning in Oracle 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
Views: 856 TechLake
Oracle-How to Transfer Schema to another Oracle Database .
 
05:06
Oracle-How to move Schema from Oracle Database to another. using expdp and impdp commands . By Dia Rashid
Views: 107 Dia Rashid
Reference partitioning in Oracle 11g
 
09:50
The video explains Reference partitioning and its advantages in Oracle with real project example. It builds on the limitations of reference partitioning in oracle 11g (Interval partitioning) and scenarios where you should implement reference partitioning
Views: 2473 Tech Coach
How to move Partitions ONLINE  and make them READ ONLY
 
03:46
The clip demonstrates how to move (compressing) Partitions ONLINE and how to make them READ ONLY. Both are 12c New Features. Text version is here: https://uhesse.com/2017/01/05/how-to-move-partitions-online-and-make-them-read-only-in-oracle-12c/
AskTom TV - Reference Partitioning
 
06:44
blog: https://connor-mcdonald.com Options for how to populate the data in reference partitioned tables efficiently.
Views: 266 Connor McDonald
INDEX PARTITIONING oracle
 
50:56
index partioning in oracle
Views: 435 oracle dba tutorial
Oracle Tutorial || Oracle|Adv Sql | Partitioned Table Part - 3 by basha
 
15:30
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Global Index rebuild scenario in Oracle Database 11g
 
08:41
Why and How we need to rebuild global Index in Oracle 11g
Views: 3668 Athar Fahad
What is a Hash Partition in Oracle
 
09:07
What is a Hash Partition in Oracle 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
Views: 1345 TechLake
part 17 split partition
 
01:56
split partition, data warehousing, alter table
Range Partitioning in Oracle
 
15:00
In this video I have explained what is range partitioning along with it's 2 real project use cases. I have also explained interval Partitioning as an extension of Range partitioning If you have not watched my Initial Videos on partitioning I will recommended watching them before watching this video Apologies for the 10 second video glitch between 6 and 7 minutes :(
Views: 6194 Tech Coach
Loading Data From An External Table in Oracle
 
06:53
Ever need to load data from a text file or Excel file into your Oracle database? This video will show you how.
Views: 4730 Pretty Printed
Partitioning Enhancements in oracle 12c
 
08:33
Oracle has made 4 significant enhancements in 12c. 1.Mixing Interval and Reference partitioning 2.DDL operations on multiple partitions 3.Global Index maintenance 4.Cascade Operations from parent to child, Truncate and drop This video explains the enhancements in detail with practical examples
Views: 2249 Tech Coach
Frgmentation in oracle database
 
34:54
Fragmentation in oracle database,find and defragmentation
Views: 4199 Sainora Annanagar
move table from one tablespace to other
 
08:24
move table from one tablespace to other
Views: 1192 Jamaal Khan
Oracle Tutorial || Oracle|Adv Sql | Interval Partition Part - 1 by basha
 
33:26
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Creating range partition in Oracle 12c - Part 1
 
11:32
Partition makes a table access faster in case of very large table. In this tutorial we have tried to demonstrate the range partition on date.
Views: 229 Subhroneel Ganguly
KISS series on Partitioning: 07 How to create a interval partitioned table
 
05:54
Welcome to the KISS video series on Partitioning, where we take a more developer-centric look at how partitioning can make our applications more successful. In this session, we look at composite partitioning Scripts: https://livesql.oracle.com/apex/livesql/file/content_E1A9RDSCKBO9F0BJHLM914GH1.html blog: https://connor-mcdonald.com ========================================­­============== Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 483 Connor McDonald
How to copy one table records into another new table in oracle
 
02:19
we can copy a table data into a new table easily..with this query I'm going to create one new table student_new with the student table data. Query used in video: create table student_new as select * from student; Thanks for watching...:)
Views: 6340 WingsOfTechnology
part 9 - list partition
 
02:21
list partition, data warehousing, alter table
Hints and Tips - Queries running whilst exchanging partitions - part 1
 
01:44
Even when you rip out a partition from a table, queries can still execute successfully. ========================================­­­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 958 Connor McDonald
KISS series on Partitioning - for Developers
 
02:03
Welcome to the KISS video series on Partitioning, where we take a more developer-centric look at how partitioning can make our applications more successful. In this session, we look at how to create our very first range partitioned table Scripts: https://livesql.oracle.com/apex/livesql/file/content_EM2X7EIHU60Z888IOU53RF0EN.html ========================================­­============== Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1325 Connor McDonald
【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: 68 崔旭
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: 14140 OracleDBVision
part 1 table space
 
04:53
table space, data warehousing, partition,segment,extent,data block
Views: 2156 Dr. Girija Narasimhan