steps to relocate a table to a new tablespace
Views: 2968 Wysheid Wysheid
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
في البداية اعتذر عن عدم وجود صوت لانني بعد ان انتهيت من التسجيل اكتشفت عدم وجود صوت وكل ظني ان الصوت شغال هذا الدرس هو الحديث عن undo & flashback و هي عملية التراجع عن عملية قمنا بها بالداتا بيز وبعض الخصائص والتغيرات التي اجريناها كي ننجح في التراجع تراجعنا عن query تراجعنا عن عملية في جدول تراجعنا عن حذف وتعديل داتا تراجعنا عن حذف جدول تراجعنا عن حذف يوزر بالخطأ على مستوى الداتا بيز
Views: 2274 ayman hamdan
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
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
Database Tutorial 71 - UGA User Global Area of an Oracle Database - Oracle DBA Tutorial What is UGA? User Global Area.
Views: 3169 Sam Dhanasekaran
Net service and database link and materialized view
Views: 1534 ayman hamdan
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
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.
Views: 2459 Oracle Learning Library
Demo of how to create a role using EM Express.
Views: 4832 OracleDBVision
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
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
How to recover a pluggable database in an Oracle 12c multitenant environment.
Views: 5776 OracleDBVision
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
Demo of how to create a user with EM Express.
Views: 36936 OracleDBVision
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