Home
Search results “Oracle auditing alter user”
Examples on Oracle Database Auditing |  Oracle Database Security | auditing in oracle 11g
 
21:15
This is the part of the series "Oracle DBA Videos" on Oracle Database Security. The following topics are covered in practical -- General idea about database auditing -- Statement level auditing -- Privilege level auditing -- Object level auditing
Views: 12628 Wysheid Wysheid
Create Delete User and Alter Password in Oracle
 
14:56
Helloo... My name is Syed Zeerak Please subscribe my page UNI TECHNO WORLD to get more videos.. create User USER_NAME identified by PASS Default Tablespace users Temporary Tablespace temp; select username from dba_users; grant create session to students; Alter user USER_NAME identified by NEW_PASS;
Views: 33 Uni_techno World
Audit table changes in sql server
 
06:45
sql server 2008 ddl trigger audit sql server table changes tracking In this video we will discuss, how to audit table changes in SQL Server using a DDL trigger. Table to store the audit data Create table TableChanges ( DatabaseName nvarchar(250), TableName nvarchar(250), EventType nvarchar(250), LoginName nvarchar(250), SQLCommand nvarchar(2500), AuditDateTime datetime ) Go The following trigger audits all table changes in all databases on a SQL Server. CREATE TRIGGER tr_AuditTableChanges ON ALL SERVER FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS BEGIN DECLARE @EventData XML SELECT @EventData = EVENTDATA() INSERT INTO SampleDB.dbo.TableChanges (DatabaseName, TableName, EventType, LoginName, SQLCommand, AuditDateTime) VALUES ( @EventData.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'varchar(250)'), @EventData.value('(/EVENT_INSTANCE/ObjectName)[1]', 'varchar(250)'), @EventData.value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(250)'), @EventData.value('(/EVENT_INSTANCE/LoginName)[1]', 'varchar(250)'), @EventData.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'nvarchar(2500)'), GetDate() ) END In the above example we are using EventData() function which returns event data in XML format. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/audit-table-changes-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/audit-table-changes-in-sql-server_12.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html Full SQL Server Course https://www.youtube.com/playlist?list=PL4cyC4G0M1RQ_Rm52cQ4CcOJ_T_HXeMB4 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 39999 kudvenkat
PL/SQL tutorial 18: DDL Trigger with Schema Auditing Example
 
08:12
Learn how to create a DDL Trigger in Oracle Database with Schema Auditing Example where we will learn how to keep an any on which object is created, altered or drop and by who. Manish Sharma From RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/DDL-Trigger Previous Tutorial ►PL/SQL Tut 14 Triggers Introduction https://youtu.be/R3fvX_xf5P4 ► PL/SQL Tut 17 Table Backup Using DML Trigger https://youtu.be/jSv1LIlNKU0 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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 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: 44574 Manish Sharma
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: 15398 Wysheid Wysheid
PL/SQL tutorial 16: Table Auditing using DML Triggers in Oracle PL/SQL
 
09:55
Learn Table Auditing using DML Triggers in Oracle Database and Increase the level of security by keep an eye on user tempering your table data. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/table-auditing Previous Tutorial ► DML Triggers with Examples https://youtu.be/-OR7zLzCh_I ► Select-Into Statement: https://youtu.be/F5eMJhwmCQs ►Sysdate Blog : http://bit.ly/sysdate-in-oracle-by-rebellionrider ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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 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: 69650 Manish Sharma
Security of Users in Oracle to assign Profiles
 
23:18
Hello friends today i will explain to you a brief #SecurityofUsers #OracleProfiles introduction of Users and Profile monitoring to get more security. Oracle database Unbeatable,Unbreakable Platform..
Views: 6715 Oracle World
Oracle DB - Alert Log, Trace Files & ADR
 
02:21
Oracle DB - Alert Log, Trace Files & ADR Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
PL/SQL tutorial : Trigger in Oracle Database 11g Complete guide
 
26:21
Learn in depth about trigger in oracle database 11g, and usage of trigger in Database, different types of trigger with syntax for various events along with writing advance trigger and capturing all details regarding authentication. Explained Instead of trigger. Trigger in Oracle, Trigger in PL/SQL, Oracle Trigger, PL/SQL Trigger, What is Trigger in pl/sql, How to use Trigger in pl/sql, How to write a Trigger in oracle, How to design Trigger in pl/sql, DDL trigger, DML trigger, Instead of trigger, Compound trigger, Logon trigger, Introduction to Triggers You can write triggers that fire whenever one of the following operations occurs: DML statements (INSERT, UPDATE, DELETE) on a particular table or view, issued by any user DDL statements (CREATE or ALTER primarily) issued either by a particular schema/user or by any schema/user in the database Database events, such as logon/logoff, errors, or startup/shutdown, also issued either by a particular schema/user or by any schema/user in the database Triggers are similar to stored procedures. A trigger stored in the database can include SQL and PL/SQL or Java statements to run as a unit and can invoke stored procedures. However, procedures and triggers differ in the way that they are invoked. A procedure is explicitly run by a user, application, or trigger. Triggers are implicitly fired by Oracle when a triggering event occurs, no matter which user is connected or which application is being used. How Triggers Are Used Triggers supplement the standard capabilities of Oracle to provide a highly customized database management system. For example, a trigger can restrict DML operations against a table to those issued during regular business hours. You can also use triggers to: Automatically generate derived column values Prevent invalid transactions Enforce complex security authorizations Enforce referential integrity across nodes in a distributed database Enforce complex business rules Provide transparent event logging Provide auditing Maintain synchronous table replicates Gather statistics on table access Modify table data when DML statements are issued against views Publish information about database events, user events, and SQL statements to subscribing applications Linkedin: https://www.linkedin.com/in/aditya-kumar-roy-b3673368/ Facebook: https://www.facebook.com/SpecializeAutomation/
Views: 9711 Specialize Automation
Global Index rebuild scenario in Oracle Database 11g
 
08:41
Why and How we need to rebuild global Index in Oracle 11g
Views: 3032 Athar Fahad
02. ddl commands in sql in oracle database
 
13:49
this video is about ddl commands in oracle database
Views: 1587 C4C
Oracle Database Profiles
 
02:09
Senior instructor Darryl Balaski shows you how to set up and use Oracle Database profiles to grant and limit access to database usage and instance resources for various users.
4 steps to reduce Oracle Audit Claims by 90%
 
04:20
Need help reducing the Oracle Audit Report? I used to work at Oracle sales negotating Oracle Audits
Views: 156 Fredrik Filipsson
PL/SQL tutorial 21: How To Create Startup Trigger In Oracle Database By Manish Sharma
 
03:08
Learn how to create a startup trigger with easy to understand example or startup auditing in oracle database by Manish Sharma RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/startup-shutdown-database-trigger Previous Tutorial ► PL/SQL tutorial 20: 'LogOff' Trigger https://youtu.be/l5lcE68xK-k ►PL/SQL tutorial 19: 'LogOn' Trigger https://youtu.be/dJSlgiwt7w0 ►SQL tutorial 46: System Privileges https://youtu.be/EQzdtKPiErU ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ 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: 23154 Manish Sharma
How to implement VPD in Oracle Database (Part 1)
 
12:37
How to implement VPD (Virtual Private Database) in Oracle Database(9i,10g,11g,12c) Enterprise Edition. PART 1 Video links: Part 1 https://youtu.be/JVvtvh3cN1I Part 2 https://youtu.be/xLcin_Wgbvs Part 3 https://youtu.be/mE1cSbmEwnQ This is Part of Oracle Advance Security. Please view my earlier videos on how to create a database , if you are not having a database. 1)First we will create the users needed for our environment a)Owner of the schema which will have the objects or tables b)security admin user c)non owner user1 & user2 which will have limited access as per data in the rows (here user1 will have access to data with HR and user2 with FINANCE) Object owner creation: -------------- CREATE USER schemaowner IDENTIFIED BY schemaowner DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; GRANT connect, resource TO schemaowner; alter user schemaowner quota unlimited on users; security admin user creation: -------------- CREATE USER SEC_ADM IDENTIFIED BY sec_adm default tablespace users temporary tablespace TEMP; GRANT CONNECT, RESOURCE TO sec_adm; alter user sec_adm quota unlimited on users; garnts for the sec_adm user: ------------- GRANT CREATE SESSION,CREATE ANY CONTEXT,CREATE PROCEDURE,CREATE TRIGGER, ADMINISTER DATABASE TRIGGER TO SEC_ADM; GRANT EXECUTE ON DBMS_SESSION TO SEC_ADM; GRANT EXECUTE ON DBMS_RLS TO SEC_ADM; create user with restricted access on table: ----------------------- CREATE USER user1 IDENTIFIED BY user1 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; GRANT connect, resource TO user1; CREATE USER user2 IDENTIFIED BY user2 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; GRANT connect, resource TO user2; Now we will log in as schemaowner and create one tables : ------------------- CONN schemaowner/schemaowner This table is the table which contains the secure as well as un-restricted data CREATE TABLE user_data (column1 VARCHAR2(50) NOT NULL, user_id VARCHAR2(30) NOT NULL); Now to access this table from other schema we need to give the select and insert privs to: GRANT SELECT, INSERT ON user_data TO sec_adm,user1, user2;
Views: 839 OracleDBA
Oracle Database 12c Tutorial 4: How to install sample schemas / users in Oracle Database 12c
 
08:33
Learn how to install sample schemas or users in oracle database 12c, In this tutorial you will also learn how to create a pluggable database in oracle database 12c by manish sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-install-sample-schema-users-hr-sh-in-oracle-12c Previous Tutorial ► Tut 61: How To Unlock HR schema in Oracle Database 12c http://youtu.be/F81gfUnznZY ------------------------------------------------------------------------- ►►►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 [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: 52869 Manish Sharma
Oracle - SQL - Create Table
 
08:52
Oracle - SQL - Create Table Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Module 1- Introduction to Oracle Database
 
13:39
Hello viewers, We are starting our section on professional courses and for which we are starting our course material which is based on the Oracle Database, Please refer to the description below for knowing which topics will be covered in Oracle DBA Installation Module 1 – Introduction to Database • Introduction to Database • How ORACLE DB does it • Unix kernal Module 2 – Physical Database Structure • Physical Database Structure • Control files • Key information of files • Redo log files Module 3 – Oracle Storage structures • Oracle Storage structures • Table statement • How to check “create table” • Schemas and schema objects • Data blocks • Extents • Segments Module 4 – Memory & Process Architecture • Memory & Process Architecture • Instance/Memory structures • Shared pool • Buffer Cache • Redo Log Buffer • Process Architecture • Background process Module 5 – Background Process, Alert & Trace files • Background Process, Alert & Trace files • Alert • Trace files Module 6 – Database Startup & Serving User Requests • Database Startup & Serving User Requests • Offline backup • Standby Database Module 12 – Oracle Recovery Manager (RMAN) • Oracle Recovery Manager (RMAN) • Data pump export & import • SQL loader • External table Module 13 – Data dictionary & Dynamic Performance Tables • Data dictionary & Dynamic Performance Tables • Dynamic performance Tables • Typical day ORACLE DBA Module 14 – Introduction to Database Tuning • Introduction to Database Tuning • Monitor space usage • Monitor SQL scripts • Data base tuning • SQL tuning • Table Statistics • Index statistics • Index Selectivity • Chained Rows • Locks Module 15 – Introduction to Database Tuning Continued • Introduction to Database Tuning Continued • Tuning Shared pool • Data dictionary performance • Data dictionary tuning • PL/SQL code • Code reuse • Data base Buffer • Buffer cache hit Ratio • Code reuse • Database Startup • User process, Server process Module 7 – Database Security • Database Security • Process of “Create User” • Alter & Drop User • Resource Limits & profiles • Auditing Module 8 – Schema Objects • Schema Objects • Types of schema objects • How table data is stored • Temporary Tables • External Tables Module 9 – Schema Object Continued • Schema Object Continued • Materialized View • Sequence Generator • Indexes • B-Tree index structure • Cluster/Hash Cluster • Data concurrency & consistency • Locking • Deadlocks Module 10 – Oracle Network Environment • Oracle Network Environment • How to connect your database • Network environment of ORACLE • Database link Module 11 – Oracle Backup & Recovery Concepts • Oracle Backup & Recovery Concepts • Standby database • Testing • Media recovery options so in today's video, we will be discussing Module -1 The Introduction to Oracle Database. ----------------------------------------------------------------------------------------------------------- For downloading notes in PDF format please visit my Blog https://thedynamicstudy.blogspot.com/ ---------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------- Please go through the video and don't forget to share your views and subscribe the channel to keep the content open and reachable to students. ---------------------------------------------------------------------------------------------------- keep on watching, keep on learning! #dynamicstudy -~-~~-~~~-~~-~- Please watch: "OCTAPACE - Detailed Explanation in Hindi" https://www.youtube.com/watch?v=f_4WET6y49c -~-~~-~~~-~~-~-
Views: 45 Dynamic Study
Basic Security Oracle   Users, Role, Privilage
 
07:41
Tutorial, membuat Users, Role, Privilage, di oracle 12c menggunakan.
Views: 42 BangCode
user management in oracle 11g
 
17:34
user management in oracle 11g
Views: 110 database exert
Change INITRANS on table in Oracle database
 
01:36
http://dbacatalog.blogspot.com
Views: 596 dbacatalog
SQL tutorial 40: DBA Trick, How to drop a user when it is connected to the database
 
08:21
Watch in HD,Dropping a user is easy only when it is not connected to the database what if it is connected. Learn how to drop a user when it is connected to the database as well as when it is not connected, along with the cascade drop and introduction of Startup RESTRICT mode of Oracle database. ------------------------- Topics cover 1. Drop user when it is not connected to the database 2. Drop user cascade 3. Drop user when it is connected to the database 4. How to kill a session 5. Oracle Start-up Restrict 6. What is Restrict Start-up and why we use it. Please please LIKE and SHARE my videos it makes me happy. Links: Detail Blog (Must Read) http://bit.ly/drop-user Tutorial 38 Create user using SQL Developer http://youtu.be/GS4udgR44Ls Tutorial 37 Create user using SQL create user statement http://youtu.be/4QbK2Y-1LZw Tutorial 39 create user using EM http://youtu.be/zGjh-Bb3HrI Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon Follow What I am up to as it happens on Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ You can also Email me at [email protected] Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 21424 Manish Sharma
How to change of oracle database | Steps to change the database name using dbnewid or nid tool
 
16:40
This video describes the steps used for changing the db name using dbnewid tool . This utility is also known as nid
Views: 6356 Wysheid Wysheid
Oracle - SQL - DDL Statements
 
04:20
Oracle - SQL - DDL Statements Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Intermediate Oracle 11g - 7. User and Security
 
01:44:20
This Intermediate course expands on the Introduction to Oracle 11g course. It gives you a more detailed grass roots knowledge of Oracle SQL and Oracle PL/SQL. Author covers a wide range of topics including many types of queries, expressions, and statements. He also explores sequences, synonyms, views, materialized views, user access and security, working with indexes, and the basics of programming with PL/SQL. As with the introductory course, this intermediate course is not focused on Oracle Certification but will give you a good start towards some more advanced aspects of coding SQL and PL/SQL. Parts: 01. Oracle Security pt. 1 02. Oracle Security pt. 2 03. Types of Users 04. Create User Syntax pt. 1 05. Create User Syntax pt. 2 06. Using CREATE USER pt. 1 07. Using CREATE USER pt. 2 08. Alter and Drop User Syntax 09. Using ALTER and DROP USER 10. Oracle Power Users 11. Resources and Profiles 12. Privileges pt. 1 13. Privileges pt. 2 14. Granting and Revoking Privileges 15. Using GRANT pt. 1 16. Using GRANT pt. 2 17. Using REVOKE 18. Group Privileges Using Roles 19. Setting Roles 20. Metadata Views pt. 1 21. Metadata Views pt. 2
Views: 18 Free Training
How to view table structure in oracle database .
 
00:28
How to view table structure in oracle database .
Views: 430 latest ITChannel
Oracle Database How to Unlock Account HR Login Authentication
 
02:40
Unlock HR sample account in oracle,How to unlock HR account in Oracle by using SQL plus. and You will see connect in to SQL developer with has as below to configure: Connnection Name: put anything about your connection. Username : hr or sys Password : depend on your Username Role : default(for other account) sysdba(for user sys) Hostname : localhost or take an ip address to submit or Your computer name without space. SID : Your database name _________________________________________ How to connect into SQL with Oracle 11g How to unlock user HR and change password How to see my database name in Oracle 11g How to know my database name in Oracle 11g How to configure with oracle
Views: 8704 Cambo Tutorial
Column-Level Virtual Private Database (VPD)
 
07:19
Hi guys today we learn about security using VPD in oracle 11g release 2 to hide data from unauthorized users.#VirtualPrivateDatabase #VPD Oracle database Unbeatable,Unbreakable Platform..
Views: 1870 Oracle World
DDL Triggers in sql server
 
12:31
ddl trigger example ddl trigger example in sql server ddl triggers can be used to In this video we will discuss DDL Triggers in sql server. In SQL Server there are 4 types of triggers 1. DML Triggers - Data Manipulation Language. Discussed in Parts 43 to 47 of SQL Server Tutorial. 2. DDL Triggers - Data Definition Language 3. CLR triggers - Common Language Runtime 4. Logon triggers What are DDL triggers DDL triggers fire in response to DDL events - CREATE, ALTER, and DROP (Table, Function, Index, Stored Procedure etc...). For the list of all DDL events please visit https://msdn.microsoft.com/en-us/library/bb522542.aspx Certain system stored procedures that perform DDL-like operations can also fire DDL triggers. Example - sp_rename system stored procedure What is the use of DDL triggers If you want to execute some code in response to a specific DDL event To prevent certain changes to your database schema Audit the changes that the users are making to the database structure Syntax for creating DDL trigger CREATE TRIGGER [Trigger_Name] ON [Scope (Server|Database)] FOR [EventType1, EventType2, EventType3, ...], AS BEGIN -- Trigger Body END DDL triggers scope : DDL triggers can be created in a specific database or at the server level. The following trigger will fire in response to CREATE_TABLE DDL event. Use SampleDB Go CREATE TRIGGER trMyFirstTrigger ON Database FOR CREATE_TABLE AS BEGIN Print 'New table created' END To check if the trigger has been created 1. In the Object Explorer window, expand the SampleDB database by clicking on the plus symbol. 2. Expand Programmability folder 3. Expand Database Triggers folder Please note : If you can't find the trigger that you just created, make sure to refresh the Database Triggers folder. When you execute the following code to create the table, the trigger will automatically fire and will print the message - New table created Create Table Test (Id int) The above trigger will be fired only for one DDL event CREATE_TABLE. If you want this trigger to be fired for multiple events, for example when you alter or drop a table, then separate the events using a comma as shown below. ALTER TRIGGER trMyFirstTrigger ON Database FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS BEGIN Print 'A table has just been created, modified or deleted' END Now if you create, alter or drop a table, the trigger will fire automatically and you will get the message - A table has just been created, modified or deleted. The 2 DDL triggers above execute some code in response to DDL events (CREATE_TABLE, ALTER_TABLE, DROP_TABLE). Now let us look at an example of how to prevent users from creating, altering or dropping tables. To do this modify the trigger as shown below. ALTER TRIGGER trMyFirstTrigger ON Database FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS BEGIN Rollback Print 'You cannot create, alter or drop a table' END To be able to create, alter or drop a table, you either have to disable or delete the trigger. To disable trigger 1. Right click on the trigger in object explorer and select "Disable" from the context menu 2. You can also disable the trigger using the following T-SQL command DISABLE TRIGGER trMyFirstTrigger ON DATABASE To enable trigger 1. Right click on the trigger in object explorer and select "Enable" from the context menu 2. You can also enable the trigger using the following T-SQL command ENABLE TRIGGER trMyFirstTrigger ON DATABASE To drop trigger 1. Right click on the trigger in object explorer and select "Delete" from the context menu 2. You can also drop the trigger using the following T-SQL command DROP TRIGGER trMyFirstTrigger ON DATABASE Certain system stored procedures that perform DDL-like operations can also fire DDL triggers. The following trigger will be fired when ever you rename a database object using sp_rename system stored procedure. CREATE TRIGGER trRenameTable ON DATABASE FOR RENAME AS BEGIN Print 'You just renamed something' END The following code changes the name of the TestTable to NewTestTable. When this code is executed, it will fire the trigger trRenameTable sp_rename 'TestTable', 'NewTestTable' The following code changes the name of the Id column in NewTestTable to NewId. When this code is executed, it will fire the trigger trRenameTable sp_rename 'NewTestTable.Id' , 'NewId', 'column' Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/ddl-triggers-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/ddl-triggers-in-sql-server_9.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 59742 kudvenkat
Oracle 9i Complete English Course Part 1  Class 60
 
06:13
Oracle 9i Complete English Course Part 1 Class 60 Watch here ► https://youtu.be/ZXgnhJOSJ2A Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 31
 
03:28
Oracle 9i Complete English Course Part 1 Class 31 Watch here ► https://youtu.be/Fu3SZS5fOvs Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 63
 
02:28
Oracle 9i Complete English Course Part 1 Class 63 Watch here ► https://youtu.be/AanUmzuwvAc Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 24
 
06:47
Oracle 9i Complete English Course Part 1 Class 24 Watch here ► https://youtu.be/2yUwRyz9aNo Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 77
 
02:40
Oracle 9i Complete English Course Part 1 Class 77 Watch here ► https://youtu.be/6MNj4no4i7w Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 44
 
05:28
Oracle 9i Complete English Course Part 1 Class 44 Watch here ► https://youtu.be/HoGdv_oTRxw Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 65
 
05:59
Oracle 9i Complete English Course Part 1 Class 65 Watch here ► https://youtu.be/EtrmjvNbwOg Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 16
 
04:56
Oracle 9i Complete English Course Part 1 Class 16 Watch here ► https://youtu.be/zhlJtHGMiQk Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 67
 
06:04
Oracle 9i Complete English Course Part 1 Class 67 Watch here ► https://youtu.be/fJPR7L3MQkE Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 17
 
03:04
Oracle 9i Complete English Course Part 1 Class 17 Watch here ► Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1 Class 52
 
03:55
Oracle 9i Complete English Course Part 1 Class 52 Watch here ► https://youtu.be/HSwnxC6iqs0 Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 50
 
06:53
Oracle 9i Complete English Course Part 1 Class 50 Watch here ► https://youtu.be/bFWBuO2H2QA Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 51
 
04:30
Oracle 9i Complete English Course Part 1 Class 51 Watch here ► https://youtu.be/03kLkcjz1JE Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 46
 
01:44
Oracle 9i Complete English Course Part 1 Class 46 Watch here ► https://youtu.be/orS0WQkoAZE Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle interview Question : what is trigger in oracle
 
10:56
Oracle interview Question : what is trigger in oracle Description: A Trigger is a special PLSQL code, that will be automatically invoked when a specific event occurs in the database. The even can be DML event, DDL event or SYSTEM event. What are the types of triggers? DML Trigger - This trigger will get fired for DML events like INSERT,UPDATE and DELETE DDL trigger - This trigger will get fired for DDL events like CREATE, ALTER, DROP, TRUNCATE etc., System trigger - This trigger will get fired for system events like LOGON, LOGOFF, STARTUP, SHUTDOWN etc Instead of trigger - This trigger is created on view to redirect the DML operations to undelying base tables compound trigger - This is a single trigger having blocks for all the DML timing events. List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 617 Siva Academy
Oracle 9i Complete English Course Part 1  Class 57
 
04:23
Oracle 9i Complete English Course Part 1 Class 56 Watch here ► https://youtu.be/kKKiq6UY-EY Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 43
 
06:52
Oracle 9i Complete English Course Part 1 Class 43 Watch here ► https://youtu.be/_wXrN0QNgkA Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 25
 
06:23
Oracle 9i Complete English Course Part 1 Class 25 Watch here ► https://youtu.be/8bWXkduVBIw Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...

Ranitidine 300 mg side effects ip 254
Seroflo 25 125x88 spotting scope
Pret cialis 20 mg
Lek propranolol 10 mg
Zebinix 800 mg motrin