Home
Search results “Select object tablespace oracle”
Data Pump,  Oracle DBA, export whole schema and import selected objects, 1e18
 
09:44
How to use datapump to export whole schema
Views: 30192 hammadshams
SQL tutorial 47: How to Grant Object Privileges With Grant Option in Oracle Database
 
07:13
In this SQL Tutorial you will learn How To Grant Object Privilege using Grant Data Control Language (DCL) statement along with GRANT OPTION flag. Third SQL Tutorial in the series of user privileges in oracle database ------------------------------------------------------------------------ ►►►Timeline◄◄◄ 1:06- Query 1- How To grant Basic Object Privilege (i.e.SELECT Object privilege) to a user 3:31- Query 2 - How to Grant Multiple Object Privilege To a user in 4:26- Query 3 - How To grant Object Privilege on Column Level 5:30- Query 4- How To Grant System Privilege WITH GRANT OPTION flag 6:06- WITH ADMIN OPTION demonstration ------------------------------------------------------------------------ Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ List of Object Privilege http://bit.ly/list_of_object_privileges Object Privileges Blog http://bit.ly/object_privileges-in-oracle-database Previous Tutorial System Privilege: http://youtu.be/EQzdtKPiErU Introduction to user privilege: http://youtu.be/iQFb86lM1gs ------------------------------------------------------------------------- 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 first 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 [email protected] 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: 24465 Manish Sharma
SCPT 44: Undo Management In Oracle
 
14:07
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 21621 Oresoft LWC
SQL Tutorial - How to grant System and Object Privileges in Oracle Database
 
18:08
In this session I Explaining the Theory of Granting and Revoking System and Object privileges.... #Oracletutorialforbeginners #rmanrecoverytutorial #SQLTutorial #SystemandObjectPrivilegesinOracle by Lalit saini
Views: 12566 Oracle World
What is an Oracle Schema - Database Tutorial 58 - Oracle DBA Tutorial
 
10:48
What is an Oracle Schema - Database Tutorial 58 - Oracle DBA Tutorial An Oracle Schema is a generic user which is used to store the data. It starts as an user. But once the objects are created beneath this user, then this user becomes a schema. Other Oracle users will be given access to these schema objects so that they can work with these objects.
Views: 30046 Sam Dhanasekaran
Relationships of Physical and Logical Storage structures in an Oracle Database - DBArch Video 22
 
06:14
In this video you will understand the Relationships between the Physical files and Logical Components - Tablespace, Segments, Extents and Oracle Blocks in an Oracle Database . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 15887 Ramkumar Swaminathan
Oracle SQL Developer Tutorial For Beginners   31   DBA Info   Default Permanent Tablespace
 
03:12
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 1827 Sam Dhanasekaran
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 185734 Abbasi Asif
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: 3077 Oracle World
How to drop all of the objects in a user's recycling bin in oracle database
 
01:58
How to drop all of the objects in a user's recycling bin ========================================================== purge recyclebin how to check the original name of dropped objects in recyclebin =============================================================== select owner,original_name,type from dba_recyclebin; select original_name,type from recyclebin; how to check view on recyclebin =================================================== select table_name from dict where table_name like '%RECYCLE%';
Views: 281 Praveen Biyyapu
How to drop an object, and then recover it from the Oracle recycle bin
 
02:53
How to drop an object, and then recover it from the Oracle recycle bin ========================================================== select base_object from recyclebin; flashback table tablename to before drop; create table ============= create table fish as select * from tab; insert data into table ====================== insert into fish select * from tab; insert into fish select * from fish; drop table =========== drop table fish; how to recover it from recyclebin ================================== flashback table fish to before drop;
Views: 266 Praveen Biyyapu
How to drop all objects in the recycle bin, regardless of owner in oracle database
 
06:29
How to drop all objects in the recycle bin, regardless of owner in oracle database ================================================================================== purge dba_recyclebin how to check the original name of dropped objects in recyclebin =============================================================== select owner,original_name,type from dba_recyclebin; how to check view on recyclebin =================================================== select table_name from dict where table_name like '%RECYCLE%';
Views: 281 Praveen Biyyapu
How To Create and Drop Tablespace in Oracle 11g
 
09:42
How to Create & Drop a Tablespace
Views: 26838 DbaRocksOracle
Oracle SQL Developer Tutorial For Beginners  15   SELECT COUNT
 
00:47
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 3127 Sam Dhanasekaran
Oracle DBA - Manage Users, Roles & Privileges | User Management
 
07:44
Thanks for Watching please Like, Subscribe and Share... BoxCut Media.
Views: 29352 BoxCut Media
How to Detect Soft Corruption in Oracle 12c Database
 
18:19
Detection of Soft Corruption in 12c: To use the scripts below replace : , ",# and $ by proper bracket Lets Create a tablespace and small table. SQL: create tablespace DEMO1 datafile '/u02/tstdb1/TSTDB1/datafile/demo01.dbf' size 50M SQL: create table objects tablespace DEMO1 as select * from dba_objects; SQL: alter table objects add constraint pk_obj primary key #object_id$; SQL: create index idx_obj_name on objects#object_name$ tablespace demo1; Backup tablespace. RMAN: backup tablespace DEMO1; We need to put the DB in archivelog first Rebuild index with NOLOGGING option to simulate soft corruption later. RMAN: alter index idx_obj_name rebuild nologging; Confirm that we have datafiles that require backup because they have been affected with NOLOGGING operation. RMAN: report unrecoverable; Simulate corruption. RMAN: alter database datafile 5 offline; RMAN: restore datafile 5; RMAN: recover datafile 5; RMAN: alter database datafile 5 online; Query table with corrupted index and notice error. SQL: select count#*$ from objects where object_name like 'A%'; Let’s perform validation of datafile to check block corruption. RMAN: backup validate check logical datafile 5; Notice that we have 457 blocks marked corrupt but v$database_block_corruption view is empty. SQL: select count#*$ from v$database_block_corruption; Let’s query v$nonlogged_block view. set lines 200 set pages 999 select file#, block#, blocks,object#,reason from v$nonlogged_block; Will RMAN detect that we have corrupted blocks? RMAN: backup datafile 5; RMAN backup won’t fail due to NOLOGGING corrupt blocks and our backup will contain soft corrupted blocks. Let’s Identify corrupt segments using v$nonlogged_block view. set lines 2000 set pages 9999 col owner for a20 col partition_name for a10 col segment_name for a20 SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest#e.block_id, c.block#$ corr_start_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ - greatest#e.block_id, c.block#$ + 1 blocks_corrupted FROM dba_extents e, V$NONLOGGED_BLOCK c WHERE e.file_id = c.file# AND e.block_id "= c.block# + c.blocks - 1 AND e.block_id + e.blocks - 1 := c.block# UNION SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file# , header_block corr_start_block# , header_block corr_end_block# , 1 blocks_corrupted FROM dba_segments s, V$NONLOGGED_BLOCK c WHERE s.header_file = c.file# AND s.header_block between c.block# and c.block# + c.blocks - 1 UNION SELECT null owner, null segment_type, null segment_name, null partition_name, c.file# , greatest#f.block_id, c.block#$ corr_start_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ - greatest#f.block_id, c.block#$ + 1 blocks_corrupted FROM dba_free_space f, V$NONLOGGED_BLOCK c WHERE f.file_id = c.file# AND f.block_id "= c.block# + c.blocks - 1 AND f.block_id + f.blocks - 1 := c.block# order by file#, corr_start_block# / This is the best outcome to get if you notice corruption errors. All errors are related to index corruption so we could fix this problem rebuilding index. alter index idx_obj_name rebuild; Simply issuing "alter index rebuild" command won't work. We should mark index unusable to drop segment before rebuilding it or just rebuild index with online option. It is better choice to mark index unusable because you don't need additional space then, but I will simply rebuild index with online option and see what will happen. SQL: alter index idx_obj_name rebuild online; Index altered. SQL: select count#*$ from objects where object_name like 'A%'; No errors... but, let's validate datafile for corruption. RMAN: backup validate check logical datafile 5; Notice "Marked Corrupt" column. Hm... 457 like before. Don't worry, this is not new corruption. These are FREE blocks which will be reused and Oracle will automatically re-format those blocks. Query the v$nonlogged_block view again as given above. We could force re-formatting creating dummy table and inserting data to dummy table. Check Doc ID 336133.1. create table s # n number, c varchar2#4000$ $ nologging tablespace DEMO1; SQL: BEGIN FOR i IN 1..1000000 LOOP INSERT /*+ APPEND */ INTO sys.s select i, lpad#'REFORMAT',3092, 'R'$ from dual; commit ; END LOOP; END; / SQL: drop table sys.s purge; Notice that we don't have corrupted blocks any more. RMAN: backup validate check logical datafile 5;
Views: 212 OracleDBA
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 186488 Manish Sharma
Oracle SQL Developer Tutorial For Beginners   16   DBA Info   DBA TABLESPACES
 
01:02
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 2964 Sam Dhanasekaran
Oracle Administration Tutorial - Understanding Tablespaces and Datafiles (Theory).mp4
 
09:03
Oracle Administration Tutorial - Understanding Tablespaces and Datafiles
Views: 46505 maurice ford
SCPT 6:Data Files in Oracle
 
21:17
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 53076 Oresoft LWC
Oracle Database Tutorial 52 : Data Pump expdp - How to Export full database using expdp
 
07:26
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp utility here in this tutorial you'll learn how to export full/complete Database using expdp data pump utility of oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/database-full-export-using-expdp Tut 48 Roles: http://youtu.be/tyYxSrCXzCM ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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 [email protected] 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: 79231 Manish Sharma
Oracle DBA - Tablespaces
 
10:54
http://oracledbazerotopro.com This tutorial explains Oracle Tablespaces.
Views: 82405 HandsonERP
Creating Tablespace using Oracle Enterprise Manager
 
05:02
STEPS: 1. Login into Enterprise manager 2. click on server tab - tablespace 3. inside tablespace window you can found default tablespace Example Sysaux System Temp Undo Users Now we going to create our own table-space, To create a new tablespace just click create button on right hand side 4. Now enter Tablespace name, Select extent management type as: Local Type: you can select permanent , temp, undo NOTE: Permanent tablespace:- Data persistent beyond duration of a session or transcation, objects in permanent tablespaces are stored in datafile. Temporary tablespace:- It contain objects only for a session or transcation, objects are stored in temp files Undo tablespacee:- It store data permanently, it important role is to provide read consistency for SELECT statement. the ability to rollback a transcation if it is failed to commit. Status: read,write mode 5. Click on add button to add datafile give name for datafile, size then give ok Thank you for watching Blog:- http://ramprasath91.blogspot.in/
Views: 4347 TechWizard
How to create an user and to grant all privileges to them in Oracle database
 
03:52
This video shows you how to create a new user and to grant privileges to them. Syntax to create a new user: create user username identified by password
Views: 38274 Thamizharasan Mohan
23. Grant, Revoke and Grant Table View to other user in Oracle
 
09:44
In this video you will learn many things in simple and easy way. Create User, Create Role, Grant Permission on Role, Pass role to user, Pass table to other user, Grant Table permissions to other user for table access etc are the points you will learn here. 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: 41720 ITORIAN
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: 953 Praveen Biyyapu
8. CREATE, INSERT and SELECT commands
 
15:42
In this video you will learn how to execute CREATE, INSERT and UPDATE commands. I will show you by executing these command and you will understand it easily. We will also cover its theory part before demo. 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: 138327 ITORIAN
creating a directory object en oracle Database 11g
 
02:41
creando un directorio en donde se guardaran nuestros dumps con el Enterprise Manager 11g http://www.mrlocooracle.com
Views: 2820 MrOracle Adolfo Luna
How to Create SCOTT Schema and default tables in Oracle Database 11g
 
04:31
Looking for a best Webhosting Company at low and Best Service click this link:https://www.ipage.com/join/index.bml?AffID=739220 From Last Few Months I Was Looking For Best Webshosting Company Where I Can Host My 100 Of Website At Low Price And With Best Quality Service , And Then I Came To Know About https://www.ipage.com/join/index.bml?AffID=739220 A Hosting Company Where I Get Hosting For Unlimited Domains At Just 1.6$ Per Month With Control Panel , 24hrs Support And All In All A Best Platform To Host Any Website( one-click install wordpress option) .Dont Be Late Offer Valid Till 25th October 2014 , Host Your WebSite With Best Service Provider Today By Clicking The Link Above Or Here: https://www.ipage.com/join/index.bml?AffID=739220 To get a responsive and Modern design contact http://www.variabletips.com and get at just 20$ Now !!! Check my Website: http://variabletips.com for more details. If there is no Oracle default scott schema is available after the installation of Oracle 11g database in windows, Then how to create the scott schema and the default tables like emp , dept, bonus, salgrade in database. Here is a easy step by step tutorial to create it in your database. Open the sql plus in your system. Login as username : sys as sysdba and the password which is given at the time of installation. After connected to Oracle database you need to create the scott schema. Run this script: CREATE USER scott IDENTIFIED BY tiger; scott is the user tiger is the password. Grant all access to user scott,run this script: GRANT ALL PRIVILEGES TO scott; Download the Oracle default tables file: https://www.dropbox.com/s/m9lr8cnc00vqy3i/oracle.zip https://drive.google.com/file/d/0BxJYa0O21A_udlZqQmNZaFBvNTA/edit?usp=sharing Extract the downloaded file in your system. Then Connect to Scott user as: CONNECT scott Password: tiger Then type this in your sql command prompt: @(extract file path)\oracle.sql; for example: @C:\Users\ABC\oracle\oracle.sql; Now you done all the steps completely and you can work with scott schema and all the default tables. Check This in your system to show all the tables in scott user: Select * from tab; After that you can see all the default table in scott user. Just run it to show the default data inside the tables. Select * from emp; If 14 row selected....Then You sucessfully Created the scott schema and the default Oracle tables in your system. Like and subscribe this video: http://www.youtube.com/watch?v=vHcAs7k93AQ
Views: 17628 variabletips
Oracle SQL Developer Tutorial For Beginners  14   Basics of a SELECT statement
 
02:39
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 3778 Sam Dhanasekaran
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]ev 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: 7263 BhagyaRaj Katta
Oracle SQL Developer Tutorial For Beginners   17   Selecting Particular Columns
 
01:47
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 2628 Sam Dhanasekaran
Oracle Database Tutorial 63 : Introduction to Tablespace In Oracle Database
 
04:26
Introduction to tablespace in oracle database consist Brief intro of tablepsace, type of tablespace, Big and small file tablespace, intro of Data files in oracle By manish sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/tablespace-introduction-rebellionrider Previous Tutorial ► Indexes https://youtu.be/F5NrQYD4a9g ------------------------------------------------------------------------- ►►►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: 37290 Manish Sharma
Oracle SQL Developer Tutorial For Beginners  27   DML   SELECT
 
00:37
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 1671 Sam Dhanasekaran
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: 30029 OCP Technology
Oracle 11G- Using Data Dictionary Views to Get Information on Database Objects
 
13:09
We can use Various Data Dictionary Views such as V$TABLESPACE, V$DATAFILE, DBA_ROLES, DBA_USERS DBA_PROFILES, DBA_DATA_FILES, DBA_TABLES, DBA_TABLESPACES etc to get the Information about Various Data Objects. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers.
Views: 3521 TheSkillPedia
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: 10878 AKHTAR HUSSAIN SHAIKH
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: 1740 ANKUSH THAVALI
Oracle Database Tutorial 53 : Data pump expdp - How to Export tablespace in Oracle Database
 
06:26
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp export utility here in this tutorial you'll learn how to export tablespace using expdp export (a.k.a. How To Take Logical Backup of tablespaces in oracle database). Data pump expdp Tablespace Mode ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/export_tablespace_expdp_datapump Previous Tutorial (Tut 52 Full export) http://youtu.be/K8_PjUksT54 ------------------------------------------------------------------------- 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 [email protected] 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: 33013 Manish Sharma
Oracle SQL Developer Tutorial For Beginners   22   Accessing the Objects
 
00:55
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 1996 Sam Dhanasekaran
SQL Prompt - find invalid objects
 
01:47
SQL Prompt is a code completion, code formatting, and refactoring tool for SQL Server. It’ll plug into SQL Server Management Studio or Visual Studio. You’ll find you can work more quickly and accurately with SQL queries, as well as standardize across your team by sharing formatting styles and commonly used SQL snippets. Try it free for 28 days at www.red-gate.com/sqlprompt In this tip Data Platform MVP Ike Ellis explains how to use SQL Prompt to find invalid objects, so you can catch problems earlier in development and resolve issues quickly. For more tips for writing SQL effortlessly check out the #SuperSQLTips playlist: https://www.youtube.com/playlist?list=PLhFdCK734P8A_q6XHDXi4CQzys3R0Jw3X Transcript: Hi I'm Ike Ellis and I’m going to show you a cool feature of SQL Prompt. One of the issues with T-SQL is that doesn't really tell you when you have dependencies with your objects by default. So if I create a table right here like the customers table and then I create a stored procedure that's dependent on the customers table and then later on at some point I delete the customers table like I drop table customers, there's no warning here telling me that I've got a procedure using that table. Software development teams have struggled with this for a very long time. Often what they'll do is at one step in the release pipeline they'll drop and recreate all the stored procedures, or all their views or all their functions and then it will warn them to tell them that they have a dependency in the drop and recreation. But the problem with that is you have to remember to do it - you have to do it manually or automatically - and you actually have to do it at the last step of your release pipeline, well after you've made any schema changes or else you really didn't do anything useful. But one thing you can do with Redgate SQL Prompt is you can right-click on your database and you can say ‘find invalid objects’ and it will warn you, it will say “hey this store procedure is dependent on a table that's no longer here”. And if you get used to doing this you can do it way earlier in the development process. You can do it every day or at the end of every day or before you check in a source control, and then you can catch your problem before any other developer on your team finds the problem. We know that when a developer finds his own problem or her own problem that it's far cheaper, way easier to resolve, all good things. So thanks, hope you enjoyed this tip and you find out for yourself by downloading the latest SQL Prompt. Thanks have a great day.
Views: 1620 Redgate Videos
How to use Oracle SQL Loader sqlldr to load data into table from text file
 
11:37
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: 47682 Abbasi Asif
Oracle SQL Developer Tutorial For Beginners  21   How objects are stored
 
01:04
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 2280 Sam Dhanasekaran
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: 570 DBA Genesis
USER MANAGEMENT CREATE USER DROP USER   CASCADE
 
07:46
USER MANAGEMENT HOW TO CREATE A USER ===================== create user naveen identified by naveen; create user pavan identified by pavan default tablespace king; HOW TO DROP USER ================= drop user naveen; (it will work if no objects) drop user pavan cascade; HOW TO GRANT ORACLE PREDEFINED ROLES TO USER ============================================ grant connect,resource to naveen; select * from session_privs; set lines 180 pages 200 col username for a30 select username,default_tablespace,temporary_tablespace from dba_users where username like '&user';
Views: 439 Praveen Biyyapu
How To Create SmallFile Tablespace
 
03:41
Hi.. Guys In This Video We Learn How To Create Small File Tablespace In Oracle 11g On Windows Using Logging Extent Management Local AutoAllocate Segement Space Management Auto
Views: 108 PGT POINT
Oracle Database Tutorial 55: How to export tables using PARFILE in expdp Data Pump By Manish Sharma
 
05:31
In this Oracle Tutorial you will learn how to export tables of the database using Parameter File (PARFILE) in Data Pump expdp export utility. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/expdp-parfile-table-mode-export Previous Tutorial Tut 52 Expdp Full Database http://youtu.be/K8_PjUksT54 Tut 53 Expdp Tablespace http://youtu.be/-hXBZd-FCjs Tut 54 Expdp Schema http://youtu.be/t8TSLDGN5gg ------------------------------------------------------------------------- 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 [email protected] 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: 27041 Manish Sharma
Oracle Database Tutorial 56:Data Pump impdp table and Duplicate (Remap_table ) table
 
06:03
In this oracle database tutorial you will learn How to import table using impdp data pump import utility. And how to rename table using REMAP_TABLE in impdp Data Pump import. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/oracle-data-pump-impdp-import-and-duplicate-table-remap-table Previous Tutorial Tut 55 expdp table- http://youtu.be/5mdmCqGuok8 Tut 54 expdp Schema - http://youtu.be/t8TSLDGN5gg Tut 53 expdp Tablespace - http://youtu.be/-hXBZd-FCjs Tut 54 expdp Full Database - http://youtu.be/K8_PjUksT54 ------------------------------------------------------------------------- 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 [email protected] 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: 24473 Manish Sharma

Grisbi windows francais
Msie 5 0 windows 98
Windows server 2008 r2 language pack
Restart a windows service
Php smtp auth windows 7