Search results “Move partition tablespace oracle” for the 2013
move table from one tablespace to other
move table from one tablespace to other
Views: 1101 Jamaal Khan
part 15 move partition
move partition, alter table, data warehousing
part 17 split partition
split partition, data warehousing, alter table
part 12 truncate partition
Truncate partition, alter table, data warehousing
part 8 drop partition
drop partition alter table data warehousing
part 18 drop tablespace
tablespace, data warehousing,segment
part 4 date range partition
date range paritition data warehousing range partition
merge partition, alter table, data warehousing
Oracle Database 12c New Features Tutorial - Enhanced Online Move Capabilities
Learn the new features in Oracle Database 12c. In this free tutorial, watch Oracle Certified Master demonstrate the enhanced Online Move capabilities in Oracle 12c - Moving Tablespaces and Datafiles Online! (via dbms_redefinition). See all free tutorials in SkillBuilders 12c series at SkillBuilders.com/OracleTutorials.
Views: 3522 SkillBuilders
DBA lesson 10 - Undo and Flashback
في البداية اعتذر عن عدم وجود صوت لانني بعد ان انتهيت من التسجيل اكتشفت عدم وجود صوت وكل ظني ان الصوت شغال هذا الدرس هو الحديث عن undo & flashback و هي عملية التراجع عن عملية قمنا بها بالداتا بيز وبعض الخصائص والتغيرات التي اجريناها كي ننجح في التراجع تراجعنا عن query تراجعنا عن عملية في جدول تراجعنا عن حذف وتعديل داتا تراجعنا عن حذف جدول تراجعنا عن حذف يوزر بالخطأ على مستوى الداتا بيز
Views: 2274 ayman hamdan
Oracle Database 12c: Moving Online Data Files
About moving online data files Oracle Database 12c new feature, with examples.
Views: 5142 OracleDBVision
part 3 range alphabet
data warehousing, range partition, table space, create table
part 19 compare truncate,drop,coalsec
compare truncate, drop, drop list values, coalesc partition, data warehousing alter table
part 11  modify parition drop values
alter table modify partition, drop values,
rename partition, data warehousing, alter table
part 16 default value add list partition
default value using list partition, alter table, data warehousing
part 9 - list partition
list partition, data warehousing, alter table
part 13 hash partition
HASH ALGORITHM, hash partition, data warehousing create table
Views: 5170 Dr. Girija Narasimhan
23  Mover Tabla de Tablespace-  Alfredo Toloza
En ciertas ocasiones puede ser necesario mover una tabla desde un tablespace a otro, el siguiente video muestra una forma sencilla de hacerlo.
How to use Oracle SQL Loader sqlldr to load data into table from text file
How to use Oracle SQL Loader sqlldr to load data into table from text file create table emp(empno number(10),ename varchar(30)); insert into emp values(10,'asif'); set echo off newpage 0 space 0 pagesize 0 feed off head off trimspool on spool d:\oradata\sqlloader\data.txt select empno || ',' || ename from emp; spool off delete emp; update file named data.txt create a file named control.txt load data infile 'd:\oradata\sqlloader\data.txt' into table emp fields terminated by "," optionally enclosed by '"' ( empno, ename ) sqlldr asif/asif control=d:\oradata\sqlloader\control.txt
Views: 47015 Abbasi Asif
DEMO | Oracle Source Volume Rollback
InMage Scout can rollback the source volume for Oracle
Views: 46 InMageRecovery
Managing User Resources   Quotas and Permissions
Managing User Resources Quotas and Permissions
Views: 135 NaturalSnaps
Oracle Database 12c: Introduction to a Multitenant Environment with Tom Kyte
Tom Kyte introduces Oracle Multitenant in Oracle Database 12c followed by a demo showing: multitenant architecture, moving a pluggable database (PDB) from one multitenant container database (CDB) to another, cloning a PDB, and creating a new PDB. For more information: "Multitenant Architecture" in Oracle® Database Concepts http://www.oracle.com/pls/topic/lookup?ctx=db121&id=CNCPT89233 "Managing a Multitenant Environment" in Oracle® Database Administrator's Guide http://www.oracle.com/pls/topic/lookup?ctx=db121&id=ADMIN13506 "About Common Users and Local Users" in Oracle® Database Security Guide http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DBSEG573
Views: 80977 OracleDBVision
part 14 coalescing hash partition
coalescing hash partition, data warehousing,alter table
Views: 1058 Dr. Girija Narasimhan
Database Tutorial 71 - UGA User Global Area of an Oracle Database - Oracle DBA Tutorial
Database Tutorial 71 - UGA User Global Area of an Oracle Database - Oracle DBA Tutorial What is UGA? User Global Area.
Views: 3169 Sam Dhanasekaran
DBA losson9-Net service and DB link and materialized-Part2
Net service and database link and materialized view
Views: 1534 ayman hamdan
InfoSphere Streams Developer Ed - Section 6 - Advanced Concepts
http://www.ibm.com/bigdata/ Brian Williams, IBM Lab Services, brings us section 6 of Streams Developer Education. In this section Brian discusses: windows, sorting, punctuation and other advanced topics. Music Track title: Clouds, composer: Dmitriy Lukyanov, publisher:Shockwave-Sound.Com Royalty Free
Views: 1176 IBM Analytics
Oracle Database 12c: Creating a Transparently Encrypted Backup
Create an encrypted backup if you need to protect against a possible data breach if the backup media is lost. In this example we demo transparent encryption that depends on a keystore. - After this video, view "Oracle Database 12c: Recovering by Using an Encrypted Backup" Copyright © 2013 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. 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 of merchantability, fitness for a particular purpose, and non-infringement.
Oracle Database 12c: Creating a Role Using Oracle Enterprise Manager Database Express
Demo of how to create a role using EM Express.
Views: 4832 OracleDBVision
Oracle ASM Tutorial from OCM John Watson and SkillBuilders
Learn what Automatic Storage Management is and how it fits into the Oracle Database Storage Model. Part 3 of 9. Watch the other FREE lessons at http://www.skillbuilders.com/oracle-asm-tuning-tutorial to see how and why ASM performs so well. Presenter: John Watson, Oracle Certified Master at SkillBuilders
Views: 12171 SkillBuilders
Database Link
Views: 4321 KannaTech2013Videos
DB2 for z/OS Best Practice: Application Best Practices Specific to DB2 for z/OS Data Sharing
Running applications in a data sharing environment generally follows the same best practices as running any DB2 for z/OS application. Applications have a role to play in continuous availability. Only relatively minor changes are required to avoid locking hot spots. This presentation explores specific best practices of application design and database design in a data sharing environment. It drills into the topics of locking considerations, high-volume inserts, sequential keys, bind options, and batch processing. It also describes how to deploy applications in a data sharing environment with minimal down time.
Views: 1030 World of Db2
Oracle Database 12c: Recovering a Pluggable Database
How to recover a pluggable database in an Oracle 12c multitenant environment.
Views: 5776 OracleDBVision
Considerations for a DB2 Environment
Moving on to slide number 7 so here is a list of considerations for a DB2 environment. So before you actually go head and try to install DB2 on system and get started with setting up an environment. Please take a look at some of these which are very very crucial for functioning from a functional perspective. The first thing that you need to remember is whether to choose physical system or a virtual system. So when we say physical or virtual what it mean is, is a system going to be (( )) or a VM image which is a virtualized or can be focused on physical system.
Views: 34 TechGig
Oracle Database 12c: Creating a User using Oracle Enterprise Manager Database Express
Demo of how to create a user with EM Express.
Views: 36936 OracleDBVision
DB2 for z/OS Best Practice: DB2 for z/OS Data Sharing Tuning Group Buffer Pools
In a data sharing environment, tuning Group Buffer Pools is an important activity for keeping your system running smoothly. First, this web lecture goes through the functions and features of Group Buffer Pools to explain the processes involved in tuning. Then, it will show you a series of reports and explain how to interpret key metrics for Group Buffer Pool tuning. Recommended thresholds are described.
Views: 1283 World of Db2