Home
Search results “Oracle alter tablespace resize”
How to Create, Alter, Resize, Drop Tablespace (Tablespace Management #1)
 
07:37
Hello Today I am showing you how to create tablespace. Alter tablespace datafile using fileid & filename and resize datafile. How to check Tablespace Size. How to check datafile Size in MB. How to drop Tablespace including contents and all Datafiles of these tablespace.
Views: 1798 Parag Mahalle
21. Alter Tablespace in Oracle
 
06:33
In this video you will learn how to learn tablespace to add new datafile,or add existing datafile in tablespace. You will also learn how to list available tablespace and datafile in oracle database engine. At the end you will learn how to drop tablespace. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 26573 ITORIAN
Creating  Managing  Droping Oracle Database Tablespaces
 
12:10
Creating Managing Droping Oracle Database Tablespaces select tablespace_name,block_size,status,contents,logging from dba_tablespaces; create tablespace mytbs datafile 'd:\oradata\dbrdbms\mytbs01.dbf' size 10m; alter tablespace mytbs add datafile 'd:\oradata\dbrdbms\mytbs02.dbf' size 10m; alter tablespace mytbs drop datafile 'd:\oradata\dbrdbms\mytbs02.dbf'; desc v$datafile; desc ts#,name from v$datafile; select ts#,name from v$tablespace; select v$datafile.ts#,v$datafile.name,v$tablespace.name from v$datafile,v$tablespace where v$datafile.ts#=v$tablespace.ts# and v$tablespace.name='MYTBS'; alter database datafile 'd:\oradata\dbrdbms\mytbs01.dbf' resize 20m; ALTER DATABASE DEFAULT TABLESPACE mytbs; select ts#,name from v$tablespace; select ts#,name from v$datafile; select ts#,name from v$tablespace; drop tablespace mytbs; drop tablespace mytbs ialtncluding contents and datafiles; drop tablespace mytbs including contents and datafiles cascade; alter tablespace mytbs read only; alter tablespace mytbs read write; alter tablespace mytbs force logging; alter tablespace mytbs nologging; alter tablespace mytbs flashback on; alter tablespace mytbs flashback off; purge tablespace mytbs user myuser;
Views: 21882 Abbasi Asif
Quickfix: Tablespace full to resize tablespace
 
02:11
Quickfix is a demonstration on how to fix a spesific database issue. In this video we detect that a tablespace is full and go through the steps to resize the tablespace.
Views: 1829 dbWatch As
RECOVER LOST  DataFile in oracle database
 
15:33
Please donate on below link if you think I am helping you with your career. https://www.paypal.me/ankushthavali OR Google Pay : 9960262955 OR Account No : 31347845762 IFSC: SBIN0012311 DATAFILE file Lost ================================ Archive log mode-Enabled create tablespace test_ts datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' size 10M; create table testtable (id number(5))tablespace test_ts; insert into testtable (id) select * from testtable; SQL>select count(*) from testtable; COUNT(*) ---------- - before deleting datafile 524288 SQL>select count(*) from testtable; COUNT(*) ---------- - After recovery 524288 select tablespace_name, segment_name from dba_segments where segment_name = 'TESTTABLE'; alter system flush buffer_cache; alter database create datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' as '/u01/app/oracle/oradata/testdb/ts_test02.dbf' alter database datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' offline drop; alter database create datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' as '/u01/app/oracle/oradata/testdb/ts_test02.dbf' recover datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf'; alter database datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' online; select count(*) from TESTTABLE; =================================================== Please like,subscribe my channel. Kindly contact for online training on below contacts. Emai: [email protected] Mob No: +91 9960262955 ====================================================== Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected] how to recover lost datafile in oracle how to recover a datafile in oracle without backup how to recover a deleted datafile in oracle 11g how to recover datafile in oracle rman restore datafile oracle missing datafile after clone how to recover system datafile in oracle without backup oracle datafile deleted accidentally
Views: 1521 ANKUSH THAVALI
Shrink Space
 
06:33
#Oracle #ShrinkSpace
Views: 1887 Hemant K Chitale
TABLESPACE MANAGEMENT CREATE TABLESPACE ALTER DATAFILE
 
03:34
How to check existing tablespace information in database ========================================================= select tablespace_name from dba_tablespaces; How to create a tablespace =============================== create tablespace king datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' size 10m; How to Resize the datafile ========================== alter database datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' resize 20m; Adding a datafile to a tablespace ================================= alter tablespace king add datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING02.DBF' size 10m; How to get the defintion of tablespace ====================================== set head off echo off select 'select dbms_metadata.get_ddl(''TABLESPACE'',''' || tablespace_name || ''') from dual;' from dba_tablespaces;
Views: 935 Praveen Biyyapu
How to Rename datafile in Oracle database
 
08:05
How to Rename datafile in Oracle ====================================== How to Rename datafile ====================================== select FILE_NAME,TABLESPACE_NAME,ONLINE_STATUS from dba_data_files; select status,instance_name,database_role,protection_mode from v$database,v$instance; alter database datafile '/opt/oracle/oradata/prim/users_test_after_rename.dbf' offline; server: mv old_data_file new_data_files alter tablespace USERS rename datafile '/opt/oracle/oradata/prim/users_test' to '/opt/oracle/oradata/prim/users_test_after_rename.dbf'; alter database datafile '/opt/oracle/oradata/prim/users_test_after_rename.dbf' online; how to move datafile from one location to another in oracle 11g alter database rename datafile file_id alter database rename datafile script how to move datafile in oracle standby database oracle move system datafile how to move datafile from one location to another in oracle 12c alter database rename file 1 to alter database move datafile 12c asm
Views: 249 ANKUSH THAVALI
How to Shrink table in Oracle..
 
11:52
this video will help how to reclaim space from the table.
Views: 1875 oracdb
Add Datafile to Tablespace
 
14:55
Add extra datafile to exixting tablespace, how to drop the extra datafile, how to reuse a datafile, how to make a tablespace offline n online.
Views: 12199 DbaRocksOracle
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: 7112 BhagyaRaj Katta
How to create,drop and resize tablespace in oracle database
 
06:28
Hello Friends! By This Video Tutorial, we are going to learn how to create, alter and delete tablespace in oracle database. # What is Tablespace? Tablespace is logical part of database which collectively store all of the database's data.
Views: 16 Oracle_World
Datafile Resize in Oracle
 
05:50
Welcome Back to KSH Infotainment. Datafile Resize in Oracle. Activity done on Oracle 11g ASM DB. Used Queries: ============= set lines 200 pages 200 select df.tablespace_name "Tablespace", totalusedspace "Used MB", (df.totalspace - tu.totalusedspace) "Free MB", df.totalspace "Total MB", round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace)) "Pct. Free" from (select tablespace_name, round(sum(bytes) / 1048576) TotalSpace from dba_data_files group by tablespace_name) df, (select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name from dba_segments group by tablespace_name) tu where df.tablespace_name = tu.tablespace_name order by 1; set linesize 200 set pagesize 2000 COLUMN tablespace_name format a10 COLUMN file_name format a45 COLUMN free% format a7 SELECT df.tablespace_name,SUBSTR (df.file_name, 1, 60) file_name, df.bytes / 1024 / 1024 allocated_mb, round(((df.bytes / 1024 / 1024) – NVL (SUM (dfs.bytes) / 1024 / 1024, 0)),1) used_mb, round(NVL (SUM (dfs.bytes) / 1024 / 1024, 0),2) free_space_mb FROM dba_data_files df, dba_free_space dfs WHERE df.FILE_ID = dfs.file_id(+) GROUP BY df.tablespace_name, dfs.file_id, df.file_id , df.bytes, df.file_NAME ORDER BY df.tablespace_name;
Views: 69 KSH Infotainment
HOW TO INCREASE DECREASE MEMORY TARGET IN ORACLE 11G
 
04:55
How to increase/decrease memory_target in 11g ====================================================== oracle 10g --sga_target (parameter new in 10g) oracle 11g --memory_target (parameter new in 11g) How to check whether the parameter is static or dynamic? ========================================================= select name, value, issys_modifiable from v$parameter where name like '%&parameter%' ; if issys_modifiable=false --- parameter is static (database bounce required) if issys_modifiable=immediate --- parameter is dynamic (database bounce not required) (note: consider using spfile) sql commands ================ show parameter memory; alter system set memory_target=350m scope=spfile; alter system set memory_max_target=350m scope=spfile;
Views: 5239 Praveen Biyyapu
TABLESPACE MANAGEMENT BIGFILE TABLESPACE RESIZING TABLESPACE TEMPORARY TABLESPACE GROUP RENAMING TAB
 
03:52
HOW TO RENAME A TABLESPACE =========================== alter tablespace king rename to king1; 10G FEATURES ON TABLESPACES 1)HOW TO CREATE BIGFILE TABLESPACE ================================== create bigfile tablespace king_big datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\king_big.dbf' size 20m; 2)HOW TO RESIZE A BIGFILE TABLESPACE ==================================== alter tablespace king_big resize 40m; 3)HOW TO CREATE TEMPORARY TABLESPACE GROUP ========================================== create temporary tablespace king_temp tempfile 'E:\DATABASE\DATABASE\ORADATA\ORCL\king_temp.dbf' size 20m tablespace group group1; select * from dba_tablespace_groups;
Views: 790 Praveen Biyyapu
Managing Database Structure -Tablespaces and Datafiles part 1st
 
21:55
Hi friends in this video i am going to explain you how to create alter tablespace and datafile in oracle. #ManagingDatabaseStructure #TablespacesandDatafiles Oracle database Unbeatable,Unbreakable Platform..
Views: 11560 Oracle World
How to Add & Drop Datafile in Tablespace. ( Tablespace Management #2 )
 
06:46
Hello Friend In this video I am showing you 1. How to add datafile. 2. How to drop Datafile. 3. How to alter Tablespace. 4. How to check Datafile Location. 5. How to check free space in tablespace.
Views: 228 Parag Mahalle
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: 1076 Oracle PL/SQL World
TABLESPACE MANAGEMENT GRANT REVOKE QUOTAS ON TABLESPACE FOR USERS
 
06:20
How to grant/revoke quota for Users on Tablespace ================================================= create tablespace test datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\test.dbf' size 10m;---(tablespace created) create user naveen identified by naveen;(user created) alter user naveen quota 2m on test;(granted 2m on test tablespace) alter user naveen quota unlimited on test;(granted unlimited on test) How to revoke unlimited tablespace from user ============================================= revoke unlimited tablespace from &user; How to check the views on quotas ================================= select table_name from dict where table_name like '%QUOTA%'; Queries for tablespace quotas on all users ========================================== set lines 180 set pages 200 col tablespace_name for a30 col username for a20 select * from user_ts_quotas; set lines 180 set pages 200 col tablespace_name for a30 col username for a20 select * from dba_ts_quotas;
Views: 559 Praveen Biyyapu
TABLESPACE MANAGEMENT DATAFILE SIZE ENABLE DISABLE AUTOEXTEND ON
 
02:50
HOW TO ENABLE/DISABLE AUTOEXTEND ON FOR A DATAFILE ================================================== alter database datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\GOODKING01.DBF' autoextend on; HOW TO FIND THE SIZE OF A DATAFILE ================================== SELECT SUBSTR (df.NAME, 1, 50) file_name, df.bytes / 1024 / 1024 allocated_mb, ((df.bytes / 1024 / 1024) - NVL (SUM (dfs.bytes) / 1024 / 1024, 0)) used_mb, NVL (SUM (dfs.bytes) / 1024 / 1024, 0) free_space_mb FROM v$datafile df, dba_free_space dfs WHERE df.file# = dfs.file_id(+) GROUP BY dfs.file_id, df.NAME, df.file#, df.bytes ORDER BY file_name; set lines 180 pages 200 col tablespace_name for a20 col file_name for a55 select tablespace_name,file_name,autoextensible from dba_data_files;
Views: 1263 Praveen Biyyapu
Extend tablespace  SYSAUX with brtools in SAP
 
07:50
Extend tablespace SYSAUX PSAPSR3 with brtools in sap and DB02 colector
Views: 1853 Rubens Abibe Lima
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
19. Create Tablespace, Create User, Create Role, Drop Role, Drop User, Drop Tablespace in Oracle
 
13:58
In this video you will learn about Create Tablespace, Create User, Create Role, Drop Role, Drop User, Drop Tablespace in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 16545 ITORIAN
TABLESPACE MANAGEMENT RENAME OR MOVE A DATAFILE
 
04:40
RENAME OR MOVE A DATAFILE (when there is space issue in os level file movement is required) ========================== 1)TABLESPACE SHOULD BE OFFLINE(when we move or rename a datafile users should not access) 2)FROM OS LEVEL DATAFILE COPY TO NEW LOCATION 3)SQL LEVEL RENAME THE DATAFILE TO NEW LOCATION 4)MAKE THE TABLESPACE ONLINE alter tablespace king offline; os level rename king01.dbf TO GOODKING01.dbf os level move the file to new location(KING02.DBF) alter tablespace king rename datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' to 'E:\DATABASE\DATABASE\ORADATA\ORCL\GOODKING01.DBF'; alter tablespace king rename datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING02.DBF' TO 'D:\ORADATA\KING02.DBF'; alter tablespace king online; HOW TO CHECK DATAFILES INFO IN PARTICULAR TABLESPACE ===================================================== COL FILE_NAME FOR A50 COL TABLESPACE_NAME FOR A20 select tablespace_name,file_name from dba_data_files where tablespace_name like '&tablespace_name';
Views: 815 Praveen Biyyapu
Oracle Table Space and User Creation with grant Privileges
 
05:05
--------------Table space Creation-------------------- Syntax CREATE TABLESPACE 'DATA FILE NAME' DATAFILE 'Data File Path to store the data' SIZE 'SIZE in MB' AUTOEXTEND ON NEXT 'SIZE in KB/MB' MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 'SIZE in KB' SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE ORA12CR2_DATA DATAFILE 'E:\OracleDB\app\ORA12CR2_DATA.dbf' SIZE 2048M AUTOEXTEND ON NEXT 8K MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE ORA12CR2_INDEX DATAFILE 'E:\OracleDB\app\ORA12CR2_INDEX.dbf' SIZE 1024M AUTOEXTEND ON NEXT 8K MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; Increasing the Tablespace space: ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_DATA.dbf' RESIZE 5120M; ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_DATA.dbf' AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED; ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_INDEX.dbf' RESIZE 2048M; ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_INDEX.dbf' AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED; ------------User Creation and Grant Privileges Syntax:- CREATE USER 'USER NAME' IDENTIFIED BY 'Password' DEFAULT TABLESPACE 'Table Space Name' TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; Example:- CREATE USER DEMOUSER IDENTIFIED BY DEMOUSER DEFAULT TABLESPACE ORA12CR2_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited; alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited; GRANT DBA TO DEMOUSER; ALTER USER DEMOUSER DEFAULT ROLE ALL; -- 16 System Privileges for DEMOUSER GRANT CREATE ROLE TO DEMOUSER; GRANT CREATE TYPE TO DEMOUSER; GRANT CREATE VIEW TO DEMOUSER; GRANT CREATE TABLE TO DEMOUSER; GRANT ALTER SESSION TO DEMOUSER; GRANT CREATE SESSION TO DEMOUSER; GRANT CREATE SYNONYM TO DEMOUSER; GRANT CREATE TRIGGER TO DEMOUSER; GRANT CREATE ANY TYPE TO DEMOUSER; GRANT CREATE SEQUENCE TO DEMOUSER; GRANT CREATE ANY INDEX TO DEMOUSER; GRANT CREATE PROCEDURE TO DEMOUSER; GRANT CREATE ANY TRIGGER TO DEMOUSER; GRANT CREATE DATABASE LINK TO DEMOUSER; GRANT UNLIMITED TABLESPACE TO DEMOUSER; GRANT SELECT ANY DICTIONARY TO DEMOUSER; GRANT DEBUG CONNECT SESSION TO DEMOUSER; GRANT DEBUG ANY PROCEDURE TO DEMOUSER; GRANT CREATE ANY MATERIALIZED VIEW TO DEMOUSER; GRANT GLOBAL QUERY REWRITE TO DEMOUSER; -- 2 Tablespace Quotas for DEMOUSER ALTER USER DEMOUSER QUOTA UNLIMITED ON ORA12CR2_DATA; ALTER USER DEMOUSER QUOTA UNLIMITED ON ORA12CR2_INDEX; -- 1 Object Privilege for DEMOUSER CREATE OR REPLACE DIRECTORY DB_EXP_IMP AS 'E:\OracleDB\app'; GRANT READ, WRITE ON DIRECTORY DB_EXP_IMP TO DEMOUSER;
How to create oracle 11g Table space (user schema creation)
 
11:02
create tablespace rfdemo logging datafile '/oradata/DB11G/rfdemo.dbf' size 5G autoextend on next 512m maxsize 10G extent management local; CREATE USER rfdemo IDENTIFIED BY rfdemo DEFAULT TABLESPACE rfdemo TEMPORARY TABLESPACE TEMP; GRANT "RESOURCE" to rfdemo; GRANT "CONNECT" to rfdemo; GRANT "DATAPUMP_EXP_FULL_DATABASE" to rfdemo; GRANT "DATAPUMP_IMP_FULL_DATABASE" to rfdemo; REVOKE UNLIMITED TABLESPACE FROM rfdemo; ALTER USER rfdemo QUOTA UNLIMITED ON rfdemo; commit;
Views: 7902 ab1 ek
OracleTablespace Administration | Bigfile tablespace in Oracle - Creation and Management
 
08:42
This video is the part of Oracle Database Self learn Kit From Wysheid. In this video we discuss about the creation and management of bigfile tablespaces in an Oracle database
Views: 2408 Wysheid Wysheid
How to Move a Datafile in Oracle Database - Part 1
 
01:32
Dozens of free Oracle tutorials at http://skillbuilders.com/free-oracle-tutorials. See Part 2 (the demonstration) of this tutorial at http://skillbuilders.com/How-to-Move-Datafiles-Oracle-12c. How do you move a datafile in an Oracle Database? Well, it just got a lot easier in 12c! Watch this free video tutorial - OCM John Watson of SkillBuilders will demonstrate both techniques, 11g and 12c. There are many reasons to move a datafile in an Oracle database. Here are just a few: Renaming datafiles to a standard Moving from one file system to another Converting from file system storage to ASM Changing from SAN to NFS storage In 11g, we need to take the tablespace offline, meaning downtime. Argh! In 12c, all that is required is ALTER DATABASE MOVE DATAFILE; this is an online operation with zero downtime. Even "critical" files such as the files associated with the SYSTEM tablespace can be moved online. Consider the ease of migrating to ASM this provides! This also functions in an Active Data Guard standby environment. And, there are syntax options that allow you to keep or delete the original file. Very cool stuff.
Views: 2593 SkillBuilders
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/
How To Create and Drop Tablespace in Oracle 11g
 
09:42
How to Create & Drop a Tablespace
Views: 26667 DbaRocksOracle
20. Tablespace and Datafile in Oracle
 
04:34
In this video you will learn about Tablespaces and Datafiles in detail. We are going to cover something theoretically here because you will be using it frequently in next videos so it is good to watch this before proceeding. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 31170 ITORIAN
Managing Database Structure -Tablespaces and Datafiles part 2nd
 
13:18
Hi friends in this video i am going to explain you how to create alter tablespace and datafile in oracle. #ManagingDatabaseStructure #TablespacesandDatafiles Oracle database Unbeatable,Unbreakable Platform..
Views: 1751 Oracle World
How to move a Datafile in Oracle Database 12c - part 2
 
01:26
How do you move a datafile in an Oracle Database? Well, it just got a lot easier in 12c! Watch this free video tutorial where OCM John Watson of SkillBuilders will demonstrate both techniques, 11g and 12c. http://skillbuilders.com/free-oracle-tutorials There are many reasons to move a datafile in an Oracle database. Here are just a few: Renaming datafiles to a standard Moving from one file system to another Converting from file system storage to ASM Changing from SAN to NFS storage In 11g, we need to take the tablespace offline, meaning downtime. Argh! In 12c, all that is required is ALTER DATABASE MOVE DATAFILE; this is an online operation with zero downtime (in 11g we use ALTER DATABASE RENAME DATAFILE). Even "critical" files such as the files associated with the SYSTEM tablespace can be moved online. Consider the ease of moving to ASM this provides! This also functions in an Active Data Guard standby environment. And, there are syntax options that allow you to keep or delete the original file. Very cool stuff.
Views: 526 SkillBuilders
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: 361 Dantee Astudillo
move table from one tablespace to other
 
08:24
move table from one tablespace to other
Views: 1159 Jamaal Khan
Managing Resumable Space Allocation in Oracle database
 
02:56
By Vivek Saxena Insa Shabad Coachings Shamli Resumable Space Allocation is given by extending the data file size with a open database Alter session enable resumable; Create tablespace spr datafile 'c:\db3\data\spr1a.dbf' size 100k; Create table spr(rn number(10) tablespace spr; Insert into spr(select salary from hr.employees); Insert into spr (select * from spr); Set oracle_sid= orcl Sqlplus/nolog Conn/as syadba Alter database datafile 'c:\db3\data\spr1a.dbf' resize 300k;
How to Check Tablespace Size in SQL Developer | Oracle SQL Developer Tips and Tricks
 
02:08
How to Check Tablespace Size in SQL Developer | Oracle SQL Developer Tips and Tricks Oracle SQL Tutorial for Beginners Oracle Database Tutorial for Beginners Oracle SQL Developer Tips and Tricks Oracle Tutorial for Beginners Oracle Tutorial How to Check Tablespace Size in SQL Developer How to Check Tablespace Size in Oracle SQL Developer How to Monitor Tablespace Size in Oracle SQL Developer How to Monitor Tablespace Size in SQL Developer how to check tablespace in oracle sql developer how to check tablespace size in oracle 12c how to check particular tablespace size in oracle how to check tablespace size in gb in oracle how to check tablespace name in oracle how to check freespace in tablespace in oracle 11g how to check tablespace size in oracle 11g how to check freespace in oracle database How to Check Storage of Tablespace Size in SQL Developer How to Check Storage of Tablespace Size in Oracle SQL Developer how to check tablespace in oracle how to check tablespace size in oracle 12c what is tablespace in oracle how to check tablespace in oracle sql oracle list tablespaces in schema how to find tablespace used by a user in oracle how to check particular tablespace size in oracle oracle create tablespace
Views: 786 Oracle PL/SQL World
Rename Tablespace ( Tablespace Management #3 )/* Step By Step /*
 
06:23
Hello Friends In this video I am showing you 1. How to check Tablespace, Datafile size and Datafile Location. 2. How to Rename Tablespace. 3. How to Offline Tablespace. 4. How to Online Tablespace. 5. How to Rename Datafile. 6. How to Check Tablespace. (How many tablespace Do you Have). 7. How to check Tablespace Status. It is Offline or online. 8. How to Rename Old Datafile name to New Datafile Name in controlfile.
Views: 145 Parag Mahalle
SQL Developer Issues - ORA-01653 unable to extend table by 8 in tablespace
 
01:14
Let’s, Make In Java…! You can SUBSCRIBE Mr.DIpak SOnar's YouTube Channel at : Mr.DIpak SOnar's YouTube Channel at :https://www.youtube.com/channel/UCGh1eIxU394O57YSRrhOMdg DIpak SOnar | Facebook Page - https://www.facebook.com/mrdipaksonar DIpak SOnar | Facebook Profile - https://www.facebook.com/mrdipaksonarofficial Mr.DIpak SOnar (@mrdipaksonar) - https://twitter.com/mrdipaksonar Mr.DIpak SOnar | Instagram - https://www.instagram.com/mrdipaksonarofficial/ -~-~~-~~~-~~-~- Please watch: "Made iN Java - How to PRINT COMMENTS in Java" https://www.youtube.com/watch?v=ReIPigBDGcM -~-~~-~~~-~~-~-
Views: 2256 Mr.DIpak SOnar
How to work with Tablespaces in Real-Time? Tablespace Administration
 
01:00:59
https://dbagenesis.com/p/oracle-11g-advanced-dba Oracle tablespace administration - Learn how to work on tablespaces in real-time. - Tablespace management tasks - Tablespace utilization - Add space to tablespace - Add new tablespace - Tablespace best practices - Drop tablespace A tablespace is constructed by Oracle from one or more operating system files through the use of the CREATE TABLESPACE command. Every Oracle database consists of at least one tablespace, called SYSTEM.
Views: 15534 DBA Genesis
SQL Developer Create Tablespace Auto Extend
 
02:38
Create Tablespace auto extend use SQL Developer
Views: 329 Aulia Cahya Wiguna
Oracle Tablespaces
 
12:07
Oracle tablespaces
Views: 6682 Chris Ostrowski
RENAME DATAFILE - ORACLE
 
09:17
In this video I explain in detail how to change the datafile to a tablespace .. Like !!!
Views: 605 FULL-ORACLE
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
Fall 2016 ISQA 4300/8306 Week 7Lecture
 
01:46:42
!!PLEASE SWITCH PLAYBACK to 1080P!! - https://support.google.com/youtube/answer/91449?hl=en Week 7 Tablespaces and Datafiles Commands in video - select segment_type,count(1) from dba_segments group by segment_type order by segment_type; create table scott.new_tab(c1 date) segment creation immediate; alter table scott.new_tab allocate extent; create table scott.new_tab(c1 date) segment creation immediate; ALTER TABLESPACE USERS ADD DATAFILE '/u01/app/oracle/oradata/MYCDB1/MYPDB1_ON_MYCDB1/myuser_users01.dbf' SIZE 5120K AUTOEXTEND ON NEXT 1280K MAXSIZE 33554416K; alter table scott.new_tab allocate extent(DATAFILE '/u01/app/oracle/oradata/MYCDB1/MYPDB1_ON_MYCDB1/myuser_users01.dbf') CREATE TABLESPACE "MYUSERS" DATAFILE '/u01/app/oracle/oradata/MYCDB1/MYPDB1_ON_MYCDB1/myuser_users02.dbf' SIZE 5242880 AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO; create table new_tab2(c1 date) segment creation immediate;
How to find the tablespaces in an Oracle Database - Database Tutorial 55 - Oracle DBA Tutorial
 
05:10
Video 55 How to find the tablespaces in an Oracle Database - Oracle DBA Tutorial This video explains about how to view the list of tablespaces that are there in an Oracle Database. To do that: select * from dba_tablespaces;
Views: 1545 Sam Dhanasekaran
TABLESPACE MANAGEMENT DROP TABLESPACE REUSE DATAFILE DROP INCLUDING CONTENTS AND DATAFILES
 
03:48
HOW TO DROP TABLESPACE ====================== drop tablespce king; (datafile will not delete from o/s level) create tablespace king datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' reuse;(no need to give size) drop tablespace king including contents and datafiles;(datafile will delete from o/s level) newly created tablespace king with king01 datafile (got deleted from o/s level)
Views: 552 Praveen Biyyapu
when checkpoint will occur in oracle database
 
14:13
How to check current_scn number of database? ============================================= select CURRENT_SCN from v$database; select dbms_flashback.get_system_change_number from dual; select timestamp_to_scn(sysdate) from dual; how to check datafile header scn number? ========================================= select name,CHECKPOINT_CHANGE# from v$datafile_header; when checkpoint will occur? ============================ alter system switch logfile; alter database begin backup; alter database end backup; alter system checkpoint;(manual checkpoint) shutdown immediate;(when the database is down) what will happen when checkpoint occurs? ========================================= scn of datafile header will update;
Views: 3720 Praveen Biyyapu