Home
Search results “Move tablespace oracle table”
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: 1191 Oracle PL/SQL World
move table from one tablespace to other
 
08:24
move table from one tablespace to other
Views: 1192 Jamaal Khan
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: 7412 BhagyaRaj Katta
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: 1766 TechLake
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: 844 Praveen Biyyapu
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: 2161 Parag Mahalle
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: 2452 Wysheid Wysheid
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 Transportable Tablespaces
 
17:42
Oracle Transportable Tablespaces
Views: 2187 The Silent DBA
Exports - Imports Utility step by step
 
22:22
In this video i'm going to show you how to use Exports - Import Utility, Schema lever, Table Level and Full Database Level step by step. #export #import #impdp #expdp #oracletutorial #oracle12c
Views: 30681 OCP Technology
How to Shrink table in Oracle..
 
11:52
this video will help how to reclaim space from the table.
Views: 1964 oracdb
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: 27260 ITORIAN
Tablespace Management
 
15:02
Tablespace management Tasks
Views: 37053 DbaRocksOracle
Oracle Encrypted Tablespaces
 
14:35
Oracle Encrypted Tablespaces
Views: 2019 The Silent DBA
Transporting tablespace to different platform by Using RMAN
 
21:59
This video is tells how to transport a tablespace to different operating system platforms by using RMAN. 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 Table Shrinking in Oracle Database : https://www.youtube.com/watch?v=bdockmBDvz8
Views: 4068 BhagyaRaj Katta
Oracle 12c Release 2 - How to move a heap table online
 
01:43
Need to reorganize a table ? Want to do it whenever you want without impacting any users ? Easy in 12.2 ========================================­­­­============== 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: 470 Connor McDonald
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: 1605 Sam Dhanasekaran
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: 1981 dbWatch As
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: 152 Parag Mahalle
2.Table level Export and Import in Oracle database
 
05:10
Hello friends in this video i explain about table level export and import which is the best method for backup and recovery of table and easy to manage by user. #TablelevelExportandImport Oracle database Unbeatable,Unbreakable Platform..
Views: 10342 Oracle World
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 187789 Abbasi Asif
Frgmentation in oracle database
 
34:54
Fragmentation in oracle database,find and defragmentation
Views: 4184 Sainora Annanagar
MOVE ORACLE TABLESPACE INDEX DATA WINDOWS USING TOAD
 
01:06
I just want to make it simple move or rename Oracle DBF Files. this case working on Windows Version. If you are using UNIX or LINUX Version it will different.
Views: 28 MADEFORSIMPLICITY
Shrink Space
 
06:33
#Oracle #ShrinkSpace
Views: 1957 Hemant K Chitale
Transport tablespace by using RMAN.
 
20:11
This is very easy method to transfer tablespace from one database to another database by using RMAN. Explanation: By contrast, when RMAN creates transportable tablespace sets from backup, it does not need access to the live datafiles from the tablespaces to be transported. This eliminates the need to put the tablespace in read-only mode. As a result, database availability is improved, especially for large tablespaces, because the tablespaces to be transported can remain open for writes during the process, and because putting a tablespace into read-only mode can take a long time, depending upon current database activity. 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 Table Shrinking in Oracle Database : https://www.youtube.com/watch?v=bdockmBDvz8 Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A
Views: 11611 BhagyaRaj Katta
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: 545 SkillBuilders
Oracle Database Tutorial 65: How to create temporary tablespace in oracle database
 
05:55
Learn How to create big file and small file temporary tablespace in oracle database by Manish Sharma RebellionRider Follow Me on Twitter @RebellionRider and Instagram "RebellionRider" ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : Previous Tutorial ► Permanent Tablespace https://youtu.be/vkwKZIssvfc ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 15855 Manish Sharma
Monitoring Undo, Administering Undo, Configuring Undo Retention, Sizing Undo tablespace
 
22:36
Managing undo Data Monitoring Undo, Administering Undo, Configuring Undo Retention, Sizing Undo tablespace For Students of B.Tech, B.E, MCA, BCA, B.Sc., M.Sc., Courses - As Per IP University Syllabus and Other Engineering Courses
Oracle Database tutorial 64: How To Create Permanent tablespace (Big file and small file)
 
07:15
How to create big file and small file permanent tablepsace in oracle database by Manish sharma rebellionRider In this tutorial you will learn the process of big file and small file permanent tablespace creation with datafiles ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/permanent-tablespace-oracle-rebellionrider Script: https://copy.com/whfzfAeUtzy0JEoU Previous Tutorial ► Tablespace The Introduction : https://youtu.be/5i5RtUdxaHY ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 18624 Manish Sharma
Oracle DBA Justin - How to rename a tablespace, and a datafile in an Oracle database # 1 of 3
 
13:54
How to rename a tablespace, and a datafile in an Oracle database
Views: 6052 jbleistein11
expdp impdp  (tablespace level)
 
12:33
THIS VIDEO WILL GIVE YOU A BASIC IDEA OF HOW TO PERFORM A EXPDP/IMPDP (export/import using datapump) IN ORACLE 10G DATABASE PLEASE DO GIVE YOUR VALUABLE FEEDBACKS.
Views: 10931 AKHTAR HUSSAIN SHAIKH
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: 322 ANKUSH THAVALI
How to Create table|Copy data from another schema table in Oracle11g?
 
10:39
hi friends... today I am going to show you some interesting and important queries in oracle.. 1.how to create table from another schema table without data? 2.how insert data in table from another schema table ? 3.how insert specific columns data in table from another schema table? here I want to create table name empdup based on scott schema emp table.. so guys please watch these carefully.. 1.how to create table from another schema table without data? syntax: create table tablename as select * from schema.tablename where 2=1; Eg:create table empdup as select * from scott.emp where 2=1; we can above example practically...so as shown in video,we have created table in hari user based scott schema emp table without data... 2.how insert data in table from another schema table ? syntax: insert into table_name select * from schema_name.table_name; Eg: insert into empduplicate select * from scott.emp; we can see this practically...so we got total rows(14) from scott schema emp table data into hari user's table empduplicate.. 3.how insert specific columns data in table from another schema table? Syntax: insert into table_name(col1,col1,...) select col1,col2.. from schema_name.table_name; Eg: insert into empduplicate empno,ename,job select empno,ename,job from scott.emp; we can also see this in practically.. first I delete total data before inserted in empduplicate.. after executing this query we got only specifice columns data into empduplicate table... that's it guys... thank u... Please Subscribe n Share My Channel for Update.. www.youtube.com/user/prasadamudalapalli
Views: 763 pa online
Oracle Tablespace PITR Recovery Lab Activity | TS-PITR Part - 2
 
12:24
https://dbagenesis.com/p/oracle-advanced-rman-backup-recovery Recovery Manager (RMAN) automatic TSPITR enables you to quickly recover one or more tablespaces in a database to an earlier time without affecting the rest of the tablespaces and objects in the database. RMAN TSPITR is most useful for the following situations: 1. You want to recover a logical database to a point different from the rest of the physical database, when multiple logical databases exist in separate tablespaces of one physical database. For example, you maintain logical databases in the orders and personnel tablespaces. An incorrect batch job or DML statement corrupts the data in only one of the tablespaces. 2. You want to recover data lost after DDL operations that change the structure of tables. You cannot use Flashback Table to rewind a table to before the point of a structural change such as a truncate table operation. 3. You want to recover a table after it has been dropped with the PURGE option. 4. You want to recover from the logical corruption of a table. You can also use Flashback Database to rewind data, but you must rewind the entire database rather than just a subset. Also, unlike TSPITR, the Flashback Database feature necessitates the overhead of maintaining flashback logs. The point in time to which you can flash back the database is more limited than the TSPITR window, which extends back to your earliest recoverable backup.
Views: 609 DBA Genesis
DESCRIBE or DESC Keyword in Oracle | Oracle Tutorials for Beginners
 
07:09
DESCRIBE or DESC Keyword in Oracle | Oracle Tutorials for Beginners DESCRIBE Keyword in Oracle DESC Keyword in Oracle DESCRIBE Keyword in Oracle SQL DESC Keyword in Oracle SQL DESCRIBE Keyword in SQL DESC Keyword in SQL Oracle Tutorials for Beginners Oracle SQL for Beginners Oracle Database for Beginners Oracle SQL Tutorials for Biners Oracle Database tutorials for Beginners oracle describe table structure desc table in sql server descending order in oracle how to see table structure in oracle sql developer desc command in mysql pl sql describe table desc command in sql example describe table in sql query how to see table structure in oracle sql developer desc table in sql server sql query to view table structure in oracle oracle describe table invalid sql statement describe table in sql query oracle desc table order by column name describe not working in oracle oracle show tables how to see table structure in oracle sql developer how to get table structure in oracle 11g sql query to list all tables in a database describe table in oracle sql developer sql query to view table structure in sql server oracle get list of tables in schema oracle show tables describe table structure in sql server
Views: 819 Oracle PL/SQL World
5.How to Remap Tablespaces and Schema using Oracle Import/Export Tool
 
06:40
Hi guys in this video you learn How to Remap Tablespaces and Schema using Oracle Import/Export Tool. #RemapTablespaces #Remapschema #OracleImport/ExportTool Oracle database Unbeatable,Unbreakable Platform..
Views: 3132 Oracle World
How to Perform Resumable Space Allocation in Oracle. /* Step By Step /*
 
19:56
We can perform Resumable space allocation on Tables. Resumable space allocation, introduced in Oracle 9i, is for all tablespaces at the session level. Database operations are suspended when an out-of-space condition is encountered. These suspended operations automatically resume when the error condition disappears. This feature is very easy to understand. And easy to Implement on any tables.
Views: 744 Parag Mahalle
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: 3370 TechLake
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: 111 KSH Infotainment
Migrate data from Oracle table to Access
 
00:18
Migrate data from Oracle table to Access, by OracleToAccess, http://www.withdata.com/oracletoaccess/ . Download link: http://www.withdata.com/down/OracleToAccess.exe .
Views: 130 Shiji Pan
part 1 table space
 
04:53
table space, data warehousing, partition,segment,extent,data block
Views: 2156 Dr. Girija Narasimhan
Oracle DBA lesson4-Manage tablespace and data file الدرس الرابع
 
29:18
Types of tablespace create tablespace and datafiles alter and, drop tablesapces tempfile and bigfile http://www.4shared.com/file/ez9tZC6t/Manage_tablespace_and_data_fil.html
Views: 4517 ayman hamdan
RENAME DATAFILE - ORACLE
 
09:17
In this video I explain in detail how to change the datafile to a tablespace .. Like !!!
Views: 621 FULL-ORACLE
Create Tablespace In Migrate To ASM Database
 
02:10
Hi... Friends In This Video We Learn How To Create Tablespace in Migrate To ASM Database in Oracle 11g On Windows Database Name : Orcl Watch My Previous Video Migrate To ASM in Oracle 11g https://www.youtube.com/watch?v=NCXEt0KGwoU&t=5s
Views: 138 PGT POINT
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: 261 Parag Mahalle
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: 970 Praveen Biyyapu
oracle user management | User creation and privilege management | password management in oracle
 
01:04:13
This video is part of "Oracle Database Administration Made Simple" series. The following topics are covered -- user creation -- Default tablespace for user -- Granting and revoking privileges -- understanding sysdba privilege
Views: 16217 Wysheid Wysheid
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: 94 OracleDB Solutions