Home
Search results “Shrink temp tablespace oracle” for the 2018
Oracle DB - Table Space Data Files
 
37:39
Oracle DB - Table Space Data Files Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Bigfile Tablespace 12c | Oracle Bigfile Tablespace | Create Bigfile Tablespace Oracle 12c Example
 
07:18
Bigfile Tablespace 12c | Oracle Bigfile Tablespace | Create Bigfile Tablespace Oracle 12c Example --------------------------------------------------------------------------------------------------- oracle bigfile tablespace advantages,create bigfile tablespace oracle 12c example,how to resize bigfile tablespace in oracle,bigfile tablespace 12c,oracle bigfile tablespace performance issues,oracle bigfile tablespace max size,create bigfile tablespace in asm,create tablespace oracle 12c example,big file tablespace, small file tablespace, permanent tablespace, sql tutorials for beginners, sql developer, sql expert, oracle dba tutorials, sql tutorials, oracle bigfile tablespace, big tablespace in oracle, big file temporary tablespace, big file tablespace management, bigfiletablespace in oracle, bigfile tablespace in oracle, tablespace management videos, oracle 12c,oracle 12c download,oracle database 12c,oracle client 12c,oracle 12c new features,uninstall oracle 12c,oracle xe 12c,oracle 12c documentation,oracle 12c installation, 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
Descarga-Instalación ORACLE Express 11g, SQLdeveloper  ||  CREAR TABLESPACE -DATAFILE- USER -PASS.
 
09:03
ORACLE :http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html SQL Developer: http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html CODIGO EN SQL DEVELOPER --CREAR TABLESPACE CREATE TABLESPACE "TSTABLA" DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\PRUEBITA.DBF' SIZE 200M; --TABLESPACE TEMPORAL CREATE TEMPORARY TABLESPACE "TSTABLA_TEMP" TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\PRUEBITA_TEMP.DBF' SIZE 200M; --DBA CREATE ROLE ADMINISTRADOR_BD; --Dar Permisos a rol GRANT CREATE SESSION TO ADMINISTRADOR_BD; GRANT CREATE ANY TABLE TO ADMINISTRADOR_BD; GRANT CREATE ROLE TO ADMINISTRADOR_BD; GRANT CREATE USER TO ADMINISTRADOR_BD; GRANT CREATE VIEW TO ADMINISTRADOR_BD; GRANT CREATE ANY INDEX TO ADMINISTRADOR_BD; GRANT CREATE TRIGGER TO ADMINISTRADOR_BD; GRANT CREATE PROCEDURE TO ADMINISTRADOR_BD; GRANT CREATE SEQUENCE TO ADMINISTRADOR_BD; --CREAR USUARIO CREATE USER USER_BD IDENTIFIED BY PASSWORD_BD DEFAULT TABLESPACE TSTABLA TEMPORARY TABLESPACE TSTABLA_TEMP; --DAR PERMISOS AL USUARIO ADMINISTRADOR_BD SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO USER_BD; --VOLCAR ADMINISTRADOR_BD A COLECCIONES GRANT ADMINISTRADOR_BD TO USER_BD; ASTUDILLO SÁNCHEZ DANTEE MAURICIO 4-2
Views: 181 Dantee Astudillo
Oracle Database Administration-TABLESPACE MANAGEMENT PART I
 
49:54
Oracle Database Administration-TABLESPACE MANAGEMENT PART I
Views: 13 SooCloudy
Oracle DBA | Adding Data File Existing Table Space | Bangla | DBA1-15
 
04:01
Oracle DBA | Adding Data File Existing Table Space | Bangla | DBA1-15 To See More DBA part-01 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUO3yQq7-LLdfQb5HpsQKNg To See More DBA part-02 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUviefN3-ZzKDVgbIH0RoaS To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU Dear viewer, In this tutorial you will learn Adding Data File Existing Table Space Adding Data File: Command: Connect sysdba SQL-alter tablespace test1 add datafile 'E:\app\Administrator\oradata\orcl\dfile2.dbf' size 500m; To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 48 OracleDB Solutions
Oracle High Water Mark
 
02:31
A Brief video about Oracle's Table High Water Mark and How to resolve issues associated with it Music: https://www.bensound.com
Views: 178 ORA-600
How to Perform Horizontal Fragmentation In Oracle Database
 
19:45
Hii there from Codegency! We are a team of young software developers and IT geeks who are always looking for challenges and ready to solve them, Feel free to contact us.. Do visit my instagram page and also like us on facebook, stay connected :) Instagram: https://www.instagram.com/code_gency/ Facebook: https://www.facebook.com/cgency/ Twitter : https://www.twitter.com/codegency Contact: +919769620035, +918108849398 For Blackbook Writeups & Descriptions: https://codegency.blogspot.in For Latest Notes & References: https://sites.google.com/view/itscholar/home
Views: 281 Codegency
(Ep. 21) - Db2 REDUCE MAX Command
 
16:34
You have run a REORG on a few of your tables and your data is in a nice contiguous order. What do you do with all the empty data extents? Release them to the operating system so your capacity needs drop of course. Everyone loves seeing your data filesystem drop ftom 70% full to 45% full. Today we will discuss tablespace watermarks, how Db2 views what space is needed where, and the REDUCE command. Timestamps: 01:25 - What is a High Watermark 04:31 - Viewing Tablespace Details 05:51 - db2dart (Detail High Water Mark) 08:15 - db2dart (Lower High Watermark) 09:20 - Releasing PENDING free pages 10:34 - REDUCE MAX Command 12:32 - Monitoring Extent Movement 14:22 - REORG vs Export/Import Download (EXT_STATUS.sql): https://github.com/MKrafick/DiscoverDB2 Useful Links: (KC) Reclaiming unused storage in AST - https://tinyurl.com/y92wkdta (KC) Reclaimable Storage (*Good article on Watermarks) - https://tinyurl.com/ycndehoc (Blog w/ SQL) Monitoring Extent Movement Progress - https://tinyurl.com/ybwcpa2n
Views: 141 DISCOVER.DB2