Home
Search results “Oracle partition index status”
Local Vs Global Partitioned Index in Oracle 11g
 
17:30
The Video Explains the difference between Local Partitioned Indexes(Prefixed vs Non Prefixed Indexes). and Global Partitioned Index along with the challenges in maintaining Global partitioned Indexes when the underlying tables partitioned is dropped/truncated/Merged/Moved. Local Partitioned Index Shares the same boundaries as the table and are in the same number as table partitions they are widely used in DSS and DWH systems. While Global Partitioned Index are predominantly used in OLTP systems
Views: 8780 Tech Coach
Stop Rebuilding Global Indexes! Oracle 12c Global Index Maintenance
 
09:00
Stop rebuilding Global Indexes! Stop worrying about invalidating Global Indexes! Oracle 11g gave us "UPDATE GLOBAL INDEXES". 12c provides a huge improvement: orphaned_entries! In this tutorial, Oracle Certified Master John Watson demonstrates how 11g and 12c handle Global Index maintenance with orphaned entries and overnight maintenance job PMO_DEFERRED_GIDX_MAINT_JOB.
Views: 2672 SkillBuilders
KISS series on Partitioning: 01 Our first partitioned table
 
04:01
Welcome to the KISS video series on Partitioning, where we take a more developer-centric look at how partitioning can make our applications more successful. In this session, we look at how to create our very first range partitioned table Scripts: https://livesql.oracle.com/apex/livesql/file/content_EM2X7EIHU60Z888IOU53RF0EN.html ========================================­­============== Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1324 Connor McDonald
Table Shrinking in Oracle Database
 
14:15
1.Shrink the Table: Shrinking is started from 10g. In this method I’m using user u1 and table name sm1. Now I’m deleting some rows in sm1 COUNT ---------- 1048576 Table sm1 has 1048576 rows. [email protected]: delete from sm1 where deptno=10; 262144 rows deleted. I deleted above number of rows. Rows COUNT ---------- 786432 And I’m giving commit [email protected]: commit; Commit complete. So now we have 786432 rows in sm1 table. Now see the following command [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 After I deleted some rows in sm1 table still above result showing same values, so now our duty is shrink this table. This is done by following 2 ways, i By using COMPACT key word: In this method shrinking is done in two phases. In the first phase all fragmented space are just defragmented, but still the High Water Mark is persist with last used block only. That mean used free blocks are not de allocated and HWM is not updated here. Issue the following command before use shrink command. [email protected] alter table sm1 enable row movement; Table altered. There is particular use with above command, when we shrink the table all rows are moves to contiguous blocks, so here row movement should be done. By default the row movement is disabled for any table, so above command enabled the row movement. Then execute shrink command now. [email protected]: alter table sm1 shrink space compact; Table altered. Now see the space of table by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 So here seems nothing happened with above shrink command, but internally the fragmented space is defragmented. But the high water mark is not updated, used free blocks are also not de allocated. For de allocating the used blocks we have to execute below command. This is the second phase. [email protected]: alter table sm1 shrink space; Table altered. Now see the space by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ---------- ---------- ---------- U1 U1TS SM1 TABLE 20.8125 mb 2664 36 So now the space of sm1 table is reduced. Note: Actually the alter table sm1 shrink space command will complete these two phases of the shrinking of table at a time. But here we done shrink process in two phases because when we use alter table sm1 shrink space command the table locked temporarily some time period, during this period users unable to access the table. So if we use alter table sm1 shrink space compact command the table is not locked but space is defragmented. When we not in business hours issue the second phase shrink command then users are won’t get any problem. ii Because of above method the table dependent objects are goes to invalid state, to overcome this problem we have to use below command. [email protected]: alter table sm1 shrink space cascade; Table altered. The above command also shrinks the space of all dependent objects. We also do this in two phases like above two phases. See the below command. [email protected]: alter table sm1 shrink space compact cascade; Table altered. And then [email protected]: alter table sm1 shrink space cascade; Table altered. Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8
Views: 7412 BhagyaRaj Katta
Oracle Database Administration Online Training
 
04:21
Feel free to contact Call : +91-8870903864 Or E-mail [email protected] Oracle Database Adminstration INTRODUCTION TO ORACLE DBA What is DBA ? • Why a Company needs a DBA? • Roles & Responsibilities of DBA • Oracle Architecture • Physical and Logical Phase of Database • Types of files(Control file, Redolog file and Datafile) • Different types of Datafiles • Instance • SGA(System Global Area) and Background Process • DATABASE CREATION • Different Startup Modes • Different Shutdown Modes • Types of Database Creation • Manual Method of Creation • TABLESPACE MANAGEMENT Introduction to Table space • Types of Table space(BIG & SMALL) • Temporary Table space • Altering/Renaming a Table space • Renaming a data file • Temporary Groups • Table space Encryption(11g) • STORAGE PARAMETERS • What are segments? • What are extents? • What is Blocks? • Oracle Blocks • Estimation of Extents • Dictionary Managed Table space • Locally Managed Table space • Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease) • USER MANAGEMENT • Who are Database Users? • Why to create a User? • Creation of Users • Assigning Privileges • Creating and granting Roles • Allocating table space Quotas to Users • Assigning default table space for the Users • Setting Profiles for the Users • Levels of Authentication • Schema Management(11g) • Security(11g) • UNDO MANAGEMENT • What is Undo? • Why Undo required? • Pending offline status • Brief idea about Rollback segments • Flashback Features • Flashback Table • Flashback query • Flashback Version query • What is spfile? • Difference between spfile and pfile • Advantages of spfile • What is OMF? • Advantages of OMF • Files conventions of OMF • NETWORKING IN ORACLE • Introduction to Oracle Networking • Network default location • Editing Network file • Tnsnames.ora Introduction to Database Links • Types of Database Links • Introduction to Materialized views • Advantages of Materialized view • Refresh Modes • REDO-LOG & CONTROLFILE MANAGEMENT Introduction to Redo log • Status of Redo logs • Multiplexing the Redo log files • Re-creation of Control file • Renaming the Database • Multiplexing the Control file • LOGICAL BACKUP What is a logical backup • Why it is required • Export/import Utility • Data Pump • Difference between Data Pump and Traditional Export/import • Impdp/expdp • Transportable Table spaces • PHYSICAL BACKUP Introduction to Physical backup • Types of Physical backup • Cold & Hot backup • Recovery scenarios • RMAN backup • RMAN Point in time recovery • RMAN 11g new features • PEFORMANCE TUNING What is Performance Tuning? • Why Tuning required? • Types of Tuning • Database Tuning • Tuning • SQL Tuning • Memory Tuning Network Tuning • Partitioning and Indexes • Partitioning Enhancements • AWR/ASH/ASMM/ADDM • RAT(Real Application Testing)(11g) • SQL Performance Analyses (11g) • Row chaining and Row migration • Resemble Table spaces Oracle Database Adminstration training online, Oracle Database Adminstration training material, IBM Websphere Application Server training cost, Oracle Database Adminstration training pdf, Websphere Application Server training in USA uae India, Oracle Database Adminstration training, online Corporate training malaysia Singapore, Oracle Database Adminstration software, Oracle Database Adminstration training in bangalore, Oracle Database Adminstration training institutes in hyderabad, Oracle Database Adminstration training in chennai, Oracle Database Adminstration training in hyderabad, Delhi, Mumbai, Pune, Oracle Database Adminstration, IBM Websphere ApplicationServer webinar, online training singapore, Oracle Database Adminstration eam, Oracle Database Adminstration as a service,Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training maximo scheduler, Oracle Database Adminstration (consumer product) Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training , Post Training Support
Views: 11 Trainers Online
Analytics: 17 The LAG / LEAD clauses
 
05:59
blog: https://connor-mcdonald.com Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at the lag and lead functions. The sample problem we'll solve is: Collapsing repeated rows in an order history table to show only the days where the order changed status Scripts: https://livesql.oracle.com/apex/livesql/file/content_CZUCT0MCOQZMJM7TI553HC8S9.html
Views: 505 Connor McDonald
Sybase Indexing for Performance
 
01:08:38
Sybase Adaptive Server Advanced SQL Programming and Optimization Single - Table Optimization Chapter Six In this webinar we examined detailed topics in query optimization: • Indexes with SARGs • Improvised SARGs • Clustered vs. Nonclustered Indexes • Queries with OR • Index Covering • Forcing Index Selection • Partition Support • Function-based Indexes
093 Oracle DBA Complete Tutorial- Using ADRCI to navigate through Diagnostic Data(By MrMerchant Co.)
 
08:23
Oracle Database Administrator ( Oracle DBA ) Complete Tutorial. Database Administration field has a lot of scope in Future because in today's world everything runs on data let says server, internet, mobile phones, bank account, books etc.... 093 Oracle DBA Complete Tutorial- Using ADRCI to navigate through Diagnostic Data(By MrMerchant Co.) Hope you like this video. Keep in touch with us and share this video with your friends. Like | Comment | Share | Subscribe |.
Views: 63 MrMerchant Co.
Subscriber Comments Reply Video 2
 
12:17
Subscriber Comments Reply Video 2 Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 418 Siva Academy
Over clause in SQL Server
 
09:13
over partition by in sql server 2008 sql server over clause partition partition by clause in sql server 2008 over partition by clause in sql In this video we will discuss the power and use of Over clause in SQL Server. The OVER clause combined with PARTITION BY is used to break up data into partitions. Syntax : function (...) OVER (PARTITION BY col1, Col2, ...) The specified function operates for each partition. For example : COUNT(Gender) OVER (PARTITION BY Gender) will partition the data by GENDER i.e there will 2 partitions (Male and Female) and then the COUNT() function is applied over each partition. Any of the following functions can be used. Please note this is not the complete list. COUNT(), AVG(), SUM(), MIN(), MAX(), ROW_NUMBER(), RANK(), DENSE_RANK() etc. Example : SQl Script to create Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Gender nvarchar(10), Salary int ) Go Insert Into Employees Values (1, 'Mark', 'Male', 5000) Insert Into Employees Values (2, 'John', 'Male', 4500) Insert Into Employees Values (3, 'Pam', 'Female', 5500) Insert Into Employees Values (4, 'Sara', 'Female', 4000) Insert Into Employees Values (5, 'Todd', 'Male', 3500) Insert Into Employees Values (6, 'Mary', 'Female', 5000) Insert Into Employees Values (7, 'Ben', 'Male', 6500) Insert Into Employees Values (8, 'Jodi', 'Female', 7000) Insert Into Employees Values (9, 'Tom', 'Male', 5500) Insert Into Employees Values (10, 'Ron', 'Male', 5000) Go Write a query to retrieve total count of employees by Gender. Also in the result we want Average, Minimum and Maximum salary by Gender. This can be very easily achieved using a simple GROUP BY query as show below. SELECT Gender, COUNT(*) AS GenderTotal, AVG(Salary) AS AvgSal, MIN(Salary) AS MinSal, MAX(Salary) AS MaxSal FROM Employees GROUP BY Gender What if we want non-aggregated values (like employee Name and Salary) in result set along with aggregated values You cannot include non-aggregated columns in the GROUP BY query. SELECT Name, Salary, Gender, COUNT(*) AS GenderTotal, AVG(Salary) AS AvgSal, MIN(Salary) AS MinSal, MAX(Salary) AS MaxSal FROM Employees GROUP BY Gender The above query will result in the following error : Column 'Employees.Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause One way to achieve this is by including the aggregations in a subquery and then JOINING it with the main query as shown in the example below. Look at the amount of T-SQL code we have to write. SELECT Name, Salary, Employees.Gender, Genders.GenderTotals, Genders.AvgSal, Genders.MinSal, Genders.MaxSal FROM Employees INNER JOIN (SELECT Gender, COUNT(*) AS GenderTotals, AVG(Salary) AS AvgSal, MIN(Salary) AS MinSal, MAX(Salary) AS MaxSal FROM Employees GROUP BY Gender) AS Genders ON Genders.Gender = Employees.Gender Better way of doing this is by using the OVER clause combined with PARTITION BY SELECT Name, Salary, Gender, COUNT(Gender) OVER(PARTITION BY Gender) AS GenderTotals, AVG(Salary) OVER(PARTITION BY Gender) AS AvgSal, MIN(Salary) OVER(PARTITION BY Gender) AS MinSal, MAX(Salary) OVER(PARTITION BY Gender) AS MaxSal FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/over-clause-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/over-clause-in-sql-server_29.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: 95290 kudvenkat
Oracle Database: Pract. Lecture #1: Intro to Oracle Database
 
16:53
Oracle Database ============================================== In this lesson you will learn what is oracle database, the hardware and hard disk space requirements, how to download oracle database from the official website for oracle corporation and the last step installing oracle database on your machine. It's ORDBMS "Object Relational Database Management System" Oracle Database Has been written in Assembly language, C, C++ Co founders: Larry Ellison and two friends and former co-workers, Bob Miner and Ed Oates. Oracle Database Available in Multilingual that’s mean it support many languages. License is not free, “Proprietary”. Development status for Oracle Database still Active. the first commercially available RDBMS was Oracle, released in 1979 by Relational Software, now Oracle Corporation.
Views: 362 KOYA IT
SQL Loader Bad file and Discard file Part 2  | Oracle SQL Tutorial | Mr.Murali
 
22:40
►For Registration : https://goo.gl/r6kJbB ►Call: +91-8179191999 ► Visit Our Website: http://nareshit.in/ http://nareshit.com/ ► About NareshIT: "Naresh IT is the Best Software Training Institute for Hadoop, Salesforce, AWS, DevOps, Sprak, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in Hyderabad, Chennai and Vijayawada, India which provides online and classroom training classes" ►For Registration : https://goo.gl/r6kJbB ►Call: India- 8179191999, USA- 404-232-9879 Email: [email protected] ►Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5.Share Video's of each and every session. Check The Below Links: ►For Course Reg : https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Visit Our Website: http://nareshit.in/ http://nareshit.com/
Views: 8984 Naresh i Technologies
Part 4   Delete duplicate rows in sql
 
03:26
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-4-delete-duplicate-rows-in-sql.html In this video, we will discuss deleting all duplicate rows except one from a sql server table. SQL Script to create Employees table Create table Employees ( ID int, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) The delete query should delete all duplicate rows except one. Here is the SQL query that does the job. PARTITION BY divides the query result set into partitions. WITH EmployeesCTE AS ( SELECT *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber FROM Employees ) DELETE FROM EmployeesCTE WHERE RowNumber ] 1
Views: 364895 kudvenkat
Session monitoring in Toad Edge
 
04:30
http://quest.com/products/toad-edge In this short video you will learn about session monitoring in Toad Edge, as well as some other features for getting feedback.
Views: 2739 Quest
WDM 46: How To build distributed indexes
 
25:06
How To build distributed indexes For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=1 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 3661 Oresoft LWC
Turn FLASHBACK DATABASE on & off while the Database stays OPEN
 
03:38
The clip demonstrates how to change FLASHBACK DATABASE without having to restart the instance. A text version is here: https://uhesse.com/2010/06/25/turning-flashback-database-on-off-with-instance-in-status-open/ The demo is done with 12c but the shown can be done with 11gR2 as well.
Part 5   SQL query to find employees hired in last n months
 
04:53
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-5-sql-query-to-find-employees.html This question is asked is many sql server interviews. If you have used DATEDIFF() sql server function then you already know the answer. -- Replace N with number of months Select * FROM Employees Where DATEDIFF(MONTH, HireDate, GETDATE()) Between 1 and N
Views: 186821 kudvenkat
How To Monitor Databases on AWS Using SolarWinds Database Performance Analyzer
 
03:24
To learn more visit: http://bit.ly/SolarWinds_DPA See how SolarWinds Database Performance Analyzer identifies SQL Server and Oracle performance issues on the AWS Cloud. Connect with SolarWinds: THWACK IT Community: http://thwack.solarwinds.com/ Facebook: https://www.facebook.com/SolarWinds Twitter: https://twitter.com/solarwinds LinkedIn: http://www.linkedin.com/company/solarwinds Instagram: http://instagram.com/solarwindsinc/ Flickr: http://www.flickr.com/photos/solarwinds_inc/ TRANSCRIPT: In this video, you will learn how SolarWinds® Database Performance Analyzer or DPA for short, can be easily deployed on Amazon® Web Services, to monitor both RDS® and EC2® database servers. In addition, you will see how to identify and resolve database performance issues having the largest impact on your applications. To deploy DPA in the cloud, simply go to the Amazon marketplace and search for SolarWinds. Click on 'Continue' to deploy the AMI. Once deployed, all the additional configurations are completed through the web browser interface. The next step will be to register your database instances to be monitored by clicking on 'Register DB Instance for Monitoring.' In this case, we have already registered an instance. Let's look at DPA to find and isolate a performance problem. A customer has just called in and complained of slowness in their order entry application. To troubleshoot, first log into DPA and review the main dashboard. This will give us a high-level overview of what is happening in our environment. It’s interesting that the order entry database (PRODOE-RDS) is showing several alarms. Let's take a closer look by drilling into that database. From the trend screen, first look to the Advice tab for any critical or warning statuses. The top 2 SQL statements which are in a critical state are especially interesting. For the first statement, the adviser is telling us that there are high amounts of blocking for this insert statement on January 20th. By drilling into that day in the trend screen, we can see a 24-hour view of the top 15 SQL statements. For our insert statement, we can quickly see that it has been running every hour with a huge spike beginning in the 9:00 am hour. By drilling into that hour, we can view the blockers tab to see who is blocking this SQL statement. Here we can see that process ID of 83 has actually been blocking many other sessions for a long time. Each of these processes have spent over half an hour trying to run this insert statement. Look at the blocker details, we can quickly identify the user and see that they were performing an update to the same table. Now we can begin work on resolving this issue. Let's look at the tuning advice for our second SQL statement in Alarm. In this case, click on the 'More' link to see all of the details about the query and then review the execution plan. Notice that the adviser is suggesting several new indexes. At this point, we can decide to create and test them to see if they help improve performance. To maximize the value that DPA delivers, 24x7 monitoring is recommended. As DPA continues to monitor and collect data, the more comprehensive the analysis becomes especially when identifying trends and anomalies over time. One surprise that many of our customers have learned, is that it's not always the best idea or cost-effective to provision large database servers in the cloud. Instead, start with a small or medium-sized installation, use DPA to monitor performance, then add more resources when you need to. Test drive DPA today, just visit www.solarwinds.com/dpa.
Views: 802 solarwindsinc
Part 12   Can we join two tables without primary foreign key relation
 
10:38
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/09/part-12-can-we-join-two-tables-without.html Can we join two tables without primary foreign key relation Yes, we can join two tables without primary foreign key relation as long as the column values involved in the join can be converted to one type. ID column in Departments table is not the primary Key and DepartmentId column in Employees table is not the foreign key. But we can still join these tables using ID column from Departments table and DepartmentId column from Employees table, as both the columns involved in the join have same data type i.e int. Select Employees.Name as EmployeeName, Departments.Name as DepartmentName from Employees join Departments on Departments.ID = Employees.DepartmentId The obious next question is, if primary foreign key relation is not mandatory for 2 tables to be joined then what is the use of these keys? Primary key enforces uniqueness of values over one or more columns. Since ID is not a primary key in Departments table, 2 or more departments may end up having same ID value, which makes it impossible to distinguish between them based on the ID column value. Foreign key enforces referential integrity. Without foreign key constraint on DepartmentId column in Employees table, it is possible to insert a row into Employees table with a value for DepartmentId column that does not exist in Departments table. The following insert statement, successfully inserts a new Employee into Employees table whose DepartmentId is 100. But we don't have a department with ID = 100 in Departments table. This means this employee row is an orphan row, and the referential integrity is lost as result Insert into Employees values (8, 'Mary', 'Female', 80000, 100) If we have had a foreign key constraint on DepartmentId column in Employees table, the following insert statement would have failed with the following error. Msg 547, Level 16, State 0, Line 1 The INSERT statement conflicted with the FOREIGN KEY constraint. The conflict occurred in database "Sample", table "dbo.Departments", column 'ID'.
Views: 125916 kudvenkat
Informatica pre and post sql
 
10:36
Pre-Post SQL properties of source qualifier transformation Pre SQL: The SQL query fires initially when loading to that database. Post SQL: The SQL query fires at the end i.e., after loading the records to the database. Pre and Post SQL to execute SQL statement like Insert, Update, Delete before and after the load. pre SQL means " SQL statement executed using the source connection,before a pipeline is run" and post SQL means " SQL statement executed using the source connection,after a pipeline is run".
Views: 17994 Informatica
How to convet physical standby into read only mode part-3
 
05:21
How to convert your physical standby database into read only mode and how to bring back into physical standby step by step. HOW TO APPLY REDO PROCESS IN ORACLE DATA GUARD 11G R2 STEP BY STEP. PART-1 USE BELOW LINK https://youtu.be/wfzEfeNvr_Q PART-2 USE BELOW LINK https://www.youtube.com/watch?v=1UsKglLEvtc PART-4 USE BELOW LINK https://www.youtube.com/watch?v=1Gf2UVXD3RY PART-5 USE BELOW LINK https://www.youtube.com/watch?v=Qkz8gj64PYo PART-6 USE BELOW LINK https://www.youtube.com/watch?v=62GrNn8e06Q
Views: 2712 OCP Technology
Part 6   Transform rows into columns in sql server
 
08:53
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/06/part-6-transform-rows-into-columns-in.html This is another common sql server interview question. We will be using Countries table in this example. SQL to create the table Create Table Countries ( Country nvarchar(50), City nvarchar(50) ) GO Insert into Countries values ('USA','New York') Insert into Countries values ('USA','Houston') Insert into Countries values ('USA','Dallas') Insert into Countries values ('India','Hyderabad') Insert into Countries values ('India','Bangalore') Insert into Countries values ('India','New Delhi') Insert into Countries values ('UK','London') Insert into Countries values ('UK','Birmingham') Insert into Countries values ('UK','Manchester') Here is the interview question. Write a sql query to transpose rows to columns. Using PIVOT operator we can very easily transform rows to columns. Select Country, City1, City2, City3 From ( Select Country, City, 'City'+ cast(row_number() over(partition by Country order by Country) as varchar(10)) ColumnSequence from Countries ) Temp pivot ( max(City) for ColumnSequence in (City1, City2, City3) ) Piv
Views: 208137 kudvenkat
How to install Kali Linux 2017.1 on oracle VM virtual Box step by step [HINDI]
 
13:15
My New Channel- https://www.youtube.com/channel/UCeYWcEKjeweogFnfD5GeAMQ/videos?disable_polymer=1 x - In this video i give you all detail that how we virtually install Kali Linux 2017.1 on our PC by using vm virtual box. u use 2 oprating system in 1 pc first we need a kali linux setup. the downloaded link is given below https://www.kali.org/downloads/ and when you want to install kali linux on your mobile then check this link /youtu.be/b9WwEiAE2a8 Clear Air - Somewhere Sunny by Kevin MacLeod is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Source: http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1100626 Artist: http://incompetech.com/
Views: 243 GAME HEx
Calculate running total in SQL Server 2012
 
06:23
running total sql server cumulative total in ms sql server running total column In this video we will discuss how to calculate running total in SQL Server 2012 and later versions. We will use the following Employees table for the examples in this video. SQL Script to create Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Gender nvarchar(10), Salary int ) Go Insert Into Employees Values (1, 'Mark', 'Male', 5000) Insert Into Employees Values (2, 'John', 'Male', 4500) Insert Into Employees Values (3, 'Pam', 'Female', 5500) Insert Into Employees Values (4, 'Sara', 'Female', 4000) Insert Into Employees Values (5, 'Todd', 'Male', 3500) Insert Into Employees Values (6, 'Mary', 'Female', 5000) Insert Into Employees Values (7, 'Ben', 'Male', 6500) Insert Into Employees Values (8, 'Jodi', 'Female', 7000) Insert Into Employees Values (9, 'Tom', 'Male', 5500) Insert Into Employees Values (10, 'Ron', 'Male', 5000) Go SQL Query to compute running total without partitions SELECT Name, Gender, Salary, SUM(Salary) OVER (ORDER BY ID) AS RunningTotal FROM Employees SQL Query to compute running total with partitions SELECT Name, Gender, Salary, SUM(Salary) OVER (PARTITION BY Gender ORDER BY ID) AS RunningTotal FROM Employees What happens if I use order by on Salary column If you have duplicate values in the Salary column, all the duplicate values will be added to the running total at once. In the example below notice that we have 5000 repeated 3 times. So 15000 (i.e 5000 + 5000 + 5000) is added to the running total at once. SELECT Name, Gender, Salary, SUM(Salary) OVER (ORDER BY Salary) AS RunningTotal FROM Employees So when computing running total, it is better to use a column that has unique data in the ORDER BY clause. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/calculate-running-total-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/calculate-running-total-in-sql-server_3.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: 60122 kudvenkat
DB2 Tips n Tricks Part 69  - How To Find Index Rebuild is Slowing Query Execution
 
06:30
How To Find Index Rebuild is Slowing Query Execution Solution: Use MON_GET_AGENT Routine along with SYSIBMADM.MON_CURRENT_SQL Happy Learning & Sharing Coincidence - 69th Video on 69th Independence Day!!!!!
Views: 1281 DB2-LUW-ACADEMY
Build a Big Data App in 30 Minutes @ DataWeek 2013
 
20:32
http://BizCloudNetwork.com http://BizCloud.net In this session, Qubole's VP of Engineering will demonstrate how to leverage tools to quickly and easily create an efficient Big Data app. From the greenest of data workers to the grizzled veterans, everyone can learn something new in this session. Learn how to: • Extract data from different sources into Hadoop • Explore, cleanse, and join datasets to extract meaningful insights • Visualize and share the insights in a collaborative environment • Create data pipelines that extract and share insights periodically • Setup alerts to monitor status of mission critical jobs Please bring a laptop and register for a free trial of Qubole Data Service before attending. This will be a fast-paced session, so be ready to rock! Shrikanth Shankar VP of Engineering, Qubole Shrikanth Shankar is the VP of Engineering at Qubole. Previously, Shrikanth worked at Oracle for over a decade, rising to become Director of Development in the BI team. Shrikanth was one of the leaders of the Oracle Exalytics effort and helped drive the product from conception to release. Prior to that, Shrikanth was on Oracle's database team in the SQL/DSS group, where he made significant contributions to many different portions of the Oracle stack, ranging from partitioning, SQL optimization, and SQL/parallel execution all the way to indexing and data layers. Media Coverage - BizCloud Media Production
Views: 4957 bizcloud
How to create indexes and search Data Vault in ILM
 
05:48
Video to walk you through the process of creating indexes and searching data vault in ILM 6.2
Views: 758 Informatica Support
HANA Administration - Table Replication
 
05:13
HANA Administration - Table Replication Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Neha Gupta, Tutorials Point India Private Limited.
Cursors in sql server   Part 63
 
13:58
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/01/cursors-in-sql-server-part-63.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-63-cursors-in-sql-server.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 Relational Database Management Systems, including sql server are very good at handling data in SETS. For example, the following "UPDATE" query, updates a set of rows that matches the condition in the "WHERE" clause at the same time. Update tblProductSales Set UnitPrice = 50 where ProductId = 101 However, if there is ever a need to process the rows, on a row-by-row basis, then cursors are your choice. Cursors are very bad for performance, and should be avoided always. Most of the time, cursors can be very easily replaced using joins. There are different types of cursors in sql server as listed below. We will talk about the differences between these cursor types in a later video session. 1. Forward-Only 2. Static 3. Keyset 4. Dynamic Let us now look at a simple example of using sql server cursor to process one row at time. We will be using tblProducts and tblProductSales tables, for this example. On my machine, there are 400,000 records in tblProducts and 600,000 records in tblProductSales tables. If you want to learn about generating huge amounts of random test data, please watch Part - 61 in sql server video tutorial. The link is below. http://www.youtube.com/user/kudvenkat/videos?flow=grid&view=1 Cursor Example: Let us say, I want to update the UNITPRICE column in tblProductSales table, based on the following criteria 1. If the ProductName = 'Product - 55', Set Unit Price to 55 2. If the ProductName = 'Product - 65', Set Unit Price to 65 3. If the ProductName is like 'Product - 100%', Set Unit Price to 1000 For the SQL code samples used in the demo please visit my blog at the following link http://csharp-video-tutorials.blogspot.com/2013/01/cursors-in-sql-server-part-63.html The cursor will loop thru each row in tblProductSales table. As there are 600,000 rows, to be processed on a row-by-row basis, it takes around 40 to 45 seconds on my machine. We can achieve this very easily using a join, and this will significantly increase the performance. We will discuss about this in our next video session. To check if the rows have been correctly updated, please use the following query. Select Name, UnitPrice from tblProducts join tblProductSales on tblProducts.Id = tblProductSales.ProductId where (Name='Product - 55' or Name='Product - 65' or Name like 'Product - 100%')
Views: 224157 kudvenkat
Global Glycogen Storage Disorders (GSD) Clinical Trials Market H2 2016
 
00:44
Report On Glycogen Storage Disorders (GSD) Global Clinical Trials Review H2 2016 provides an overview of Glycogen Storage Disorders (GSD) clinical trials scenario. This report provides top line data relating to the clinical trials on Glycogen Storage Disorders (GSD). Report includes an overview of trial numbers and their average enrollment in top countries conducted across the globe. The report offers coverage of disease clinical trials by region, country (G7 & E7), phase, trial status, end points status and sponsor type. Report also provides prominent drugs for in-progress trials (based on number of ongoing trials). Clinical Trial Reports are generated using proprietary database - Pharma eTrack Clinical trials database.
Views: 33 Rahul Chanda
[High Pass Guarantee] 2017 Latest Oracle 1Z0-062 Dumps Questions And Answers Free Try
 
01:01
http://www.passitexams.com/1z0-062.html The best and most updated Oracle 1Z0-062 dumps exam training materials in PDF format, download one of the many PDF readers that are available for free. Exams: QUESTION 1 You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data? A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data. B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group. C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data. D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data. E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group. F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data. Correct Answer: ACF QUESTION 2 In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? Both local and global partitioned B-tree Indexes are defined on the table. A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends. Minimal disrupt ion to availability is required. Which three statements are true about this requirement? A. The partitions can be moved online to new tablespaces. B. Global indexes must be rebuilt manually after moving the partitions. C. The partitions can be compressed in the same tablespaces. D. The partitions can be compressed in the new tablespaces. E. Local indexes must be rebuilt manually after moving the partitions. Correct Answer: ACD Red more: https://youtu.be/aLx6RnhvXTU
Views: 43 exam dumps
SAP BIBW ECC Extraction training class
 
01:23:01
http://www.ibmitsolutions.com/sap-bwbi-online-training/ Course: SAP BI 7.0/BW 7.3, ABAP Duration: 50 hours Highlights of our training:  Real time Industry Experienced Trainer.  Interactive Training session using web conferencing tool  Normal track, weekend and fast track classes according to convenience  Student will be provided session recording capability to record each session  We provide Training Material, Exercises and Real Time Examples  Resume preparation and Certification Guidance  We will provide class and demo sessions at student flexible timings.  In training case studies and real time scenarios covered. Introduction to SAP Business Intelligence  SAP Net weaver BI Architecture / BI Platform  Star Schema and Extended Star Schema  Multidimensional modeling  Entity Relationship Modeling  Enterprise Data Modeling  Enterprise Reporting, Query and Analysis  SAP BW vs Other Data warehousing Tools  Data Acquisition / Data Extraction concepts SAP BW Phases  Modeling  Extraction  Reporting Modeling  Info Area ,Info Object Catalogs  Info Objects(Characteristics & Key Figures)  Application Component  Data Source  Transfer Rules  Info Source  Update Rules  Different types of Routines  Info Package  Transformations  Data Transfer Process(DTP)  Error DTP  Metadata Repository BI 7.0 Info Providers  Master Data – Attributes, Texts, Hierarchies  Standard DSO  Write-optimized DSO  Direct Update DSO  Standard Info Cube  Virtual Providers  InfoSet  MultiProvider  Aggregation Level  Others  Open Hub Destination  Analysis Process designer BW 7.3 Info Providers  SAP NetWeaver BW 7.3 Features Overview  Graphical Data Modeling  Graphical Data Flow Modeling Basics  Data Flow Copying  Data Flow Generation  Data Flow Migration  Advanced InfoProviders  Semantically Partitioned Object (SPO)  Hybrid InfoProviders  Transient Providers  The New BW 7.3 Hierarchy ETL Business Content  Importance of Business Content  Business Content Installation & Activation  Business Content Data Source, DSO’s, Cubes, Reports, etc… Data Acquisition / Data Extraction  Flat file Extraction  Business Content Extractions using MD/TD SD,MM and FI  Logistics Extraction  Generic Data Extraction using MD/TD Tables  Delta mechanism  CO-PA Extraction  FI-SL Extraction  Data source Enhancement Process Chains  Process Chains, Process Types  Scheduling  Monitor (Header, Status, Details)  Real time scenarios from support projects Transport Mechanism  Review of system Landscape  Collecting Objects  Creating Transports  Releasing Transport  Importing and Monitoring Transport Reporting  Introduction of Various Reporting Tools Functional Overview of Business Explorer Query Designer  Introduction of BEx Query  Reusable Query Elements  Filters, Columns & Rows  Characteristic Restrictions & Free Characteristics  Formulas & Calculated Key Figures  Restricted Keyfigures and Variables with Texts  Report to Report Interface or Jump Starts  Query Extracts using RSCRM_BAPI  Exceptions, Conditions, Structures, Cell Definitions and others Business Explorer Analyzer  Introduction to BEx Analyzer  Filtering Option  Properties available in Analyzer Performance Improvement  Aggregates  Compression  Re-Modeling  Re- Partitioning  Indexes and DB Statistics  Number Range Buffering  Read Mode & OLAP cache  Line Item Dimension & High Cardinality  Read Mode & OLAP cache  Business Warehouse Accelerator  Others Types of Projects  Real Time Implementation Projects  Up-Gradation project  Enhancements to the existing Implementation project  Support projects Introduction to SAP ABAP  What is SAP  SAP Architecture and where ABAP fits in  ABAP Development Workbench Tools  Object Navigator  Workbench Organizer  Data Dictionary ABAP Dictionary  Tables  Views  Lock Objects ABAP Programming Techniques  Reports Statement  Line Size  Line-count  Message  Page Heading  Report Comment Section  Declarations  Tables  Includes  Variables (Data Types and Data Objects)  Structures  Internal Table  Constants ABAP for SAP BI Consultant:  Field level Routine  Start Routine  End Routine  Expert Routine  Infopackage level Routine  DataSource Enhancements Thanks !!!!!!
Salesforce Integration Tutorial for beginners:How to provision Postgres & Heroku connect for our app
 
01:47
Salesforce Integration Tutorial for beginners:How to provision Postgres & Heroku connect for our app? Get the complete course: https://courses.mytutorialrack.com/p/salesforce-heroku-integration Checkout my website: http://mytutorialrack.com/ connect me on facebook: https://www.facebook.com/tutorialRack/ Follow me on twitter: https://twitter.com/mytutorialrack postgres heroku pricing postgres heroku tutorial postgres heroku rails postgres heroku python postgres heroku node postgres heroku plans postgres heroku addon postgres heroku connect postgres heroku follower postgres heroku app postgres heroku heroku postgres admin heroku postgres access heroku postgres alternative heroku postgres api heroku postgres automatic backup heroku postgres amazon heroku postgres alter table heroku postgres add column heroku postgres backup heroku postgres blog heroku postgres basic heroku postgres backup restore heroku postgres billing heroku postgres backup to s3 heroku postgres benchmark heroku postgres backup local heroku postgres bronze heroku postgres buildpack heroku postgres create table heroku postgres connection limit heroku postgres crane heroku postgres create user heroku postgres connection refused heroku postgres copy heroku postgres change password heroku postgres clear database heroku postgres cost postgres console heroku postgresql heroku doc heroku postgres dump heroku postgres database yml heroku postgres database heroku postgres django heroku postgres downtime heroku postgres drop database heroku postgres dataclip heroku postgres dev heroku postgres dev plan postgresql heroku example postgresql heroku export heroku postgres encryption heroku postgres extensions heroku postgres encoding heroku postgres external access heroku postgres environment variables heroku postgres europe heroku postgres expensive heroku postgres error postgres heroku free postgresql heroku flask heroku postgres free plan heroku postgres full text search heroku postgres failover heroku postgres fork heroku postgres functions heroku postgresql free heroku postgres follower postgres heroku gem heroku postgres gui heroku postgres geospatial heroku postgres gis heroku postgres getting started heroku postgres gemfile heroku postgres grails heroku postgresql gui heroku get postgres url heroku get postgres dump postgres heroku hstore postgres heroku help postgresql heroku hosting heroku postgres high availability heroku postgres hobby basic heroku postgres hosting heroku postgres homebrew heroku postgresql hstore heroku postgres pg hba conf postgres heroku install heroku postgres import heroku postgres import csv heroku postgres import sql postgres in heroku heroku postgres index heroku postgres ios heroku postgres iops heroku postgres interface heroku postgresql idle in transaction postgres heroku java heroku postgres json heroku postgres jdbc heroku postgres jpa heroku postgresql jdbc heroku postgres node js heroku jruby postgres heroku postgres kill connections heroku postgres kappa heroku postgres logs heroku postgres local heroku postgres limit heroku postgres load data heroku postgres list tables heroku postgres latency heroku postgres log level heroku postgres row limit connect to heroku postgres locally postgresql heroku monitor heroku postgres mac heroku postgres migrate heroku postgres multiple databases heroku postgres management heroku postgres max connections heroku postgres mysql heroku postgres monitoring heroku postgres maintenance heroku postgres master slave heroku postgres no pg_hba.conf entry for host heroku postgres number of connections heroku postgres navicat heroku postgres database name postgresql heroku osx postgres on heroku heroku postgres read only user using postgres on heroku heroku postgres out of memory heroku postgres add on heroku postgres read only postgresql heroku python heroku postgres pgadmin heroku postgres postgis heroku postgres php heroku postgres play heroku postgres partitioning heroku postgres pg_dump heroku postgres query heroku postgresql query heroku postgres slow query log heroku postgres slow queries postgres heroku ruby postgresql heroku remote heroku postgres restore heroku postgres replication heroku postgres rollback heroku postgres restart heroku postgres run sql heroku postgres restore backup postgres heroku setup postgres heroku security heroku postgres ssl heroku postgres status
Views: 4249 MyTutorialRack
Migration of BPC from Microsoft to NetWeaver!
 
33:13
Demo shows how to automatically migrate SAP BPC, version for the Microsoft platform to version to SAP NetWeaver using tools and environments available via TruQloud, TruQua's cloud-based platforms to accelerate migrations. The demo itself has been around for years showing a 7.x based migration but is still relevant and updated for 10.0 and 10.1 versions of SAP BPC for both HANA and non-HANA deployment scenarios.
Views: 1499 TruQua Enterprises
InnoDB (XtraDB) Tablespace growth - An Internal View
 
12:04
What happens when you keep a transaction open in MySQL while other sessions modify data. The tablespace is forced to grow until the hanging transaction is committed(8:40), at that point the 'old' record views can be discarded and all allocated space marked as deleted and can be reused. The tablespace file is not shrinked (unless you use innodb_file_per_table and do an OPTIMIZE TABLE, 11:30). The graphical view is done with Jeremy Cole's InnoDB Ruby tools (Thanks!)
Views: 356 ThatCaligula
part 12  mlog$ dmltype$$
 
03:29
mlog$, dmltype$$, materialized view, data warehosuing, materialized view log
Views: 1024 Dr. Girija Narasimhan
#19 SAP ASE 16 Learning-Advanced Backup Techniques
 
26:37
SAP ASE 16 Learning Part 19 Advanced Backup Techniques. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. Session 19 Advanced Backup Techniques Ram N Sangwan Threshold - Stored procedure sp_thresholdaction Sybase does not provide this procedure. You can add thresholds and create threshold procedures for any segment in a database. sp_thresholdaction should contain a dump transaction command to truncate the transaction log. Threshold - Stored procedure sp_thresholdaction Call to the Procedure Waking suspended processes Loading a transaction log to a point in time Loading a transaction log to a point in time After you load a transaction log using until_time, Adaptive Server restarts the database’s log sequence. This means that until you dump the database again, you cannot load subsequent transaction logs after the load transaction using until_time. You must dump the database before you can dump another transaction log. Bringing the databases online After you have applied all transaction log dumps to a database, use online database to make it available for use. For example, to bring the mydb database online, enter: online database mydb Upgrading a dump to the current version The database offline status bit If a cache does not exist, Adaptive Server writes a warning to the error log, and the binding in sysattributes is marked as invalid. Cache bindings and loading databases Databases and cache bindings There are two procedures for recreating the master database: replacement of the master device, and forcing SAP ASE to re-create the configuration area. Replace the master device when the master database is corrupted. If the master device’s configuration area is also corrupt, force SAP ASE to re-create the configuration area. You can often detect corruption in the configuration area because the server does not run, and produces error messages stating the area is corrupt. Replacing the Master Device Rebuilding the Configuration Area If the configuration area is corrupt, you must use the dataserver -f option to force SAP ASE to reconstruct the configuration area. Prerequisites The following restrictions apply: Any allocation units on the disk that appear corrupt, or that are not currently allocated, are allocated to the master database. The -w master option, with or without -f, re-creates only the master database. All other allocation units on the disk remain unchanged, so you may be able to recover the data using disk refit. Rebuilding the Configuration Area If the entire master device is corrupt (for example, in the case of a disk failure), replace the entire device by starting SAP ASE using the dataserver -zpage_size. . .-bdevice_size: Task If the existing master device is not on a raw partition and you plan to reuse it, remove the old master device file. The disk refit Rebuilds the master database’s sysusages and sysdatabases system tables from information contained in sysdevices. Adaptive Server automatically shuts down after disk refit rebuilds the system tables. Use disk refit after disk reinit as part of the procedure to restore the master database.  disk refit Thank You
Views: 1401 TheSkillPedia
SQL Developer Data Pump Import - Video 2 of 3
 
03:25
In this demonstration, you learn how to use the data pump import wizard in SQL Developer Release 3.1. This series has 3 videos. See SQL Developer Data Pump Overview and SQL Developer Data Pump Export. Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Database Lesson #6 of 8 - Database Administration
 
01:37:03
Dr. Soper gives a lecture on database administration. Topics covered include concurrent access / concurrency control, database security, database backup and recovery strategies, database locking (including optimistic locking, pessimistic locking, and deadlock), and database transactions.
Views: 97155 Dr. Daniel Soper
Sql Server Interview Questions and Answers Part 6(Case Statement Part 1 )
 
07:47
Case Statement Related Complex Questions and answers
Views: 1500 SS UNITECH
How to install Java or JDK on Window 10 PC or Laptop -  64 bit [HD]
 
11:25
Thanks For Watching! Subscribe & Share ! Tutorial : Learn how you can install Java on Window 10 64 bit PC or Laptop. Note : Java Installation On Window 10 -download latest java. Note : Uninstall older software or lower version software of java, remove entries from registry, delete the old remaining java folders, shutdown and restart for fresh installation. Download free Java software : http://www.oracle.com/technetwork/java/javase/downloads/index.html Java Platform Standard Addition : Java SE 8u77 - jdk download Subscribe Us for More Video Tutorials : https://www.youtube.com/channel/UCCh84y_PX-bpYNuZNwLD-vg You can also follow me on Facebook : https://www.facebook.com/profile.php?id=100009883360069 Java Terms: installer java windows 7,java for windows 10 64 bit, installing java on windows,java environment 1.5 0 download chip download java xp,64 bit java version,Searches related to install java with java_home,Searches related to Install Java on windows install java on windows 10 64 bit,unable to install java on windows 10,cannot install java on windows 10,how to reinstall java on windows 10,jre java in order to download,download java for windows 10,java download for windows 10, java update installing java on windows,Searches related to install java with java_home,JRE Installation for Microsoft Windows,Update Java run time settings on Windows,How to Install Java Run time Environment on Windows 10,problems installing java on windows 10, Installing Java 7 in Windows 10, java offline installer for windows 10, How to install JDK 7 on Windows 10, How to install Java on Windows 10, Windows 10, How to download Java for windows 10,How to install java environment on Windows 10 Windows 10 and Java problem, JRE Installation for Microsoft Windows (64-bit)
Views: 921 BestVideoSeries
How to Create Login Page that Redirects Based on User Role
 
13:31
https://www.caspio.com | Learn how to create a login page that redirects users based on their user role. In this video, we'll show you how to create single a login page for a multi-user web application. The login page automatically redirects users based on 3 user roles: administrator, manager and employee. Learn how to create a database web application without coding. Caspio empowers anyone to quickly create online databases, web applications, and web forms, all without writing a single line of code! Using intuitive app-building wizards, now you can simply "point-and-click" your way to creating powerful online database apps that deploy seamlessly to your own website, intranet, CMS or blog. Get a free 14-day trial at https://www.caspio.com/get-started
Views: 192182 CaspioInc
C_HANASUP_1 – Certified Test Support Associate Exam – HANA Questions
 
01:04
For SAP C_HANASUP_1 Test Questions and Answers Please Visit: https://www.passeasily.com/C_HANASUP_1.htm Exam Section 1 - Performance Questions (Test Coverage 17%) Exam Section 2 - Backup and Test Recovery Questions (Test Coverage 14%) Exam Section 3 – System Test Reports Questions (Test Coverage 12%) Exam Section 4 - Trace Questions (Test Coverage 12%) Exam Section 5 - Authorizations Questions (Test Coverage 10%) Exam Section 6 - Monitoring Questions (Test Coverage 9%) Exam Section 7 - Operations Questions (Test Coverage 8%) Exam Section 8 - Configurations Questions (Test Coverage 8%) Exam Section 9 - High Test Availability Questions (Test Coverage 6%) Exam Section 10 - Installation Questions (Test Coverage 4%) (Exam Time) : 180 minutes (Number of Test Questions): 80 (C_HANASUP_1 Passing Score): 60% In the C_HANASUP_1 Exam, you will encounter the following: • Identify how performance of C_HANASUP_1 SAP HANA can be influenced and process various methods to analyze test performance (e.g. SQL statement analysis, root cause questions analysis with SAP Solution Manager) • Perform relevant backup and recovery tasks, such as executing manual exam backup, configuring scheduled backups, restoring databases, or monitoring questions backups. • Use system reports to illustrate performance and various exam parameters of C_HANASUP_1 SAP HANA such as database configuration, conections, memory consumption, etc.. • Differentiate, prepare and apply various tracing exam options and interpret the test results (e.g. configure the C_HANASUP_1 SQL and Kernel profiler trace, navigate questions and trace files). • Describe the authorization concept of the C_HANASUP_1 SAP HANA and implement a security model to support a database user. Perform basic test security and authorization troubleshooting. • Describe the monitoring concept for SAP HANA and use the available exam options for monitoring questions. • Perform operational test tasks for SAP HANA (e.g. indexing and partitioning). • Explain and set the required exam configurations and parameters for SAP HANA. • Ensure high availaibility of C_HANASUP_1 SAP HANA (e.g. configure exam host as backup and monitor questions status) • Apply the SAP HANA Installation Test guide
Views: 479 PassEasilyCert
Deep dive on SQL Server and big data - BRK4021
 
01:16:30
Many customers have investments in data lakes with big data storage and infrastructure. Come explore a deep dive behind the technology for big data integration with SQL Server including Polybase futures and scalable performance.
Views: 2825 Microsoft Ignite
C_TADM54_731 – System Exam Administration Test (Sybase ASE) NetWeaver 7.31 Questions
 
01:30
For SAP C_TADM54_731 Test Questions and Answers Please Visit: https://www.PassEasily.com/C_TADM54_731.htm Exam Section 1 – SAP System concepts Questions (Test Coverage 11%) Exam Section 2 – User Administration (AS ABAP and/or AS Java) Questions (Test Coverage 12%) Exam Section 3 – Transport test Management Questions (Test Coverage 13%) Exam Section 4 – Database Administration Questions (Test Coverage 17%) Exam Section 5 – System Monitoring test (AS ABAP and/or AS Java) Questions (Test Coverage 17%) Exam Section 6 – System Administration (AS ABAP and/or AS Java) Questions (Test Coverage 14%) Exam Section 7 – Installation (AS ABAP test and AS Java) Questions (Test Coverage 16%) (Exam Time): 180 minutes (Number of Test Questions): 80 (C_TADM54_731 Passing Score): 61% SAP Education test has worked hard together with the Certification & Enablement C_TADM54_731 Influence exam Council to enhance the value of certification and improve the tests. An increasing number of exam customers and partners are now looking towards certification as a reliable benchmark to safeguard their investments. Unfortunately, the increased demand for certification has brought with it a growing number of people who to try and attain SAP certification test through unfair means. This ongoing issue has prompted SAP C_TADM54_731 Education to place a new focus on test security. Please take a look at our SCN blog to understand what you can do to help to protect the credibility of your certification status. This exam certification path will validate your capability as a well-trained test technologist prepared to help your client or employer manage and execute key business test processes. Armed with an understanding of SAP exam system administration, you can implement this test knowledge for your projects as a technology consultant. To ensure success, SAP exam recommends combining education courses and hands-on experience to prepare for your certification exam as questions will test your ability to apply the knowledge you have gained in test training. Besides the recommended exam education courses also practical C_TADM54_731 experience is required and tested. You will be tested for: • Describe the architecture of an SAP test system that uses an IBM DB2 questions for LUW database test, list the components of a DB2 exam instance and a DB2 e database and the database tools. Define and set up techniques for IBM DB2 for LUW database exam administration. • Explain and provide exam information about SAP test products questions and technologies questions. • Explain user test and authorization concepts and determine how to connect SAP questions systems to a Directory Server questions, describe how to connect SAP test systems using LDAP exam, and configure test CUA. • Explain the methodology questions, concepts test, and tools in SAP exam software logistics. • Determine how to configure and administer an SAP exam NW Application test Server (AS ABAP and AS Java questions) and configure batch processing, RFC test, ITS exam, printers test, and SMTP exam. Manage spools and schedule background jobs • Set up system monitoring and operate performance system monitoring (AS questions, ABAP questions, and AS test Java).
Views: 723 PassEasilyReloaded
How to Manage Tags in ILM Data Archive 6 2
 
07:37
This video describes how to: - Add, Update and Delete Tags. - Browse Data using Tags - Apply Retention based on Tags
Views: 262 Informatica Support
Un Mine custom metadata from ILM EDM
 
08:30
This video descrives how to un-mine custom metadata from EDM
Views: 187 Informatica Support
250-310 - Administration of Symantec Exam Vault Test 10.0 Questions
 
00:46
For Symantec 250-310 Test Questions and Answers Please Visit: https://www.PassEasily.com/250-310.htm Exam Section 1 - Overview, Architecture, and Test Planning Questions (Test Coverage 25%) Exam Section 2 - Installation and Test Configuration Questions (Test Coverage 20%) Exam Section 3 - Administration Questions (Test Coverage 25%) Exam Section 4 - Monitoring, Reporting, and Troubleshooting Questions (Test Coverage 30%) (Exam Time): 105 minutes (Number of Test Questions): 60-70 (250-310 Passing Score): 60% You will be tested for: Administration • Given a scenario, describe the test procedure for managing 250-310 Symantec Enterprise Vault 10 for Exchange Vault Site components, including, but not limited to, targets, archives, and Vault Storage groups with Enterprise Vault Administration Console (VAC), Enterprise Vault Management shell, and Enterprise Vault Policy Manager (EVPM). • Given a scenario and questions, identify and describe how to apply appropriate retention categories. • Given a scenario and questions, describe the Exchange archiving process including, but not limited to, provisioning groups, enabling/disabling mailboxes, and archiving tasks. • Explain the maintenance process for indexes and SQL databases. • Distinguish between 250-310 Symantec Enterprise Vault 10 for Exchange roles-based administration role exam types. • Given a scenario, describe the test process for managing Symantec Enterprise Vault 10 for Exchange Policies with Enterprise Vault Administration Console (VAC). • Describe the process for importing and exporting, including PST migration and move archive test options. • Given a scenario and questions, identify the appropriate Symantec Enterprise Vault 10 for Exchange client functionality (Outlook Add-Ins, Outlook Web Access/App Extensions, Vault Cache, and Virtual Vault). • Describe the exam creation and maintenance of vault storage in 250-310 Symantec Enterprise Vault 10 for Exchange with Enterprise Vault Administration Console (VAC) or Enterprise Vault Management Shell. Monitoring, Reporting, and Troubleshooting • Given a scenario, identify Symantec Enterprise Vault for Exchange exam options for monitoring archive status. • Distinguish between Symantec Enterprise Vault 10 for Exchange audit logging test options and interpret Symantec Enterprise Vault 10 for Exchange audit logging output. • Given a scenario and questions, verify 250-310 Symantec Enterprise Vault 10 for Exchange is installed and functioning (e.g., running exam services, archiving). • Given a scenario and questions, interpret the output from Symantec Enterprise Vault 10 for Exchange Reporting exam Services. • Describe the test steps required to troubleshoot 250-310 Symantec Enterprise Vault 10 for Exchange server and client issues including, but not limited to, Outlook Web Access/App.