Home
Search results “Oracle partition offline”
How to Move Object from one Table Space to Another Table Space? | How to Rebuild the Index ?
 
05:03
This Video will teach you How to Move Object one Table Space to Another | How to Rebuild the Index ? move table from one tablespace to another in oracle 11g oracle move schema to another tablespace oracle how to move objects to another tablespace oracle 11g move schema to another tablespace alter table move tablespace oracle 8i oracle move table script oracle move cluster to new tablespace oracle move table example rebuild index oracle script alter index rebuild online parallel oracle rebuild all indexes oracle index rebuild online vs offline oracle rebuild partitioned index index rebuild oracle best practice index rebuild script in oracle 11g
Views: 1080 Oracle PL/SQL World
Compression Options for Oracle Database
 
36:49
Held on August 9 2018 This session by Gregg Christman focuses on general questions and insights regarding Oracle Basic Compression, Oracle OLTP Table Compression and Oracle Advanced Row Compression. Here is a quick guide to the highlights: 2:25 Basic vs. Advanced Row Compression comparison 4:55 Should you expect the same compression ratio with Basic and Advanced Row Compression? 8:29 Should you compress all tables and partitions? 15:50 What is the overhead associated with Advanced Row Compression? 17:06 Do I need to change my application to use compression? 17:31 Who uses Advanced Row Compression? 18:35 Is there any ongoing administration with Advanced Row Compression 20:43 When does updated data get compressed? 26:30 What role does PCTFREE play in updates and compression? 28:44 Does Advanced Row Compression work with Oracle Encryption? 29:34 Does enabling compression online or offline make a difference? 31:38 What are the typical compression ratios with Basic and Advanced Row Compression? 32:56 Are there any suggested MOS notes related to compression? 34:12 Feedback about ACO from customers AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 520 Oracle Developers
Oracle Database 18c Express Edition Installation on Windows 10 | Oracle Database 18c XE
 
16:14
After long time, Oracle has released finally Oracle Database 18c Express Edition for Windows x64, Oracle Database Express Edition (XE) Release 18.4.0.0.0 In this video we are going to demonstrate how to install Oracle Database 18c Express Edition on Windows 10 Oracle Database 18c Express Edition installation in Windows is very easy. This video guides step by step installation. We are going to learn 1. Database Installation 2. Enterprise Manager Overview 3. SQL Plus tool 4. Oracle Instance Manager to start and shutdown database instance. Hardware Requirements : Minimum 2 GB RAM, 2 CPU Cores and Enough Hard disk Space. Software Requirements : OracleXE184_Win64 Zip file for Windows already downloaded from Oracle website. Important Note: Adobe Flash player must be installed in order to browse Enterpise Manager Console on Internet Explorer. Installation method : Offline, Oracle Database 18c Zip file for Windows downloaded and installed. download link: https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index-083047.html Oracle Database 18c XE Features ############################### Oracle Multitenant SQLJ Microsoft Distributed Transaction Coordinator support Native .NET Data Provider—ODP.NET .NET Stored Procedures Online index rebuild Online table organization Online table redefinition Trial recovery Fast-start fault recovery Flashback Table Flashback Database Cross-platform Backup and Recovery Sharded Queues Network Compression Client Side Query Cache Query Results Cache PL/SQL Function Result Cache Adaptive Execution Plans In-Memory Column Store In-Memory Aggregation Attribute Clustering Column-Level Encryption Tablespace Encryption Oracle Advanced Security Oracle Database Vault Oracle Label Security Centrally Managed Users Fine-grained auditing Privilege Analysis Real Application Security Redaction Transparent Sensitive Data Protection Virtual Private Database Oracle Spatial and Graph Property Graph and RDF Graph Technologies (RDF/OWL) Partitioned spatial indexes Oracle Partitioning Oracle Advanced Analytics Oracle Advanced Compression Advanced Index Compression Prefix Compression (also called Key Compression) Basic Table Compression Deferred Segment Creation Bitmapped index, bitmapped join index, and bitmap plan conversions Transportable tablespaces, including cross-platform and full transportable export and import Summary management—Materialized View Query Rewrite.
Views: 2065 java frm
The concept of data Migration / Oracle
 
20:27
فكر بطريقة مبدعة و منظمه لحل الامور The concept of data Migration for customized applications Learn SQL loader Learn Column mapping Learn how to think as a database programmer Visit my website for oracle courses Maxvlearn.com
Views: 2579 khaled alkhudari
Loading Data from File Sources Using Data Sync
 
03:28
Load data from an on-premises file source and define a load strategy using Oracle BI Cloud Service Data Sync. To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2015 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.
Oracle Database 18c Express Edition Installation on CentOS 7.5 | Oracle Database 18c XE Released
 
31:25
In this video we are going to demonstrate how to install Oracle Database 18c Express Edition in CentOS 7.5. Oracle Database 18c Express Edition installation in CentOS 7 Platform is very easy. This video guides step by step installation of oracle 18c includes kernel parameters configuration, dependencies installation, oracle database installation, oracle listener configuration after installation and finally access oracle enterprise manager 18c in browser. Hardware Requirements : Minimum 2 GB RAM, 2 CPU Cores and Enough Hard disk Space. Software Requirements : CentOS 7 with dependencies for oracle database 18c installed and Kernel Parameters configured. Important Note: To avoid Port already in use error I will be configuring hostname at the end of installation. Installation method : Offline, Oracle Database 18c XE RPM file for linux downloaded and installed. Oracle Database 18c XE Features ############################### Oracle Multitenant SQLJ Microsoft Distributed Transaction Coordinator support Native .NET Data Provider—ODP.NET .NET Stored Procedures Online index rebuild Online table organization Online table redefinition Trial recovery Fast-start fault recovery Flashback Table Flashback Database Cross-platform Backup and Recovery Sharded Queues Network Compression Client Side Query Cache Query Results Cache PL/SQL Function Result Cache Adaptive Execution Plans In-Memory Column Store In-Memory Aggregation Attribute Clustering Column-Level Encryption Tablespace Encryption Oracle Advanced Security Oracle Database Vault Oracle Label Security Centrally Managed Users Fine-grained auditing Privilege Analysis Real Application Security Redaction Transparent Sensitive Data Protection Virtual Private Database Oracle Spatial and Graph Property Graph and RDF Graph Technologies (RDF/OWL) Partitioned spatial indexes Oracle Partitioning Oracle Advanced Analytics Oracle Advanced Compression Advanced Index Compression Prefix Compression (also called Key Compression) Basic Table Compression Deferred Segment Creation Bitmapped index, bitmapped join index, and bitmap plan conversions Transportable tablespaces, including cross-platform and full transportable export and import Summary management—Materialized View Query Rewrite
Views: 1553 java frm
How to Move a Datafile in Oracle Database - Part 1
 
01:32
Dozens of free Oracle tutorials at http://skillbuilders.com/free-oracle-tutorials. See Part 2 (the demonstration) of this tutorial at http://skillbuilders.com/How-to-Move-Datafiles-Oracle-12c. How do you move a datafile in an Oracle Database? Well, it just got a lot easier in 12c! Watch this free video tutorial - OCM John Watson of SkillBuilders will demonstrate both techniques, 11g and 12c. There are many reasons to move a datafile in an Oracle database. Here are just a few: Renaming datafiles to a standard Moving from one file system to another Converting from file system storage to ASM Changing from SAN to NFS storage In 11g, we need to take the tablespace offline, meaning downtime. Argh! In 12c, all that is required is ALTER DATABASE MOVE DATAFILE; this is an online operation with zero downtime. Even "critical" files such as the files associated with the SYSTEM tablespace can be moved online. Consider the ease of migrating to ASM this provides! This also functions in an Active Data Guard standby environment. And, there are syntax options that allow you to keep or delete the original file. Very cool stuff.
Views: 2594 SkillBuilders
Developing Mobile Apps with Oracle Autonomous Visual Builder Cloud Service
 
09:38
A demonstration of the process for developing and publishing an on-device mobile application with Oracle Visual Builder Cloud Service
tablespaces
 
12:45
tablespace is made of one more datafiles. advantage of tablespace is managibility,will be easy .to make entire database offline .we can make a tablespace offline
Views: 599 oramandba
Oracle Solaris IPMP
 
27:19
Oracle Solaris IPMPoracle-solaris Solaris IPMP or Solaris IP Network MultiPathing, as the name suggests, is used to get seamless access to the server via network protocols. NIC bonding is one of the common features in probably every known operating system on earth. Solaris IPMP is Oracle’s (Formerly Sun Microsystem’s) version of NIC bonding. In this tutorial, I am going to show how to configure IPMP or IP Network MultiPathing on both Active-Active and Active-Passive modes. Before we jump into that, let me give a brief overview about these modes. Active-Active Mode – In this, all the Ethernet interfaces will be in active mode, that is, network packets will be distributed among all the NICs in that particular group. Active-Passive Mode – In this type of mode, when one NIC goes down, IPMP immediately brings up one of the other NICs and that will start serving the incoming and outgoing network packets. Requirements Following is the configuration for this setup. SPARC S7-2. 254 GB RAM. 5 Ethernet Interfaces (net0, net1, net2, net3 & net4). 4 Disks, each of around 500 GB. IP Address: 192.168.237.132 Active-Active Mode: Howto Login to the server as root user and execute the following command to check the interfaces status. dladm show-phys As it can be seen, all the NICs are up and running. ipmp From the above output, I have selected “net0” and “net1” Ethernet interfaces and create my very first IPMP group. ipadm add-ipmp -i net0 -i net1 ipmp0 “ipmp0” is my IPMP group name. “add-ipmp” is the attribute given to add interfaces to this group. Once they become part of the group, we can check the status of the group using the command given below. ipmpstat -g ipmp Under the “State” column, the status shows “OK” while the “Interfaces” column shows the two NICs that were added. Now that our group setup is complete, we assign an IP address to this bond using the following command. ipadm create-addr -T static -a 192.168.237.132 ipmp0/bond0 # “bond0” is just a nomenclature for identification and can be any alphanumeric combination Once the IP address is added, we can check its status using the following command. ipadm show-addr This will give the following output. As we can see, the interface shows as “ipmp0/bond0” with the assigned IP address. ipmp ipmp In order to test our setup, we can have a continuous ping running on a duplicate session while bringing down one of the two interfaces with the following command. if_mpadm -d net1 This command will detach the said interface from the IPMP group whose status can be checked using the following command. ipmpstat -g ipmpstat -i ipmp Note that “net1” is offline but the server is still accessible. This is because IPMP started distributing traffic only on the other interface which is “net0“. Active-Passive Mode: Howto While the entire setup is exactly the same, the only change is that, before we add NIC interfaces in our multipath group, we execute the following command which will tell the group that this particular interface will be offline until the active interface goes down for some unexpected or deliberate factor(s). ipadm set-ifprop -p standby=on -m ip net1 From here on, we add all the NICs including “net1” in the group and the rest of the commands will be repeated as-is, shown in the above steps and check the status of the bond. ipmp To test this setup mode, I will bring down Ethernet interface “net0” while running a continuous ping in a duplicate session and note the output. if_mpadm -d net0 ipmp As it can be seen, net0 went offline while net1 came online. Ping output was seamless and there was no packet loss detected. For a complete video, visit Nix Fury channel on YouTube.
Views: 225 Cocktail Book
Remote Data Migration from Oracle to SQL Server
 
02:30
A global financial software provider needed to migrate their billing solution from Oracle to SQL Server for one of their strategic clients located at the other end of the world. Our remote team performed the automated migration with as little downtime as possible. Learn more from our blog post: https://www.dbbest.com/blog/oracle-sql-server-migration-using-ssis/
PRM 3.1 For Oracle ASM Extract Datafile From Damaged ASM Disk group
 
05:40
PRM 3.1 For Oracle ASM Extract Datafile From Damaged ASM Disk group
Oracle Database 18c Express Edition Installation on Oracle Linux 7.5 | Oracle Database 18c XE
 
33:44
In this video we are going to demonstrate how to install Oracle Database 18c Express Edition in Oracle Linux 7.5. Oracle Database 18c Express Edition installation in Oracle Linux 7 Platform is very easy. This video guides step by step installation of oracle database XE 18c includes dependencies installation, oracle database installation, oracle listener configuration after installation and finally access oracle enterprise manager 18c in browser and start/shutdown instances. Hardware Requirements : Minimum 2 GB RAM, 2 CPU Cores and Enough Hard disk Space. Software Requirements : Oracle Enterprise Linux 7 with dependencies for oracle database 18c installed and Kernel Parameters configured. Important Note: To avoid Port already in use error I will be configuring hostname at the end of installation. Installation method : Offline, Oracle Database 18c XE RPM file for linux downloaded and installed. Oracle Database 18c Express Edition is free to use with some Limitations (Only 2 CPU Cores, 2GB RAM will be utilized and 12 GB User Data). Oracle Database 18c XE Features ############################### Oracle Multitenant SQLJ Microsoft Distributed Transaction Coordinator support Native .NET Data Provider—ODP.NET .NET Stored Procedures Online index rebuild Online table organization Online table redefinition Trial recovery Fast-start fault recovery Flashback Table Flashback Database Cross-platform Backup and Recovery Sharded Queues Network Compression Client Side Query Cache Query Results Cache PL/SQL Function Result Cache Adaptive Execution Plans In-Memory Column Store In-Memory Aggregation Attribute Clustering Column-Level Encryption Tablespace Encryption Oracle Advanced Security Oracle Database Vault Oracle Label Security Centrally Managed Users Fine-grained auditing Privilege Analysis Real Application Security Redaction Transparent Sensitive Data Protection Virtual Private Database Oracle Spatial and Graph Property Graph and RDF Graph Technologies (RDF/OWL) Partitioned spatial indexes Oracle Partitioning Oracle Advanced Analytics Oracle Advanced Compression Advanced Index Compression Prefix Compression (also called Key Compression) Basic Table Compression Deferred Segment Creation Bitmapped index, bitmapped join index, and bitmap plan conversions Transportable tablespaces, including cross-platform and full transportable export and import Summary management—Materialized View Query Rewrite.
Views: 1386 java frm
Reduce the cost of an Oracle database migration project by using SQL Server Linked Servers
 
02:04
When talking about migration from Oracle to SQL Server, we always look for ways to work with our customers to keep costs under control. We recently completed an Oracle to SQL Server migration proof of concept project for a government organization in South America. What made this project unique was the way we used SQL Server Migration Assistant (SSMA) to convert one of eleven Oracle database schemas that were running on a 12-node Oracle RAC cluster to SQL Server. The other ten schemas remained in place and we used SQL Server Linked Servers on the new SQL Server instance to connect to the Oracle schema tables. Check out our blog post for more information - https://www.dbbest.com/blog/reduce-cost-database-migration-using-sqlserver-linked-servers/
Oracle Database 12c: Moving Online Data Files
 
04:07
About moving online data files Oracle Database 12c new feature, with examples.
Views: 5284 OracleDBVision
Use Enterprise Manager 12c to Fix Offline ASM Disk from simulated device failure
 
02:22
In this demo I show how to use Enterprise Manager 12c to online a disk after a simulated device failure.
Views: 360 Javier Ruiz
EAIESB Oracle ADF Mobile SOA APP
 
03:45
EAIESB Oracle ADF Mobile SOA APP This App will help SOA Admin Team, Support Team and Development team to connect to SOA server and get list of Partitions, Composites deployed in each partition and list of instances for each Partitions Currently we are supporting  Connecting to SOA Server  Getting List of Partitions  Getting List of Composites Deployed  List of recent Instances  Instance Details
Views: 113 eaiesb
How to move Partitions ONLINE  and make them READ ONLY
 
03:46
The clip demonstrates how to move (compressing) Partitions ONLINE and how to make them READ ONLY. Both are 12c New Features. Text version is here: https://uhesse.com/2017/01/05/how-to-move-partitions-online-and-make-them-read-only-in-oracle-12c/
Fix Windows Cannot be Installed To This Disk
 
02:16
Windows cannot be installed to this disk. The selected disk has an MBR partition table. On EFI sytems, Windows can only be installed to GPT disks. Visit my website: http://www.avoiderrors.net/?p=22853
Views: 519436 AvoidErrors
OpenMediaVault 4.0 NAS Storage Installation + Configuration + Overview on Oracle VirtualBox [2017]
 
18:26
This video tutorial shows OpenMediaVault 4.0 NAS Storage Installation, Configuration and Overview on Oracle VirtualBox step by step. We also create and configure Storage Volume and setup Samba/SMB/CIFS and NFS shares on OpenMediaVault storage. This tutorial is also helpful to installing OpenMediaVault 4.0 on physical computer hardware or bare-metal server. Steps: 1- Create Virtual Machine on Oracle VirtualBox 2- Start OpenMediaVault Storage 4.0 Installation 3- OpenMediaVault Storage Initial Configuration 4- Create and Configure RAID Device 5- Create New User and Group on OpenMediaVault 6- Create, Configure and Test Samba/CIFS/SMB and NFS Shares 7- OpenMediaVault 4.0 Storage Overview What is OpenMediaVault (OMV) NAS Storage? OpenMediaVault is a Network-Attached Storage (NAS) solution based on Debian GNU/Linux. It contains services like SSH, (S)FTP, SMB/CIFS, DAAP media server, rsync, BitTorrent and many more. Thanks to a modular design it can be enhanced via plugins. OpenMediaVault is primarily designed to be used in home environments or small home offices, but is not limited to those scenarios. It is a simple and easy-to-use out-of-the-box solution that will allow everyone to install and administrate a Network-Attached Storage without deeper knowledge. OpenMediaVault features: - Running out-of-the-box - Debian Linux OS - Web based administration - Easy system updates via Debian package management - Volume management - S.M.A.R.T. - Link aggregation - Wake On Lan - IPv6 support - Email notifications - File sharing - Extendible via plugins OpenMediaVault Storage Website: https://www.openmediavault.org/ Download OpenMediaVault 4.0 ISO: https://sourceforge.net/projects/openmediavault/files/ Hope you found it informative and useful. Any questions or comments are welcomed. PLEASE SUBSCRIBE TO THE CHANNEL ---------------------------------------------------------------------------- Website: http://www.SysAdminsHowto.com/ Facebook Page: https://www.facebook.com/SysAdminsHowto/ Twitter: https://twitter.com/SysAdmHowto Linux Video Tutorials: https://linux-video-tutorials.blogspot.com/ OpenMediaVault 4.0 Storage Installation on VirtualBox Video: https://youtu.be/GkAoBW1BqGE
Views: 32455 Linux Video Tutorials
Debian 9 Installation Guide
 
13:04
The installation process of Debian 9 Stretch is quite straightforward if you are an experienced Linux user. But if you try Debian your first time, there are several things which I find confusing for new users. So, if you decided to install and use Debian 9 Stretch, here is an overview of the Debian 9 installation process with some useful recommendations. 00:38 1. What ISO to download - Live ISO - Install ISO - Non-free ISOs 02:55 2. installation - Create a bootable USB drive https://youtu.be/rpGgTTFKwiU - 05:10 Automatic partitioning of a whole drive - 05:30 Install without formatting your home partition. This is in case you had Linux installed on your computer before. - 07:26 Manually partition your hard drive with re-formatting the whole drive. 10:40 3. After installation - Add contrib and non-free repositories. (NOTE: use Ctrl+O to save and Ctrl+X to exit from the nano text editor) - Enable the latest security updates. - Receive the bug fixes as quick as possible. - Proprietary drivers. Mentioned videos: Debian 9 Stretch Xfce review - The Best Xfce distro! https://youtu.be/WmeXOZEVebY Make Xfce look modern and beautiful https://youtu.be/GR2y0xOIIdI 10 things to do after installing Debian Xfce https://youtu.be/BWBHJmAmZgk Repositories (https://www.debian.org/releases/stable/errata.pt.html) : # latest security updates deb http://security.debian.org/ stretch/updates main contrib non-free # proposed additions deb http://ftp.us.debian.org/debian stretch-proposed-updates main contrib non-free Proprietary drivers: Graphics Card https://wiki.debian.org/GraphicsCard nVidia https://wiki.debian.org/NvidiaGraphicsDrivers ATI https://wiki.debian.org/AtiHowTo https://wiki.debian.org/ATIProprietary https://www.reddit.com/r/debian/comments/4a8nyq/fglrx_for_debian_9_will_it_get_back/ Wifi drivers https://wiki.debian.org/WiFi https://www.youtube.com/watch?v=eUnfVG7Zst0 ################################################ Support on Patreon: https://www.patreon.com/averagelinuxuser Donate through PayPal: https://www.paypal.me/Kryvokhyzha ################################################ More cool Linux stuff at other social media: Google+ - Best Linux Stuff: https://plus.google.com/+AverageLinuxUser Facebook - Top Linux Tips: https://www.facebook.com/AverageLinuxUser Twitter - Daily Linux News: http://twitter.com/AVGLinuxUser Website: http://averagelinuxuser.com/
Views: 192936 Average Linux User
How to bypass FORCE LOGGING
 
05:08
You either need that redo for your DataGuard instance...or you don't want it to keep load performance at peak. But what if you need both options? blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe as new tech videos come every week!
Views: 625 Connor McDonald
Schamat bazy Oracle
 
01:18
Views: 152 Marcin Wlasny
Oracle Database 18c Express Edition Installation on Oracle Linux 6.10 | Oracle Database 18c XE
 
33:15
In this video we are going to demonstrate how to install Oracle Database 18c Express Edition in Oracle Linux 6.10. Oracle Database 18c Express Edition installation in Oracle Linux 6 Platform is very easy. This video guides step by step installation of oracle 18c includes kernel parameters configuration, dependencies installation, oracle database installation, oracle listener configuration after installation and finally access oracle enterprise manager 18c in browser. Hardware Requirements : Minimum 2 GB RAM, 2 CPU Cores and Enough Hard disk Space. Software Requirements : Oracle Enterprise Linux 6 with dependencies for oracle database 18c installed and Kernel Parameters configured. Important Note: To avoid Port already in use error I will be configuring hostname at the end of installation. Installation method : Offline, Oracle Database 18c XE RPM file for linux downloaded and installed. Oracle Database 18c XE Features ############################### Oracle Multitenant - # of PDBs SQLJ Microsoft Distributed Transaction Coordinator support Native .NET Data Provider—ODP.NET .NET Stored Procedures Online index rebuild Online table organization Online table redefinition Trial recovery Fast-start fault recovery Flashback Table Flashback Database Cross-platform Backup and Recovery Sharded Queues Network Compression Client Side Query Cache Query Results Cache PL/SQL Function Result Cache Adaptive Execution Plans In-Memory Column Store In-Memory Aggregation Attribute Clustering Column-Level Encryption Tablespace Encryption Oracle Advanced Security Oracle Database Vault Oracle Label Security Centrally Managed Users Fine-grained auditing Privilege Analysis Real Application Security Redaction Transparent Sensitive Data Protection Virtual Private Database Oracle Spatial and Graph Property Graph and RDF Graph Technologies (RDF/OWL) Partitioned spatial indexes Oracle Partitioning Oracle Advanced Analytics Oracle Advanced Compression Advanced Index Compression Prefix Compression (also called Key Compression) Basic Table Compression Deferred Segment Creation Bitmapped index, bitmapped join index, and bitmap plan conversions Transportable tablespaces, including cross-platform and full transportable export and import Summary management—Materialized View Query Rewrite
Views: 185 java frm
Install and configure Sql Developer on Windows | Oracle Tutorial
 
05:12
How to Install SQL Developer on Windows 1) Download for the below link http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 2) Make sure you have Java Development Kit installed with latest version. http://www.oracle.com/technetwork/java/javase/downloads/index.html 3) Install SQL developer as rpm -ihv sqldeveloper-xxx.noarch.rpm (replace xxx with exact version of your SQL developer) Run SQL developer on linux command prompt as $ sqldeveloper 4) Create a new connection to connect to user Technology Lair : www.technologylair.org Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp For Linux : https://www.youtube.com/playlist?list=PLUXK1VpPWQKHV2xOmjQgUNj3Hrmcslj-H Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/technologylair Tweet us : http://twitter.com/technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 342058 TechLair
How to Create & Mount Virtual Hard Disk in Windows Server 2012 R2
 
05:55
In this video demonstration we will see How to Add VHD & Mount VHD in Windows Server 2012 R2 by using Disk Management Snap-In Tools. This video contain the steps to Create Virtual Hard Disk (VHD) Fixed Size and Dynamically Expanding, how to mount, how to create partition, how to detach mounted VHD.
Views: 16755 MSFT WebCast
Oracle Database 18c Express Edition Installation on Redhat Enterprise Linux 7.5
 
33:55
In this video we are going to demonstrate how to install Oracle Database 18c Express Edition in Redhat Enterprise Linux 7.5. Oracle Database 18c Express Edition installation in RHEL 7 Platform is very easy. This video guides step by step installation of oracle 18c includes kernel parameters configuration, dependencies installation, oracle database installation, oracle listener configuration after installation and finally access oracle enterprise manager 18c in browser. Hardware Requirements : Minimum 2 GB RAM, 2 CPU Cores and Enough Hard disk Space. Software Requirements : Redhat Enterprise Linux 7 with dependencies for oracle database 18c installed and Kernel Parameters configured. Important Note: To avoid Port already in use error I will be configuring hostname at the end of installation. Installation method : Offline, Oracle Database 18c XE RPM file for linux downloaded and installed. Oracle Database 18c XE Features ############################### Oracle Multitenant SQLJ Microsoft Distributed Transaction Coordinator support Native .NET Data Provider—ODP.NET .NET Stored Procedures Online index rebuild Online table organization Online table redefinition Trial recovery Fast-start fault recovery Flashback Table Flashback Database Cross-platform Backup and Recovery Sharded Queues Network Compression Client Side Query Cache Query Results Cache PL/SQL Function Result Cache Adaptive Execution Plans In-Memory Column Store In-Memory Aggregation Attribute Clustering Column-Level Encryption Tablespace Encryption Oracle Advanced Security Oracle Database Vault Oracle Label Security Centrally Managed Users Fine-grained auditing Privilege Analysis Real Application Security Redaction Transparent Sensitive Data Protection Virtual Private Database Oracle Spatial and Graph Property Graph and RDF Graph Technologies (RDF/OWL) Partitioned spatial indexes Oracle Partitioning Oracle Advanced Analytics Oracle Advanced Compression Advanced Index Compression Prefix Compression (also called Key Compression) Basic Table Compression Deferred Segment Creation Bitmapped index, bitmapped join index, and bitmap plan conversions Transportable tablespaces, including cross-platform and full transportable export and import Summary management—Materialized View Query Rewrite
Views: 108 java frm
Data Stage : Importing ODBC Oracle Table Definitions
 
02:29
Importing ODBC Oracle Table Definitions
Views: 631 Raja Sekhar
How To Partition C: Drive Windows XP
 
04:00
To partition a hard drive in Windows XP means to divide the hard drive into parts and make those parts available to Windows XP. Partition Master: http://goo.gl/sAQDwD Read More: http://www.avoiderrors.net/?p=11650
Views: 217603 AvoidErrors
SSMA for Oracle 7.0 — Overview of Data Migration Features
 
03:25
SQL Server Migration Assistant (SSMA) 7.0 supports data migration. In this video we'll show how to migrate data in SSMA. Check out the blog post at https://www.dbbest.com/blog/ssma-oracle-overview-data-migration-features/ to learn more about data migration issues.
Views: 1184 DB Best Technologies
System Design: Choosing Database b/w SQL vs NoSQL
 
08:19
SQL vs NoSQL: - SQL: It stores data in row & columns - MySQL, Oracle, SQLite - Each record has fixed schema, columns must be decides before data entry, can be altered but involves modifying whole database & going offline - It uses SQL Query - SQL are vertically scalable i.e. by increasing the higher memory, CPU of headware, which can be very expensive - Most of SQLs are ACID compliant (Atomity, Consistency, Isolation, Durability) - When you want to ensure ACID compliance & your data is structured & unchanging. - NoSQL: Common types - Key-Value stores: Redis, Voldemart, Dynamo - Document databases: MongoDB, CouchDB - Wide-Column database: Column families - Best suited for analyzing large dataset - Cassendra, HBase - Graph Database: Data is saved in graph structure with nodes(entities), properties & lines(Connection) - Neo4J, InfiniteGraph - Here schemas are dynamic, Coulmns can be added on the fly & each row doesn't have to be contain each columns - Here queries are focused on a collection of documets. It's also known as UNQL (Unstructured Query language) - These are horizontally scalable meaning we can add more servers easily. Lot of servers are distributed data servers also. - Most of NoSQL sacrifice ACID compliance for performance & scalibility. - When storing large volume of data with rapid development with no structure fixed. - Cloud based commputing & storage. They are designed to be scaled across multiple data servers In this video, we're going to reveal about Choosing database in System Design: - What is SQL database - What is NoSQL database - When to choose SQL database - When to choose NoSQL database ★☆★ SUBSCRIBE TO ME ON YOUTUBE: ★☆★ https://www.youtube.com/codingsimplified?sub_confirmation=1 sql vs nosql pros and cons, sql vs nosql use cases, sql vs nosql performance, sql vs nosql stackoverflow, sql vs nosql 2018, sql vs nosql transactions, sql vs nosql security, difference between sql and nosql databases CHECK OUT CODING SIMPLIFIED https://www.youtube.com/codingsimplified I started my YouTube channel, Coding Simplified, during Dec of 2015. Since then, I've published over 200+ videos. My account is Partner Verified and I get my earnings direct deposited into my account every month. ★☆★ VIEW THE BLOG POST: ★☆★ http://codingsimplified.com ★☆★ SEND EMAIL At: ★☆★ Email: [email protected]
Views: 463 Coding Simplified
Managing a hard disk with bad sectors for storing non-important data
 
10:29
-OS : Debian 7.8 GNU/Linux, Gnome 3 desktop (fallback experience). -Oracle VirtualBox for virtual machine creation. -btrfs-tools and Gsmartcontrol installed with Synaptic package manager. -UltimateBootCD 5.1.1 and Gparted-live-0.19.1-4 .iso files (booted with the virtual machine). (About 10GB, i mean 1024MB*10) Bad sector is a physical problem in the disk surface, here i do some steps to isolate partitions with bad sectors and start using other partitions with relative worry. Gsmartcontrol indicates Raw value, it's the actual number of Uncorrectable, Reallocated or Pending sectors. If you plan to use an old HDD with bad sectors (over 31136 like me!) make sure that the raw value of uncorrectable sectors stop rising completely after a long time, during this time the HDD should be working offline (from "offline uncorrectable" adjective), which means powered and connected with its interface plus no read/write operation passed to it, and all HDD power management deactivated, to get the Raw Value quickly without being interfered. Keep in mind that nothing 100% sure about a HDD with defective platters. Calculate the damaged size : This hard drive has 31136 Offline Uncorrectable sectors, if one sector equals 512 bytes logical/physical therefore 31136*512=15941632 bytes divided by 1024^2 to get 15.203125 Megabytes. for your information one sector is more than enough to cause data loss to whole hard drive ! if that sector serves to store partitions table (that's why Gparted warns you when it's about to create partition table) the video with original format (ogv): https://drive.google.com/file/d/0B85Zedj4A3pSZzFLcDdJc3B5d0E/view?usp=sharing
Views: 2253 LineNumber0
Oracle Database 12c: Recovering a Pluggable Database
 
06:38
How to recover a pluggable database in an Oracle 12c multitenant environment.
Views: 5904 OracleDBVision
oracle asm diskgroup adhu check & repair disk header metadata
 
02:00
oracle asm diskgroup adhu check & repair disk header metadata
How to extend Ubuntu server root partition (Step by Step guide)
 
18:14
Support NLB Solutions - https://www.patreon.com/NLBSolutions In this video I am going to show you how you can use Gparted to perform an offline extend of your Ubuntu root partition. Please note that there are several methods (depending on your configuration) where you can extend your Ubuntu server partitions: 1. Using Logical Volume Manager (LVM) - dynamically create partition. 2. Using GParted - offline extend with GParted Live CD or Ubuntu Desktop Live CD 3. Online expand - remove the partition and re-create it with additional free space (CLI) Always remember to backup your server before proceeding with extending the root partition.
Views: 50612 NLB Solutions
Oracle Database 18c Express Edition Installation on Redhat Enterprise Linux 6.10
 
33:28
In this video we are going to demonstrate how to install Oracle Database 18c Express Edition in Redhat Enterprise Linux 6.10. Oracle Database 18c Express Edition installation in RHEL 6 Platform is very easy. This video guides step by step installation of oracle 18c includes kernel parameters configuration, dependencies installation, oracle database installation, oracle listener configuration after installation and finally access oracle enterprise manager 18c in browser. Hardware Requirements : Minimum 2 GB RAM, 2 CPU Cores and Enough Hard disk Space. Software Requirements : Redhat Enterprise Linux 6 with dependencies for oracle database 18c installed and Kernel Parameters configured. Important Note: To avoid Port already in use error I will be configuring hostname at the end of installation. Installation method : Offline, Oracle Database 18c XE RPM file for linux downloaded and installed. Oracle Database 18c XE Features ############################### Oracle Multitenant - # of PDBs SQLJ Microsoft Distributed Transaction Coordinator support Native .NET Data Provider—ODP.NET .NET Stored Procedures Online index rebuild Online table organization Online table redefinition Trial recovery Fast-start fault recovery Flashback Table Flashback Database Cross-platform Backup and Recovery Sharded Queues Network Compression Client Side Query Cache Query Results Cache PL/SQL Function Result Cache Adaptive Execution Plans In-Memory Column Store In-Memory Aggregation Attribute Clustering Column-Level Encryption Tablespace Encryption Oracle Advanced Security Oracle Database Vault Oracle Label Security Centrally Managed Users Fine-grained auditing Privilege Analysis Real Application Security Redaction Transparent Sensitive Data Protection Virtual Private Database Oracle Spatial and Graph Property Graph and RDF Graph Technologies (RDF/OWL) Partitioned spatial indexes Oracle Partitioning Oracle Advanced Analytics Oracle Advanced Compression Advanced Index Compression Prefix Compression (also called Key Compression) Basic Table Compression Deferred Segment Creation Bitmapped index, bitmapped join index, and bitmap plan conversions Transportable tablespaces, including cross-platform and full transportable export and import Summary management—Materialized View Query Rewrite.
Views: 26 java frm
An ultimate approach to converting hierarchical queries from Oracle to SQL Server
 
03:28
One of our customers was migrating their Oracle database to SQL Server. They faced a problem with conversion of multiple database schemas that included over 400 hierarchical queries. We came up with an alternative approach to the conversion of hierarchical queries and managed to complete the project within the required period of time. Learn more about our ultimate conversion solution from this video and the following blog post: https://www.dbbest.com/blog/convert-oracle-hierarchical-queries-sql-server
ORACLE LINUX|SQL DEVELOPER|DOWNLOAD|INSTALL|CONFIGURE
 
09:27
Hi Folks, This is R.Sai diwakar in this video i m going to share the installation of sql developer in linux OEL 6.7.
Views: 64 EBS STUDIO ORACLE
DB2 Basics Tutorial Part 15 - Tablespaces
 
21:11
Types of tablespaces and extentsize
Views: 3680 db2 nix
How to take User Managed Hot/Online backup for tablespace OR database.
 
16:07
In this video you will see the steps to take User managed online/hot backup of Single instance database of Oracle 11g. We have to take backup of datafiles, Controlfile, Redo log files, Parameter file and Password file.
Views: 187 linux recipe
CentOS 6.9 Offline Installation with Virtual Box 5.1
 
12:06
CentOS 6.9 Offline Installation with Virtual Box 5.1 on Windows Host.
Views: 1305 java frm
How to install Antergos correctly
 
04:21
This video details the correct method to install Antergos. Since Cnchi, the Antergos installer is in beta, many people have a problem installing it. So I have made this video to show how to install Antergos properly.
Views: 12971 Linux Tex
Oracle 12C by Mr. Wilson On 24th July @ 9:00AM At Matrivanam (HYD)
 
00:29
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftvideos.com/
Manual Partitioning of HardDisk in CentOS 6.9 in VirtualBox 5.2 for Beginners
 
16:39
In this Video we are going to demonstrate how to do Manual Partition or Customized partitioning of Hard disk in CentOS 6.9 Workstation Virtual Machine in VirtualBox 5.2 during Installation. After Installation we will verify whether Processor Cores and disk size are configured properly. This video will be useful for beginners who likes to do Manual partitioning with customized size to each directory in file system. This custom partitioned Virtual Machine can be used as Development Environment for Java,PHP,Python and Database installations etc. Here we are using 160 GB Virtual Hard Drive and allocating 16 GB RAM and Six Core Intel Xeon E5 Processor to the centos VM. Ext4 file system is used for all mount points. Standard Partition scheme is selected and after installation each mount points are verified.
Views: 382 java frm
New,Free and Most Powerful Oracle Database Management Software(Utility)
 
08:20
Typhoon is a comprehensive and reliable application that was developed to assist you in managing the contents of your Oracle databases, enabling you to add, edit or remove tables without needing to resort to SQL statements to get the job done. To gain access to the utility, you first need to create an account using a preferred set of credentials, which will then be required to enter every time you wish to work with Typhoon. The program allows you to connect to a local or cloud server, by providing the necessary information, including name, version, driver and service ID. You can also input the network details, specifically the host and port number, along with the username and password, or even the database URL. Prior to saving the configuration, you can test the connection to make sure everything is in order. Once you connect to the Oracle database, Typhoon allows you to view its contents, namely the tables that it comprises. You can browse through them, select a record and update it. Similarly, you can add a new one, as the tool enables you to ‘Insert Number Data’, ‘Insert Blob Data’, ‘Insert Clob Data’, ‘Insert String Data’ or ‘Insert Date Data’. Moreover, you can create a new table by defining the number of columns that you need, assigning it a name, then filling out the columns and rows with the information you wish it to store. All of this can be done without having to resort to SQL statements or commands. Other options include the ability to drop tables from the database. This Java-based utility also offers you a series of SQL 'Syntax References', (statements and functions) and which you can analyze in detail, to learn how to better work with them, then use them for your own purposes.
Views: 27 typhoonDBMS
Migration to the Oracle Cloud
 
00:30
Only Oracle offers the ability to move to the cloud without having to make any modification to your applications. Data is encrypted in transit and at rest.
Views: 365 Oracle
Install Java/JDK8 on ubuntu Hindi
 
06:38
Step By Step Explanation fro installing Java on Ubuntu Step 1:- Download JDK 8 tar.gz file from official website Step 2:- Extract contents using tar command $tar -xzvf filename.tar.gz Step 3 :- Move Extracted file to /usr/local/java Directory Step 4: - Update Alternatives $sudo update-alternatives --install "/usr/bin/java" "java" "/usr/local/java/jdk1.8.0_60/bin/java" 1 $sudo update-alternatives --install "/usr/bin/javac" "javac" "/usr/local/java/jdk1.8.0_60/bin/javac" 1 $sudo update-alternatives --install "/usr/bin/javaws" "javaws" "/usr/local/java/jdk1.8.0_60/bin/javaws" 1 Step 5 :- Update bashrc file $sudo gedit ~/.bashrc Step 6 :- Apply code $Source ~/.bashrc Step 7 :- Check Java version $java -version Link to English Video :- https://www.youtube.com/watch?v=muj6OAZMLmU
SQL Developer 3.1 - Database Copy
 
04:55
This demonstration will show how to copy objects and data from one database to another. This video is part of the SQL Developer Release 3.1 New Features series. --------------------------------------------------------------------- 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.
sap installation on vmware in your desktop
 
11:02
sap access in your laptop through vmware for practice and sap installation in your laptop required hardware 250 gb free space partition , dual core and 2 gb ram
Views: 8169 yakob t