Home
Search results “Oracle imp no log”
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 178888 Abbasi Asif
Configuring Oracle Database to use Archive Log Mode
 
01:43
small video that explains how to setup oracle database to use the archivelog mode.
Views: 12716 jricardooliveira
Oracle DBA, Implement archive log mode 1e8
 
08:59
how to implement archive log mode in oracle
Views: 1610 hammadshams
Importing Data from Excel into Oracle Database using SQL Developer 4.1
 
02:23
One of SQL Developer’s most popular features has undergone a significant upgrade. Users can quickly define and recall delimited or Excel files to be imported to a new or existing Oracle table. Data preview and validation is provided for each column, as well as ‘best guess’ data type and date format mask mapping. This process can now be automated via the SQL Developer command line interface (SDCLI) ‘Import’ command. NOTE: This is a video only. There is no audio. 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.
How to Export and import oracle 10g database .rm
 
03:55
طريقة استيراد و تصدير قاعدة بيانات من أوراكل
Views: 77533 MahmoudRFarra
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 273558 Chandra Shekhar Reddy
How To Configure Oracle 11g Database Archive Log Mode?
 
03:26
configure oracle database in archive log mode, oracle 10g, 11g process to put database in archive log mode.
Views: 228 pavankumar hirpara
Oracle 11G Export and Import using Oracle Data Pump
 
08:59
Step1. Login through Enterprise Manager using System user but not as "sysdba". Instead as normal User. Step 2. Go to "Data Movement Page" Step 3. Select Export Step 4. Use the Wizard to complete the Export. Same way you can Import. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. To know about me visit my profile at www.rnsangwan.com. I deliver online training on Business Analysis, Linux, Unix, MySQL, Sybase, SQL Server, Perl, Python, R Data Analysis, Scala etc.
Views: 15896 TheSkillPedia
Connect Excel to Oracle Database
 
05:03
How to connect an Oracle Database to Microsoft Excel. https://www.elance.com/s/edtemb/
Views: 99399 i_marketing
How to Use SAS - Lesson 3 - Importing External Data
 
16:06
Bitcoin donations are welcome: 1GGV3gbJeA83FWmz9hDfPri8EuqcUtodXy Mike's SAS Tutorials Lesson 3 Update: Many users have expressed an interest in using my cheat sheet. Ultimately, my goal was to encourage users to create their own cheat sheets to learn from. However, if you'd like to use mine, it is available for purchase at the following web page using PayPal: https://www.e-junkie.com/ecom/gb.php?i=1077465&c=single&cl=207650 This video series is intended to help you learn how to program using SAS for your statistical needs. Lesson 3 introduces the concept of permanent or external data sets and how to import them into SAS. I provide basic methods of importing permanent data sets using the INFILE statement and the IMPORT procedure (PROC IMPORT) for non-SAS based data files. I also discuss libraries and the LIBNAME statement to import SAS data directly using the SET statement. Finally, I show how one can save a SAS data set from the data step using LIBNAMEs in the DATA step. Helpful Notes: 1. The LIBNAME statement is used to point SAS towards a specific folder on your computer. 2. The INFILE statement "reads" data into SAS if it is of a certain format (usually comma, space, or tab delimited). 3. PROC IMPORT - imports data of any of several different file formats into SAS. 4. The SET statement imports data from a library into SAS at the DATA STEP. 5. The library name in a data step's data name "writes" data from SAS into your library folder using SAS's own file format system. Today's Code: data main; input x y z; cards; 1 2 3 7 8 9 ; run; proc contents data=main; run; proc print data=main; run; /* TEMPLATED CODE: .txt file type, with or without delimiters */ data [appropriate data set name here]; infile "[your file location here, including .txt extension]" LRECL=[a logical length of your data to emcompass ENTIRE data] DLM=','; input [variable names here] ; run; data infile_main; infile "C:\My SAS Files\main.txt"; input x y z; run; proc print data=infile_main; run; /* TEMPLATED CODE: Microsoft Excel (.xls) file type */ proc import out=[your data set name here] datafile='[your file location here, including .xls extension]' dbms=excel replace; *Optional statements are below; sheet='[specify sheet to obtain]'; getnames=[yes/no - first row = variable names]; mixed=[yes/no - refers to data types, if num AND char varibles, use yes]; usedate=[yes/no - read date formatted data as date formatted SAS data]; scantime=[yes/no - read in time formatted data as long as variable is not date format]; run; proc import out=imported_excel datafile='C:\My SAS Files\main.xls' dbms=excel replace; *Optional statements are below; sheet='Sheet1'; getnames=yes; run; proc print data=imported_excel; run; libname home "C:\My SAS Files\"; data sas_format; set home.main; run; data home.sas_format; set infile_main; run;
Views: 221618 Mike's SAS Tutorials
How to Import Flat File in Oracle Data Warehouse || TYBScIT || Sem-6 || Dara Warehouse || Flat File
 
07:06
Welcome to Knowledge Works.. In this video you will know about How to Import Flat File in Oracle Data Warehouse. This video is help you to understand how to create and use Flat File in Oracle Data Warehouse. Watch full video to understand do not watch half video otherwise you'll not understand. Watch Previous videos:- 1). Importing Data from oracle to oracle Part-1 👉👉 https://youtu.be/ewfPaX2Ic38 2). Importing Data from Oracle to Oracle part-2 👉👉 https://youtu.be/FyG0dmAqjZM 3). Project Creation In Oracle Warehouse Builder 👉👉 https://youtu.be/8rgAE8XHrRc SUBSCRIBE SHARE LIKE COMMENT PLEASE
Views: 739 Oneness Academy
SQL Tutorial - 13: Inserting Data Into a Table From Another Table
 
07:00
In this tutorial we'll learn to use the INSERT Query to copy data from one table into another.
Views: 246632 The Bad Tutorials
Provision Autonomous Data Warehouse Cloud
 
04:23
This video shows you how to log in to the Oracle Autonomous Data Warehouse console, create a service instance, and create a user. ================================= 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 and http://docs.oracle.com Copyright © 2018 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.
How to Import CSV, Excel, TXT  into Oracle Database With Oracle SQL Developer
 
04:41
This question comes up about as frequently as the ‘how do I import data to Oracle Database’ question. It’s pretty simple once you’ve ran through the process a few times. But you may be here because you’ve never ran through the process before.
Views: 19313 Tayyib Oladoja
Multi-Cursor Editing and SQL Logging in SQL Developer 4.1
 
01:59
SQL Developer 4.1 now offers multi-cursor editing, remembering frequently used files and directories in open and save file dialogs, and verbose SQL recording for all statements sent to the database. 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.
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 342262 Chitu Okoli
MySQL Workbench Database Export and Import
 
08:08
Learn Database Export and Import using MySQL Workbench. Open MySQL Workbench and logged in to MySQL database server using 'root' username and password. In previous couple of videos we learned how to Create, Alter, Drop Databases and Tables and also how to Insert, Read, Update, Delete data rows using MySQL Workbench. In this lecture we will learn how to Export and Import the database using MySQL Workbench. First of all to Export the databases or tables, from top menu 'Server' select 'Data Export' Option, which opens a new window of data export settings and options. The left section on the window displays all the existing databases on our MySQL database server. When we select a database by clicking on it, it displays all the respected tables under the selected database. We can select one or multiple database check-boxes to include the database in the Export file. Under 'Export Options' section, You can change the default export path of you choice. I'll keep the default one. By selecting first option that is 'Export to Dump Project Folder'. MySQL Workbench will save the save all tables as separate SQL file under one folder. Which is useful when you will be importing or restoring the export file one by one table. I'll go ahead quickly and first save as 'Export to Dump Project Folder', MySQL Workbench displays the progress bar and log. Now, I'll again export the database using 'Export to Self-contained File' option. To demonstrate the import first I'll delete the existing 'students' table under 'mytestdb' database. Display database details by clicking on 'i' symbol, select 'tables' tab. Select and right click 'students' table, and click 'Drop Table' option, confirm and delete the table. Click 'refresh' to update the tables section and we have no table in our 'mytestdb' database. Now select the database and from 'data import' window, select 'import from dump folder. 'Load folder contents' and select only 'mytestdb' database and click start import button to import 'students' table again. Go to 'mytestdb' database information window again and click 'refresh' button to reload table list again. and the 'students' table is back. Check out the whole playlist of MySQL Workbench Introduction Tutorials or Individual video from the following links, MySQL Workbench Tutorial: Introduction to MySQL Workbench for Beginners Playlist https://www.youtube.com/watch?v=aGQ7PGZ1u24&list=PLhwzZMYRiUEq5e5TJCznKVuPAsnNzT8k5 MySQL Workbench: Understand What is MySQL Workbench? https://www.youtube.com/watch?v=aGQ7PGZ1u24 MySQL Workbench Add User and Connect to Database https://www.youtube.com/watch?v=P7whjxMqYU4 MySQL Workbench Create, Alter, Drop Database https://www.youtube.com/watch?v=1qzE6SN8AZU MySQL Workbench Create, Alter, Drop Table https://www.youtube.com/watch?v=luBmETAk30k MySQL Workbench Insert, Read, Update, Delete Data Rows https://www.youtube.com/watch?v=qb7abQ6ROy4 MySQL Workbench Database Export and Import https://www.youtube.com/watch?v=Jvul-wr-_Bg Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Gerar backup lógico expdp DATAPUMP oracle
 
07:45
--EXPDP -- DATAPUMP select * from dba_directories; CREATE OR REPLACE DIRECTORY DUMP AS '/oracle_files/dump'; GRANT READ, WRITE ON DIRECTORY DUMP TO scott; GRANT EXP_FULL_DATABASE to scott; -- Full Export expdp scott/tiger DIRECTORY=DUMP DUMPFILE=expdp_full.dmp FULL=y LOGFILE=expdp_full.log -- schema Export expdp scott/tiger DIRECTORY=DUMP DUMPFILE=exp_scott.dmp schemas=scott LOGFILE=exp_scott.log -- Table Export expdp scott/tiger tables=EMP directory=DUMP DUMPFILE=EMP_DUMP.dmp logfile=EMP_DUMP.log -- Compactado ExpDP expdp scott/tiger DIRECTORY=DUMP DUMPFILE=exp_scott.dmp schemas=scott LOGFILE=exp_scott.log compression=all
Views: 105 Vídeos Aulas TI
Import Data and Analyze with Python
 
11:58
Python programming language allows sophisticated data analysis and visualization. This tutorial is a basic step-by-step introduction on how to import a text file (CSV), perform simple data analysis, export the results as a text file, and generate a trend. See https://youtu.be/pQv6zMlYJ0A for updated video for Python 3.
Views: 199436 APMonitor.com
DB Instance Viewer in SQL Developer 4.1
 
01:50
Visualize the status of your database in a brand new, graphical representation of the IO, wait events, storage, log switches, and processes. Requiring no server side objects, agents, or database changes, this new SQL Developer feature will shorten the amount of time it takes to diagnose ongoing performance issues. From the main page, DBAs and power users can quickly drill down into various activity reports to see the details. NOTE: This is a video only. There is no audio. 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.
Import a Batch of user accounts (Oracle Cloud 13.2)
 
05:44
This video shows an Oracle Cloud identity domain administrator how to create a CSV file that contains the required data for each user account, use Oracle Cloud Security portal to upload the data from your CSV file and review the user accounts created and check for any errors. Copyright © 2014 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.
Oracle Database tutorials 4:  database connectivity using SQL developer and command prompt
 
09:19
Blog Link: http://bit.ly/how-to-create-new-connection-in-sql-developer Wishlist: http://bit.ly/wishlist-amazon This SQL tutorial and Oracle database 11g tutorial for beginners will show how to connect to database either on a local machine or on a machine in your LAN using ip address. Tool used in this tutorial is SQL developer & command prompt. This tutorial series is part of SQL expert exam certification training. If you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos The Code makers
Views: 275230 Manish Sharma
Oracle using SQL Developer Data Pump for export and import
 
04:50
Using Oracle SQL Developer to export and import data via the data pump facilities.
Views: 65832 thehighway360
Oracle DBA Justin - How to clone an Oracle database not using RMAN
 
20:23
How to clone an Oracle database not using RMAN
Views: 60761 jbleistein11
Oracle Database Tutorial 57: IMPDP (REMAP_SCHEMA) how to import table in different user/schema
 
04:09
In this oracle database tutorial you will learn How to import table in different schema using Remap_Schema parameter of impdp data pump import utility By Manish Sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/how-to-import-tables-in-different-schema-remap-schema Previous Tutorial Tut 56 How to import table in same schema : http://youtu.be/oEnmEUlicY0 ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 24053 Manish Sharma
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.
Did You Know...You Can View Workflow Actions From Task Log Using Oracle Primavera Unifier (16.1)?
 
01:49
Here is an example of what the 4C Team can do for you and your business from our Did You Know… video series - You Can View Workflow Actions From Task Log Using Oracle Primavera Unifier (16.1). Visit http://www.4cteam.com/did-you-know to view the complete Did You Know… video series. With more than 100 combined years of Unifier experience, no one is more adept or better prepared than Foresee Consulting to help organizations learn about Oracle Primavera Unifier and how to use it. Looking for more? Explore the full list of our Unifier training courses at http://www.4cteam.com/training to see how the 4C Team can help you understand and maximize the benefits of Primavera’s industry-leading program and project portfolio management solutions. Facebook: https://www.facebook.com/ForeseeConsulting Twitter: https://twitter.com/4CTeam LinkedIn: https://www.linkedin.com/company/foreseeconsulting Google+: https://plus.google.com/+4cteam YouTube: https://www.youtube.com/user/ForeseeConsulting Website: http://www.4cteam.com/
DataPump Import
 
05:44
#Oracle #DataPump #Import
Views: 164 Hemant K Chitale
Configuring Oracle Database Alert Monitoring Using the Oracle KM | TrueSight Operations Management
 
02:40
See how to configure alert log monitoring for Oracle Databases using the Oracle Knowledge Module (KM). The Oracle KM captures the most import error messages coming in Oracle alert log file. The video simulates the error in an alert log and shows how the alert is generated by using the Oarcle KM parameter in PATROL Console. For more information, see the BMC Online Documentation at https://docs.bmc.com/docs/display/public/TSOMD105/Home Watch additional how-to videos for TrueSight Operations Management at https://www.youtube.com/playlist?list=PLibAMtD70sYFdoTqeTw_s54WKRRCDpYGJ
Views: 301 BMCdocs
How To Import and Export Data in Doorking Account Manager
 
04:13
www.thegategeek.com In this video I will show you how to export and import resident data in the DoorKing software. Transcription: This is the example account that comes with DoorKing. This is version 6.3e. What we will cover today work in all versions of DoorKing up to the current version 6.3f In the example account, it has three residents and one vendor in the software. I'm first going to export this account. This will provide the header names we will use for importing. Go back to "accounts" and click "file", and then "export". Select the account or accounts you wish to export. You can place the file anywhere on your computer by clicking the browse button. I'm going to place it in the desktop. Now click "OK" A status window tells us that the export was successful. I'm going to go to the desktop now. This is the file that DoorKing has created. It is a CSV file. Microsoft excel will open this file. If you don't have Excel, there is a free office suite made by Oracle at openoffice.org. Google docs will also work. In the top row is the header names. Each corresponds to the database column in the DoorKing software. Now that we have an exported file, I like to copy this row for a guide in the new file. Here is a list of residents I created. I'm now going to paste the header row at the top. And now we can sort the columns into the right header locations I'm going to drag the remotes over to device number. I'm going to the addresses under notes. The phone numbers are going under..... you guessed it "phone". the area code under "AAC". And the names under "resident". The account name must match the account name in DoorKing. Capitalization matters. DoorKing does not use XLS or XLSX files so we need to save this file as a CSV file. I'm going to save the file on the desktop The "CSV MS-DOS" option is just off the screen You'll get a couple of windows informing us that this is not a standard format. Click "OK" then "yes". Here is the file that was created. Back in DoorKing, click "file" and "import", then "import now". Locate the file that was created The "file format" should always be set as "CSV format". "Main Frame Format" is a custom option for universities and schools. The "import type" has two options: update and initialize. "Update" will merge the data, and "initialize" will clear the existing data in the account and import all the data in the csv file. "account selection" has two options. "Single account" and "multiple accounts". One csv file can have multiple accounts as long as the account column is named correctly. we are going to update one account. Click "OK" The status window says "1 account successful, 0 errors and 1 warning". to view the warning click "file" then "view log files", view events log The warning is telling us that the existing names were not in the new imported file. That is OK, we were merging the information. Now let's look under resident database Here is the merged data. Now, you may have notice that the Excel file was set up to import into DoorKing rather easily, however this may not be how you get your data out of an existing system or an accounting program. In the next video I will focus on how to manipulate the data in excel, merge first and last names, separate area codes from phone numbers, and changing first names to an initial.
Views: 6685 The Gate Geek
HOW TO GENERATE E WAY BILL(DETAILED)
 
15:44
Here is a step by step Guide to Generate E-Way Bill (EWB-01) online: Step 1: Login to e-way bill system. Enter the Username, password and Captcha code, Click on ‘Login’ E-way bills Step 2: Click on ‘Generate new’ under ‘E-waybill’ option appearing on the left-hand side of the dashboard. 1) Transaction Type: Select ‘Outward’ if you are a supplier of consignment Select ‘Inward’ if you are a recipient of consignment. 2) Sub-type: Select the relevant sub-type applicable to you: If transaction type selected is Outward, following subtypes appear: f transaction type selected is Inward, following subtypes appear: ote: SKD/CKD- Semi knocked down condition/ Complete knocked down condition 3) Document type: Select either of Invoice / Bill/ challan/ credit note/ Bill of entry or others if not Listed 4) Document No. : Enter the document/invoice number 5) Document Date: Select the date of Invoice or challan or Document. Note: The system will not allow the user to enter the future date. 6) From/ To: Depending on whether you are a supplier or a recipient, enter the To / From section details. Note: If the supplier/client is unregistered, then mention ‘URP’ in the field GSTIN, indicating that the supplier/client is an ‘Unregistered Person’. 7) Item Details: Add the details of the consignment (HSN code-wise) in this section: Product name Description HSN Code Quantity, Unit, Value/Taxable value Tax rates of CGST and SGST or IGST (in %) Tax rate of Cess, if any charged (in %) Note: On the implementation of E-way bills, Based on the details entered here, corresponding entries can also be auto-populated in the respective GST Return while filing on GST portal. 8) Transporter details: The mode of transport(Road/rail/ship/air) and the approximate distance covered (in KM) needs to be compulsorily mentioned in this part. Apart from above, Either of the details can be mentioned: Transporter name, transporter ID, transporter Doc. No. & Date. OR Vehicle number in which consignment is being transported. Format: AB12AB1234 or AB12A1234 or AB121234 or ABC1234
Views: 837833 TAX MITRA
How to import and export oracle tables using Toad
 
03:56
Export and import of dump file.
Views: 5178 LearningMart
Did You Know...You Can Import Records With Attachments in Oracle Primavera Unifier (16.2)?
 
02:40
Watch a little of what the 4C Team can do for you and your business with this selection in our Did You Know… video series - You Can Import Records With Attachments in Oracle Primavera Unifier (16.2). Visit http://www.4cteam.com/did-you-know to view the complete Did You Know… video series. With more than 100 combined years of Unifier experience, no one is more adept or better prepared than Foresee Consulting to help organizations learn about Oracle Primavera Unifier and how to use it. Looking for more? Explore the full list of our Unifier training courses at http://www.4cteam.com/training to see how the 4C Team can help you understand and maximize the benefits of Primavera’s industry-leading program and project portfolio management solutions. Facebook: https://www.facebook.com/ForeseeConsulting Twitter: https://twitter.com/4CTeam LinkedIn: https://www.linkedin.com/company/foreseeconsulting Google+: https://plus.google.com/+4cteam YouTube: https://www.youtube.com/user/ForeseeConsulting Website: http://www.4cteam.com/
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: 331104 TechLair
Habilitar archivelog Oracle
 
07:48
Comandos utilizados: mkdir -p /u01/app/oracle/oradata/CDB1/archivelog select log_mode from v$database; ALTER SYSTEM SET log_archive_format = '%d_%t_%s_%r.arc' SCOPE=SPFILE; %d = ID do BD %s = Número sequencial do log %t = Número da thread %r = ID de resetlogs. Assegura que nomes únicos sejam criados junto à múltiplas encarnações do BD. shutdown immediate; startup mount; alter database archivelog; alter database open; ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=/u01/app/oracle/oradata/CDB1/archivelog' SCOPE=BOTH; select log_mode from v$database;
Views: 89 Vídeos Aulas TI
how to import oracle database or dmp file
 
05:50
This video will tell you how to import a user from oracle data to you oracle data base
Views: 89447 brijesh kumar
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 175570 Manish Sharma
Did You Know...You Can Change Between Advanced Logs And Standard Logs In Oracle Primavera Unifier?
 
01:32
Watch some of what the 4C Team can do for you and your business with this selection from our Did You Know…? video series. Did You Know...You Can Change Between Advanced Logs And Standard Logs In Oracle Primavera Unifier? Visit http://www.4cteam.com/did-you-know to view the complete Did You Know… video series. With more than 100 combined years of Unifier experience, no one is more adept or better prepared than Foresee Consulting to help organizations learn about Oracle Primavera Unifier and how to use it. Looking for more? Explore the full list of our Unifier training courses at http://www.4cteam.com/training to see how the 4C Team can help you understand and maximize the benefits of Primavera’s industry-leading program and project portfolio management solutions. Facebook: https://www.facebook.com/ForeseeConsulting Twitter: https://twitter.com/4CTeam LinkedIn: https://www.linkedin.com/company/foreseeconsulting Google+: https://plus.google.com/+4cteam YouTube: https://www.youtube.com/user/ForeseeConsulting Website: http://www.4cteam.com/
Oracle DBA, 1e22 -How to undrop a table in Oracle 11 g
 
06:31
The video will describe how to undrop table in Oracle 11g using flashback
Views: 518 hammadshams
How to Setup Mysql on your machine
 
03:11
For Complete Database Training Details Visit: http://www.qaonlinetraining.com http://infotek-solutions.com/ Delivery Method: Instructor led classroom and Online Training supported by world class Learning management system which automate all flow of lectures, videos, assignments, forums, quizzes and interview process. Class Schedule: Week-ends and Weekdays Contact Us: 571-437-0652, Mail Us: [email protected] Training Locations at : Ashburn / Fairfax / Maryland Office Address: 12801 Worldgate Dr #500, Herndon, VA 20170 Overview of Oracle DBA Training Oracle as a flexible, complex & robust RDBMS The evolution of hardware and the relation to Oracle Different DBA job roles (VP of DBA, developer DBA, production DBA, database babysitter) The changing job role of the Oracle DBA Environment management (network, CPU, disk and RAM) Instance management (managing SGA regions) Oracle table and index management Instance Architecture Instance vs. database Components of an instance Creating the OFA file structure ($DBA, bdump, udump, pfile) Oracle Instance Internals SGA vs. PGA Background processes Interfaces with server and disk I/O subsystem Using SQL*Plus for DBA management Connecting and executing SQL Using the “as sysdba” syntax Overview of SQL*Plus DBA commands (startup, etc.) Control file, UNDO and REDO management Explaining the use of control files Listing the Contents of the control File File locations for control Files Obtaining Control File Information Listing control file contents Displaying and Creating Undo segments Altering Undo Segments Determining the Number and Size of Undo segments Understanding flashback technology Troubleshooting Undo – snapshot too old Redo log concepts for recovery Online redo log (log_buffer) online redo logs and archived redo logs Oracle ARCH and LGWR background processes Redo log dictionary queries Redo log switch frequency and performance Multiplexing the Online Redo Log Files Archiving the Oracle Redo Logs Recovery using the redo log files User and privilege management The three security methods (VPD, Grant security/role-based security, grant execute) Creating New Database Users Using pre-spawned Oracle connections Auditing User activity Identifying System and Object Privileges Granting and Revoking Privileges Creating and Modifying Roles Displaying user security Information from the Data Dictionary Overview of instance management Parameter files (init.ora, listener.ora, tnsnames.ora) Rules for sizing SGA components Automated Oracle memory management (AMM) Initialization file management Creating the init.ora file Using spfile Displaying init.ora values with v$parameter Oracle*Net configuration Creating the listener.ora file Creating the tnsnames.ora file Data buffer configuration & sizing Inside the Oracle data buffers Using the KEEP pool Monitoring buffer effectiveness Using multiple blocksizes (multiple buffer pools) Shared pool and PGA configuration & Sizing Shared pool concepts and components Understanding the library cache Relieving shared pool contention Overview of PGA for sorting and hash joins Using sort_area_size, hash_area_size and pga_aggregate_target Troubleshooting network connectivity Verifying network connectivity with ping and tnsping Testing database links Oracle tables, views and materialized views Types of Oracle tables (regular, IOT, sorted hash clusters, nested tables) Oracle Views Oracle materialized views Oracle indexes Types of Oracle indexes (b-tree, bitmap, bitmap join index) Creating B*-Tree, bitmap and function-based Indexes Function-based indexes Finding indexing opportunities Index maintenance Oracle constraints Costs & benefits of constraints Types of Oracle indexes constraints (check, not null, unique, PK, FK) Cascading constraints Schema, File & tablespace management Describing the relationship between data files, tablespaces and table Understanding Oracle segments Creating Tablespaces – using the autoextend option Changing the Size of Tablespaces – alter database datafile command Defining a TEMP tablespace Changing the default storage Settings for a tablespace Review of the storage parameters in DBA views (ASM, ASSM, pctfree, pctused and freelists). Monitoring Chained rows (fetch continued rows) Monitoring Insert and Update performance (pctused, APPEND) Database Maintenance Reason for reorgs – chained rows, imbalanced freelists Reorganizing Tables using Export and Import Using CTAS to reorganize data Index rebuilding Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking) Oracle DBA Utilities Data pump (Imp and exp utilities) SQL*Loader LogMiner Flashback DataGuard Oracle DBA utilities – Oracle dbms packages (dbms_redefinition)
How to Fix All .DLL file Missing Error in Windows PC (windows 10/8.1/7)
 
01:52
Fix all missing dll files in windows 10/8.1/7 Click here for more detail... http://www.bsocialshine.com/2016/06/how-to-fix-all-dll-file-missing-error.html D3dx9_43.dll error, D3dx9_41.dl, D3dx9_42.dll, D3dx9_31.dll, d3dx9_39.dll, D3dcompiler_43.dll, d3dx9_43.dll error - d3dx10_43.dll error, d3dx9_43.dll, d3dx10_43.dll, d3dx9_43.dll, d3dx9_42.dll, d3dx9_30.dll, d3dx9_39.dll, binkw32.dll, 2004utils.dll 2057.dll 20sys_r.dll 20utl_r.dll 240197.dll 24cents.dll 25d4315.dll 28_83260.dll 2bp.dll 2dcolormode.dll 2dfilter.dll 2dintmmx.dll 2dmgr10.dll 2dmgr100.dll 2mouse16.dll 2mouse32.dll 2_0_1browserhelper2.dll 3 cuts per beat.dll 311.dll 31x5lc04.dll 31x5ls04.dll 31x5rc04.dll 32 cuts per beat.dll 324aud32.dll 33a76.dll 34api.dll 34coinstaller.dll 3894fc.dll 3dfx32v3.dll 3dfx32vb.dll 3dfxgl_ht2.dll 3dfxis16.dll 3dfxis32.dll 3dnaxtrasupp.dll 3dogldrv.dll 3douninst.dll 3dpcdll.dll 3dpmotioneffectsvst.dll 3dpolygoncruncherplugin.dll 3dprocpl.dll 3dr.dll 3dr32.dll 3dr332.dll
Views: 1290863 MJ Tube
Learn Java 8 - Full Tutorial for Beginners
 
09:32:32
Learn Java 8 and object oriented programming with this complete Java course for beginners. ⭐️Contents ⭐️ ⌨️ (0:00:00) 1 - Basic Java keywords explained ⌨️ (0:21:59) 2 - Basic Java keywords explained - Coding Session ⌨️ (0:35:45) 3 - Basic Java keywords explained - Debriefing ⌨️ (0:43:41) 4 - Packages, import statements, instance members, default constructor ⌨️ (0:59:01) 5 - Access and non-access modifiers ⌨️ (1:11:59) 6 - Tools: IntelliJ Idea, Junit, Maven ⌨️ (1:22:53) 7 - If/else statements and booleans ⌨️ (1:42:20) 8 - Loops: for, while and do while loop ⌨️ (1:56:57) 9 - For each loop and arrays ⌨️ (2:14:21) 10 - Arrays and enums ⌨️ (2:41:37) 11 - Enums and switch statement ⌨️ (3:07:21) 12 - Switch statement cont. ⌨️ (3:20:39) 13 - Logging using slf4j and logback ⌨️ (3:51:19) 14 - Public static void main ⌨️ (4:11:35) 15 - Checked and Unchecked Exceptions ⌨️ (5:05:36) 16 - Interfaces ⌨️ (5:46:54) 17 - Inheritance ⌨️ (6:20:20) 18 - Java Object finalize() method ⌨️ (6:36:57) 19 - Object clone method. [No lesson 20] ⌨️ (7:16:04) 21 - Number ranges, autoboxing, and more ⌨️ (7:53:00) 22 - HashCode and Equals ⌨️ (8:38:16) 23 - Java Collections ⌨️ (9:01:12) 24 - ArrayList 🎥Course by Marcus Biel, an experienced software craftsman. Watch more great tutorials on his YouTube channel: https://www.youtube.com/channel/UC0syIz79dzjMXIf5VdJ65EA 🔗Check out a written version of this course with additional resources here: https://marcus-biel.com/java-beginner-course/ 🔗Get even more Java resources from Marcus here: https://java8course.com -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://medium.freecodecamp.org And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
Views: 368552 freeCodeCamp.org
Navicat Installation and Login with ORACLE to Import & Export Data
 
03:53
How to Install Navicat Software and Connect Oracle Database. Exploring Tables, Views and all type of Data from Connected Schema. You can also Export and Import Data of any Format(File) like as Text, Word, Excel, Access, DBase, HTML, SQL script, XML, LDAP DataInterchange and Others by using Navicat.
Views: 2154 Kaium Siblu
How to Export and Import Putty Sessions for Remote Server Access
 
09:13
This video will show you how to export your saved Putty sessions onto a USB drive. By keeping your session data, private key, and a copy of the putty.exe on a USB thumb drive you can take it with you and access your servers remotely from anywhere. Hope you find this helpful and don't forget... If you are accessing your server remotely from outside your local network you will need to do two things. 1. Change the hostname field in putty to your public facing IP address. 2. Forward your SSH port in your router to point to the servers that you wish to access. Thanks for watching and feel free to check out the blog at http://oddrandomthoughts.com for a dose of the strange and unusual.
Views: 3043 Odd Random Thoughts
Import / export database data from / to Excel using ASP.NET and C#
 
41:27
In this post, I explain how to import / export database data from/to Excel file using ASP.NET and C#. Import/export data from/to some common format is a very useful technique for transfer data between two other programs/ system on a different platform. Part 2 : Import / export database data from / to XML using ASP.NET and C#. For Source Code Visit : http://dotnetawesome.blogspot.com/2013/11/how-to-import-export-database-data-from_16.html https://www.youtube.com/watch?v=vDLUc3ZMq3Y Visit Part 1: Import / export database data from / to CSV using ASP.NET and C# For Source Code Visit : http://dotnetawesome.blogspot.com/2013/11/how-to-import-export-database-data-from.html Youtube Link : http://youtu.be/FueG-G83_PM
Views: 202422 sourav mondal