Home
Search results “Oracle data pump dir”
Oracle Export Data and Import Data using DataPump
 
20:22
Steps to Import and Export Table Step 1: Create Directory Step 2: Grant Read and Write Permission to Directory Step 3: GRANT ROLL DATAPUMP_EXP_FULL_DATABASE to user Step 04: Use EXPDP and IMPDP to Export and Import data
Views: 6876 Data Science Center
understanding  Oracle datapump part 1
 
10:30
Thisvideo is all on understanding oracle data pump. It was introduced in oralce 10g . understand its architecture of datapump create a directory for loading data pump data use expdp which can be fired on server or client impdp to import data. Another video shall arrive later which shall how to fire expdp impdp and also about import export soon.
Query Parameter in Oracle Datapump
 
19:05
Hello Friends Today, In this video I used to show you How to Used Data pump Query Parameter. In Query Parameter we can take export backup using particular query. Suppose iwant to take a export backup of EMP table but in this table i want to take backup only department no 20. so it is possible . please watch this video and subscribe In Some Methods i am showing you. Method 1: (Using Parameter File) ------------------------------------------------------------ 1. Create Table Test. (Create table scott.test as select * from scott.emp;) 2. Create Par file. ------------------------------------------------------------ directory=dump dumpfile=d1.dmp tables='SCOTT . TEST' query=TEST:"WHERE deptno=20" ---------------------------------------------------------------- Save this file test.par --------------------------------------------------------------- 3. Go to Command Prompt Export expdp system/admin parfile='/u01/app/parag/test.par’  Import impdp system/admin directory=dump dumpfile=d1.dmp tables=‘SCOTT . TEST‘ ------------------------------------------------------------------------------------- Method 2: ------------------------------------------------------------ 1. Create Table Test. (Create table scott.test as select * from scott.emp;) 2. Go to Command Prompt Export expdp system/admin directory=dump dumpfile=d2.dmp tables=‘SCOTT . TEST ’ query=TEST:\”WHERE deptno=20\”  Import impdp system/admin directory=dump dumpfile=d2.dmp tables=‘SCOTT . TEST ' -----------------------------------------------------------------------------------------------------------
Views: 632 Parag Mahalle
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 187851 Abbasi Asif
Oracle DBA | Export & Import Schema By Using of Oracle Data Pump(With Tablespace) | Bangla | DBA2-04
 
11:37
Oracle DBA | Export & Import Schema By Using of Oracle Data Pump(With Tablespace) | Bangla | DBA2-04 To See More DBA part-01 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUO3yQq7-LLdfQb5HpsQKNg To See More DBA part-02 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUviefN3-ZzKDVgbIH0RoaS To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU Dear viewer, In this tutorial you will learn how to Export & Import Schema By Using of Oracle Data Pump (With Tablespace) Step1: Tablespeach Creation: command- conn sys sql-create tablespace hr_tst datafile 'E:\app\Administrator\oradata\orcl\wali.DBF' size 500M; Step2: User Creation: command- sql-create user abc identified by abc default tablespace tab1; sql-grant dba to ab1; Step3: Make a Directory: command- sql-create directory datap1 as 'E:\BACKUP_ALL\datapppppp'; sql-grant read,write on directory datap1 to hr; Step4: Export: command-expdp hr/hr directory=datap1 dumpfile=dirfile.dmp Step5: Import: Run cmd command- impdp ab1/ab1 DIRECTORY=datap1 DUMPFILE=dirfile.dmp remap_schema=hr:ab1 REMAP_TABLESPACE=(example:hr_tst,users:hr_tst) To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 88 OracleDB Solutions
Fazer impdp DATAPUMP oracle
 
15:10
--- IMPDP -- DATAPUMP -- Full Import impdp scott/tiger DIRECTORY=DUMP DUMPFILE=expdp_full.dmp FULL=y LOGFILE=imp_full.log -- ImpDP schema impdp scott/tiger DIRECTORY=DUMP DUMPFILE=exp_scott.dmp schemas=scott LOGFILE=imp_scott.log -- ImpDP schema Remap impdp scott_backup/tiger DIRECTORY=DUMP DUMPFILE=exp_scott.dmp schemas=scott LOGFILE=imp_scott.log remap_schema=scott:scott_backup remap_tablespace=users:scott_backup -- Table Import impdp scott/tiger tables=EMP directory=DUMP DUMPFILE=EMP_DUMP.dmp logfile=EMP_DUMP.log
Views: 236 Vídeos Aulas TI
Oracle DBA | How To Export Full Database By Using of Oracle Data Pump | Bangla | DBA2-05
 
08:27
Oracle DBA | How To Export Full Database By Using of Oracle Data Pump | Bangla | DBA2-05 To See More DBA part-01 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUO3yQq7-LLdfQb5HpsQKNg To See More DBA part-02 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUviefN3-ZzKDVgbIH0RoaS To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU Dear viewer, In this tutorial you will learn How To Export Full Database By Using of Oracle Data Pump Step1: Make a Directory: command- create directory datap1 as 'E:\BACKUP_ALL\datapppppp'; sql-grant read,write on directory datap1 to hr; sql-grant DATAPUMP_EXP_FULL_DATABASE to hr; Step2: Export: Run cmd command- expdp hr/hr directory=datap1 dumpfile=dirfile1.dmp logfile=ful_lgfile.log FULL=YES To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 87 OracleDB Solutions
PARFILE in Datapump
 
10:25
Parameter file is just a simple text file which is read and opened by expdp client unlike Dumpfiles and Logfiles which are created and written by the server. SYNTAX ========= [[email protected] ~]$ cat u1.par tables=u1.t1 directory=DATA_PUMP_DIR parallel=4 dumpfile=U1_%U.dmp logfile=expdp_u1.log =============================================== [[email protected] ~]$ expdp parfile=u1.par Export: Release 11.2.0.1.0 - Production on Thu Aug 10 04:02:43 2017 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username: / as sysdba Please like ,subscribe and ask me any queries if you have any doubt. Email: [email protected] ================================================= Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 441 ANKUSH THAVALI
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: 121 Vídeos Aulas TI
Oracle Database Tutorial 52 : Data Pump expdp - How to Export full database using expdp
 
07:26
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp utility here in this tutorial you'll learn how to export full/complete Database using expdp data pump utility of oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/database-full-export-using-expdp Tut 48 Roles: http://youtu.be/tyYxSrCXzCM ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 80468 Manish Sharma
Remap Data Data Pump 11g New Feature
 
02:23
REMAP_DATA Default: There is no default Purpose The REMAP_DATA parameter allows you to specify a remap function that takes as a source the original value of the designated column and returns a remapped value that will replace the original value in the dump file. A common use for this option is to mask data when moving from a production system to a test system. For example, a column of sensitive customer data such as credit card numbers could be replaced with numbers generated by a REMAP_DATA function. This would allow the data to retain its essential formatting and processing characteristics without exposing private data to unauthorized personnel. The same function can be applied to multiple columns being dumped. This is useful when you want to guarantee consistency in remapping both the child and parent column in a referential constraint. expdp system/admin directory=data_pump_dir dumpfile=remap_data_test.dmp tables=scott.candidate remap_data=scott.candidate.address:scott.pkg_data_remap.hide_address impdp system/admin directory=data_pump_dir dumpfile=remap_data_test.dmp tables=scott.candidate impdp system/admin directory=data_pump_dir dumpfile=remap_data_test.dmp tables=scott.candidate remap_data=scott.candidate.address:scott.pkg_data_remap.unhide_address
Views: 623 Saurabh Joshi
Export and Import - Backup&Reco Video 9
 
04:20
In this video you will understand about the Export and Import utilities in Oracle Database Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 3063 Ramkumar Swaminathan
alphorm.com | Formation Oracle Database 11g DBA 1 1Z0-052 (38/50) DataPump
 
03:29
Cette vidéo/tutorial fait partie de la Formation Oracle Database 11g DBA 1 (1Z0-052). Elle est réalisée par l'expert bases de données Noureddine Drissi pour http://www.alphorm.com. Vous pouvez retrouver toute la formation ici http://www.alphorm.com/formation/formation-oracle-database-11g-dba-1-1z0-052 Voici le plan de cette vidéo/tutorial : Data Pump Export des données avec expdp Nécessite la création d'une directory Bonne formation.
Views: 853 alphorm.com
Export and Import oracle Data dump
 
06:59
Export and Import oracle Data dump استيراد وتصدير قاعدة يانات اوراكل
Views: 97639 Appsstuff Middleware
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: 70685 thehighway360
Expdp impdp in oracle(10g) database
 
12:35
Expdp using parfile impdp using parfile create parfile in specific directory for export create parfile in specific directory for import
Views: 93 SUNNY DBA
alphorm.com | Formation Oracle Database 11g DBA 1 1Z0-052 (39/50) Datapump impdp
 
04:24
Cette vidéo/tutorial fait partie de la Formation Oracle Database 11g DBA 1 (1Z0-052). Elle est réalisée par l'expert bases de données Noureddine Drissi pour http://www.alphorm.com. Vous pouvez retrouver toute la formation ici http://www.alphorm.com/formation/formation-oracle-database-11g-dba-1-1z0-052 Voici le plan de cette vidéo/tutorial : Data Pump Import des données avec impdp Nécessite la création d'une directory Bonne formation.
Views: 931 alphorm.com
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: 16553 TheSkillPedia
Adding users, groups and creating directories for oracle database and  oracle software
 
02:30
above video shows how to add new users, groups to the system and create directories for installation of oracle database 12c software. It also shows how to grant permissions of a directory to a specific user who would be installing the software.
Views: 1645 dbaforbeginners
How to Exclude Schemas and Tables using Export and Import. /* Step By Step */
 
08:33
Today I am showing you 1. How to perform Export and Import with Exclude Schemas and Tables in Oracle Datapump utility. When we take a Export Full database Backup but I don’t take a backup of Scott and System Schemas. That time we can use Exclude command. We can Export Scott Schema but exclude EMP , DEPT Tables. If the expdp exclude parameter is used directly from the command line (and  not in a parameter file (parfile)), the special characters (quote marks) in the exclude clause may need to be escaped with  backslash (\) character . Because of this, it is recommended that you always use a parameter file (parfile). In Windows we used round bracket ( ) in IN clouse. But In Linux, we used { } bracket. Exclude Schema: expdp system/admin directory=mydump FULL=Y dumpfile=full.dmp exclude=schema:\"=\'SCOTT\'\“ expdp system/admin directory=mydump FULL=Y dumpfile=full.dmp exclude=schema:\”In{\'SCOTT\‘,\’SYSTEM\’}\“ Exclude Tables: expdp system/admin directory=mydump schemas='SCOTT' dumpfile=scott.dmp exclude=table:\"=\'EMP\'\“ OR expdp system/admin directory=mydump dumpfile=scott.dmp schemas=‘SCOTT’ exclude=:\"IN {\’EMP\',\’ DEPT\‘}\“ It is very easy to understand.
Views: 1695 Parag Mahalle
how to install oracle database 11g r2 in oracle linux
 
33:25
how to install oracle database 11g r2 in oracle linux 7.4. ===========script for configuration=========== # vim /etc/hosts --add IP HOSTNAME.localhost HOSTNAME 192.168.101.218 appserver.localdomain appserver --when # hostname command reply ==== dbserver --go to directory where the oracle software downloaded and unzip #unzip linux.x64_11gR2_database_1of2.zip #unzip linux.x64_11gR2_database_2of2.zip # mv database /home/oracle ---chmod -R a+rwx /home/oracle/.bashrc --should now have a single directory called "database" containing installation files. # yum install oracle-rdbms-server-11gR2-preinstall --Add or amend the following lines in the "vim /etc/sysctl.conf" file. fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 # semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default=262144 net.core.rmem_max=4194304 net.core.wmem_default=262144 net.core.wmem_max=1048586 #yum install libstdc++46-devel libstdc++33 libstdc++33-devel \libelf-devel gcc-c++ libaio-devel sysstat unixODBC unixODBC-devel --Run the following command to see change the current kernel parameters. #/sbin/sysctl -p --Add the following lines to the "vim /etc/security/limits.conf" file. oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 4096 oracle hard nofile 65536 oracle soft stack 10240 --Create the new groups and users. groupadd -g 54321 oinstall groupadd -g 54322 dba groupadd -g 54323 oper #groupadd -g 54324 backupdba #groupadd -g 54325 dgdba #groupadd -g 54326 kmdba #groupadd -g 54327 asmdba #groupadd -g 54328 asmoper #groupadd -g 54329 asmadmin ---to change the selinux permissive # vim /etc/selinux/config SELINUX=permissive # systemctl stop firewalld # systemctl disable firewalld --Add the following lines at the end of the "/home/oracle/.bash_profile" file. # Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=appserver.localdomain; export ORACLE_HOSTNAME ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH --login as oracle user and go to database folder where the installer file.. --$ cd /home/oracle/database $./runInstaller
Views: 344 Ekramul Bari
Oracle Database Tutorial 53 : Data pump expdp - How to Export tablespace in Oracle Database
 
06:26
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp export utility here in this tutorial you'll learn how to export tablespace using expdp export (a.k.a. How To Take Logical Backup of tablespaces in oracle database). Data pump expdp Tablespace Mode ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/export_tablespace_expdp_datapump Previous Tutorial (Tut 52 Full export) http://youtu.be/K8_PjUksT54 ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 33350 Manish Sharma
Oracle Database: How to export and Import Users
 
04:26
Oracle Training in Bangladesh Oracle Developer and Database Training in Bangladesh Oracle Training at Dev Net IT Oracle forms Training for details http://www.devnet-it.com
Views: 2087 devnetbd devnetit
Oracle Database Tutorial 56:Data Pump impdp table and Duplicate (Remap_table ) table
 
06:03
In this oracle database tutorial you will learn How to import table using impdp data pump import utility. And how to rename table using REMAP_TABLE in impdp Data Pump import. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/oracle-data-pump-impdp-import-and-duplicate-table-remap-table Previous Tutorial Tut 55 expdp table- http://youtu.be/5mdmCqGuok8 Tut 54 expdp Schema - http://youtu.be/t8TSLDGN5gg Tut 53 expdp Tablespace - http://youtu.be/-hXBZd-FCjs Tut 54 expdp Full Database - http://youtu.be/K8_PjUksT54 ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 24710 Manish Sharma
oracle tutorial for beginners in hindi | export and import in oracle 11g with examples
 
19:02
In this video you can learn how to take backup with new users . you need to provide the authentication to new user through sys user . by using grant you can provide the access . you need to provide access on directory also using expdp directory = name dumpfile =name logfile =name schemas =user name full=y tables=user name.table name
Views: 1526 Bharat Arya
How to Backup or Export oracle 11g database
 
08:57
The Data Pump Export utility is invoked using the expdp command. The characteristics of the export operation are determined by the Export parameters you specify 1. Create a directory named DBA MY_BACKUP_DIR attached to the actual directory on your hard drive Make sure that the C:/oraclebackup exist. create directory MY_BACKUP_DIR AS 'C:/oraclebackup'; 2.grant read,write on directory MY_BACKUP_DIR to Some_User; 3.Select Directory_Name,Directory_Path From Dba_Directories; We have already created the directory MY_BACKUP_DIR_WUS E:/ORACLE_DATABASE if you want to create the directory then you need to follow the step 1 above cited. 4. Open your BIN folder as i have shown in the video using the bellow folder directory as well C:\app\IT_USER\product\11.2.0\dbhome_1\BIN using cd "C:\app\IT_USER\product\11.2.0\dbhome_1\BIN" 5. after opening the BIN directory then you need to put the following query if you want to export your Schema like hr expdp DIRECTORY=MY_BACKUP_DIR_WUS DUMPFILE= wuscms_13_FEB.dmp SCHEMAS=hr LOGFILE=wuscms_13_FEB.log You need to backup your schema using the system account/schema. so we successfully backup our database In next video we will share how to import a schema Let' wait the process to finalize so the database is exported successfully let's see in the directory.. oracle lighting,oracle park,oracle tutorial,oracle dba,oracle reading,oracle decks,oracle netsuite,oracle erporacle arena
Views: 28 E-Tech Solutions
Oracle 11G DATAPUMP Import-Export Ej:2
 
05:16
Exportacion e importación con QUERY
Views: 393 WilderK Diaz
Oracle database utilities - Perform data export / Import : SQL * loader
 
03:39
Oracle database utilities - Perform data export / Import Description Master oracle utilities with very simple practice exercise which helps you to move data between two oracle databases. Learn how to use oracle utilities to perform data import export into different databases. Perform entire database, single table or schema level export and import into another Oracle database Perform table, schema, row level export using traditional Export Import utility Perform table, schema,row level import using traditional Export Import utility Perform CSV file import into Oracle database using SLQ * Loader Perform table, schema, row level export using Oracle Data Pump Export utility Perform table, schema, row level import using Oracle Data Pump Import utility Create Oracle Data Pump directory to perform Export and Import Oracle Data Pump enables very high speed data movement from one database to another In general, DBA has to perform data Export and Import in real-time environment in order duplicate table or schema from one database to another. Oracle provides utilities in order to easily move data between two oracle databases. With over 9 lectures, 6 hands on lab activities and 1.5 hrs of video content, you will learn: How to invoke oracle utilities How to get help for any type of oracle utilities How to import a CSV format file inside Oracle database table How to create SQL * Loader Control File for CSV import How to perform a small table, schema or specific row export using Export Import utility How to perform import of same using Export Import utility How to create Data Pump directory both at OS level and Database level How to perform data Export and Import using high performance Data pump utility By completing Lab Activities, you will be able to work along with the author and learn Oracle Utilities. You can even download lab activities files and practice on your test machine at home. Who is the target audience? Oracle DBA - Any DBA who would like to learn Oracle Utilities Oracle Developers - who would like to know how data is exported and imported Others - Understand how oracle utilities work
Views: 51 Topaka Rawa
DataPump Export
 
05:48
#Oracle #DataPump #Export
Views: 191 Hemant K Chitale
Oracle Database Tutorial 59: IMPDP Data Pump Import - SQLFILE parameter By Manish Sharma
 
04:22
SQLFILE parameter of impdp data pump import can help you in generating SQL Script of all the DDL that import would have been executed ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: Previous Tutorial Tut 53 How to Export Tablespace- http://youtu.be/-hXBZd-FCjs Tut 54 How To export full database- http://youtu.be/K8_PjUksT54 ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 19871 Manish Sharma
how to import oracle dmp to database
 
11:43
how to import oracle dmp to database Do you know the Oracle database to learn.yes! i will show you how to import oracle dmp to database,plz follow the stpe 1.copy the dmp file to your data directory 2. now run the script in your cmd script is : impdp your database name/[email protected] directory=data_pump_dir thats it . I Don't See the Branches, I See the Leaves by Chris Zabriskie is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Source: http://chriszabriskie.com/dtv/ Artist: http://chriszabriskie.com/
Views: 1239 Tutorial
Oracle Database Tutorial 58: How To Import Schema using REMAP_SCHEMA in impdp Data Pump Import
 
03:59
Learn how to import schema using REMAP_SCHEMA in impd data pump import in oracle database By Manish Sharma Rebellion Rider. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/how-to-import-schema-impdp-data-pump-oracle 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: 23663 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.
creating a directory object en oracle Database 11g
 
02:41
creando un directorio en donde se guardaran nuestros dumps con el Enterprise Manager 11g http://www.mrlocooracle.com
Views: 2831 MrOracle Adolfo Luna
how to create directory in oracle 12c, 11g
 
02:52
Use the CREATE DIRECTORY statement to create a directory object. A directory object specifies an alias for a directory on the server file system where external binary file LOBs and external table data are located. You can use directory names when referring to BFILEs in your PL/SQL code and OCI calls, rather than hard coding the operating system path name, for management flexibility. All directories are created in a single namespace and are not owned by an individual schema. You can secure access to the BFILEs stored within the directory structure by granting object privileges on the directories to specific users. You must have CREATE ANY DIRECTORY system privilege to create directories. When you create a directory, you are automatically granted the READ and WRITE object privileges on the directory, and you can grant these privileges to other users and roles. The DBA can also grant these privileges to other users and roles. WRITE privileges on a directory are useful in connection with external tables. They let the grantee determine whether the external table agent can write a log file or a bad file to the directory. For file storage, you must also create a corresponding operating system directory, an ASM disk group, or a directory within an ASM disk group. Your system or database administrator must ensure that the operating system directory has the correct read and write permissions for Oracle Database processes. Privileges granted for the directory are created independently of the permissions defined for the operating system directory, and the two may or may not correspond exactly. For example, an error occurs if sample user hr is granted READ privilege on the directory object but the corresponding operating system directory does not have READ permission defined for Oracle Database processes. ---------------------------------------------------------------------------- Default directory is DATA_PUMP_DIR.Below command is to get directory name and directory path. SELECT directory_name, directory_path FROM dba_directories WHERE directory_name='DATA_PUMP_DIR' DIRECTORY_NAME DIRECTORY_PATH --------------- ------------------------------------------------------- DATA_PUMP_DIR /u01/app/mohammad75/product/12.1.0/dbhome_1/rdbms/log/
Views: 2447 Oracle DBA World
Oracle Database Tutorial 55: How to export tables using PARFILE in expdp Data Pump By Manish Sharma
 
05:31
In this Oracle Tutorial you will learn how to export tables of the database using Parameter File (PARFILE) in Data Pump expdp export utility. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/expdp-parfile-table-mode-export Previous Tutorial Tut 52 Expdp Full Database http://youtu.be/K8_PjUksT54 Tut 53 Expdp Tablespace http://youtu.be/-hXBZd-FCjs Tut 54 Expdp Schema http://youtu.be/t8TSLDGN5gg ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 27318 Manish Sharma
How To Uninstall Oracle Database 12c
 
10:14
How To Uninstall Oracle Database 12c i). Delete the environment variable ii). delete registries iii). delete oracle homw directory iv) delete directoy from program file v) delete directoy from start menue vi) clear the temporary file
Views: 39665 Data Science Center
Oracle Database Import (impdp) usando o utilitário DataPump
 
10:54
Olá, tudo bem? Philipe Brito da Base Treinamentos, seja muito bem vindo há mais um video aqui no nosso canal. E no vídeo de hoje vamos dar continuidade no video anterior e realizar uma importação utilizando o utilitário DataPump. Sem mais delongas, vamos ao vídeo. Site: http://basetreinamentos.com.br Facebook: https://www.facebook.com/basetreinamentos Scripts utilizados: https://pastebin.com/bbXmFT63 Video anterior Oracle Database Export: https://youtu.be/UZv15RSAdyM
Views: 91 Base Treinamentos
Oracle DBA Tutorials || online training || Data Pump part-2 by Shiva
 
30:28
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://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
How to use Datapump Logical Backups expdp and impdp Part 3
 
10:54
How To Perform An Oracle Logical Backups using expdp and impdp Explained Learn how easy it is to make $100k and above by becoming an Oracle Database Administrator. Website: https://newayitsolutions.com Subscribe: https://newayitsolutions.com/page Enroll: https://newayitsolutions.com/enroll Youtube: newayitsolutions ------------------------------------------------------------------------------------------------------------------------------------------------------------- Follow on Facebook: https://www.facebook.com/newayitsolutions/ Follow on Twitter: https://twitter.com/Theoracledbaguy Follow on Instagram: https://www.instagram.com/oracledbatrainer/ Financing Available: https://newayitsolutions.com/loan-application School Locations: Atlanta, Maryland, Virginia ------------------------------------------------------------------------------------------------------------------------------------------------------------- Office Contact: 1-866-569-0205 Mobile Contact: 240-244-9935
Provision Pluggable Database using Datapump with Enterprise Manager 12c
 
06:30
In this demo I show how to migrate and consolidate a non-cdb 11.2.0.3 to cdb environment using Enterprise Manager 12c. Check out my blog post on consolidating to Multitenant Architecture http://db12c.blogspot.com/2013/07/consolidating-to-oracle-12c-multitenant.html
Views: 314 Javier Ruiz
How to Implement TDE for Oracle 12c2 Container and pluggable databases
 
19:36
Setup Wallet: Modify the sqlnet.ora file ENCRYPTION_WALLET_LOCATION= (SOURCE= (METHOD=FILE) (METHOD_DATA= (DIRECTORY=Directory location\))) --set password based keystore - container level ADMINISTER KEY MANAGEMENT CREATE KEYSTORE 'C:\app\AkPC\admin\tdewallet\orcl' IDENTIFIED BY password; --set auto login keystore - container level ADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE FROM KEYSTORE 'C:\app\AkPC\admin\tdewallet\orcl' IDENTIFIED BY password; --open the keystore in root container ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY password; --set master key at root container level ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY password with backup; --open the keystore in pdb ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY password; --Set database master key in pdb ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY password with backup; CREATE TABLESPACE encrypted_ts DATAFILE 'C:\app\AkPC\oradata\orcl\orclpdb\encrypted_ts.dbf' SIZE 128K AUTOEXTEND ON NEXT 64K ENCRYPTION USING 'AES256' DEFAULT STORAGE(ENCRYPT); CREATE TABLESPACE unencrypted_ts DATAFILE 'C:\app\AkPC\oradata\orcl\orclpdb\unencrypted_ts.dbf' SIZE 128K AUTOEXTEND ON NEXT 64K; CREATE TABLE TEST_ENC (TEXT VARCHAR2(100)) TABLESPACE encrypted_ts; CREATE TABLE TEST_UNENC (TEXT VARCHAR2(100)) TABLESPACE unencrypted_ts; insert into TEST_ENC values ('This is a secret'); insert into TEST_UNENC values ('This is a secret');
Views: 909 SQL JUNKIESHARE
How to Export ( Expdp ) and Import ( Impdp ) Oracle Table using Datapump utility.
 
07:06
we can export ( expdp ) and import ( impdp ) Oracle table using datapump utility. we can use expdp for export and impdp for import. In this video i am showing you how to export Oracle table and how to import using Datapump utility. It is very easy to understand.
Views: 1107 Parag Mahalle
Creating Directory using CMD prompt
 
01:02
This video explains how we can create file directory using CMD prompt
Views: 858 GVSInfo Tube
How to Work with an External Oracle Database
 
10:04
At OutSystems we recognize that many applications need to be created using existing systems of record, rather than new data models. In this video, you'll see how to add a connection to an external Oracle database, create an OutSystems extension using Integration Studio to expose tables from the external database to your OutSystems applications, and how to use these tables to create screens in your applications. This How-To video is an extension of the course "Integrating with External Databases" which can be found at: https://www.outsystems.com/learn/courses/119/integrating-with-external-databases/
Views: 283 OutSystems
Oracle Upgrade, oracle 10g and oralce 11g to oracle 12c
 
08:28
SAP On Oracle Database Upgrade, From Oracle 10g to 12c Direct upgrade, ================================================= TAKE BACKUP OF EXISITNG DB brbackup -u / -p initGWP-disk-OFF.sap -d disk -t offline -m all -o time INSTALL ORACLE 12 DATA BASE - CHANGE THE HOME DIRECTORY PATH IN ENVIRONEMNT - Not to ADD FULL PERMISSION IN TO ORALCE INSTALLATION USER - TAKE A COPY OF OLD ORACLE & AND NEW ORACLE HOME BEFORE APPLYING PATCHES - TAKE COPY OF NETWORK\ADMIN AND DATABASE FOLDER - DOWNLOADED LATEST OPATCH AND REPLACE OPATCH FOLDER - APPYL NEEDED PATCHES USING OPATCHS - STOP ALL SERVICES ORACLE RELATED FOR APPLYINT PATCHES **PATCHBUNDLE12102P_1702-20012303.zip **PATCHBUNDLE12102P_1704-20012303.zip **P9584028GEN12102P_2-20012303.zip 'EG: B:\Patches\P9584028GEN12102P_2-20012303\9584028 C:\oracle\GWP\12102\OPatch\OPATCH APPLY' 'EG: B:\Patches\PATCHBUNDLE12102P_1702-20012303\25433286 E:\oracle\GWQ\12102\OPatch\OPATCH APPLY' "EG: B:\Patches\PATCHBUNDLE12102P_1704-20012303\25632533 E:\oracle\GWQ\12102\OPatch\OPATCH APPLY" -START SERVICES AFTER APPLYING PATCHES FOR UPGRADE. RUN THE PRE UPGRADE SCRIPT AS FOLLOWS.. PRE UPGRADE SCRIPT WILL PROVIDE YOU WHEN YOU UPDATE PATCHES ================================ OS sqlplus / as sysdba SQL @pre_upgrade_tasks.sql SQL @pre_upgrade_checks_ora.sql SQL @pre_upgrade_checks_sap.sql THEN CREATE RESTORE POINT FOR RECOVERY IF ANY FAILIUR HAPPEND */ ============================================================= /*(ALTER SYSTEM SET db_recovery_file_dest_size='10G G:\oracle\GWP\oraflash' scope=both; ALTER SYSTEM SET db_recovery_file_dest= 'E:\oracle\GWQ\oraflash scope=both';)*/ ------------------------------------------- SQL @grp_create_restore_point.sql SQL @grp_list_restore_point.sql ===TAKE BACKUP OF NETWORK/ADMIN & ORAHOME\DATABASE RUN DUBA from new home (oralce 12c) KEEP DATABSE OPEN FOR UPGRADE. ===================== CREATE RMAN BACKUP DURING THE UPGRADE \Post upgrade steps 1915315 - Database Upgrade Scripts for 12.1.0.2 ====================================================================== After DUB create Listner or check the listner status LSNRCTL/ Go to directory 'post_upgrade' to run the post-upgrade scripts. --SQL @?/rdbms/admin/utlu121s.sql --SQL @?/rdbms/admin/utluiobj.sql --SQL @post_upgrade_tasks.sql Recompile invalid objects --SQL @?/rdbms/admin/utlrp.sql Run post-upgrade checks --SQL @post_upgrade_checks.sql Check whether guaranteed restore point 'GRP_BEFORE_UPGRADE_12102' exists: OS cd NEW_ORACLE_HOME /sap/ora_upgrade/pre_upgrade OS sqlplus / as sysdba --SQL @grp_list_restore_point.sql you need to drop this restore point and set 'COMPATIBLE' to the new value. OS cd NEW_ORACLE_HOME /sap/ora_upgrade/pre_upgrade OS sqlplus / as sysdba --SQL @grp_drop_restore_point.sql OS cd NEW_ORACLE_HOME /sap/ora_upgrade/post_upgrade OS sqlplus / as sysdba --SQL @set_compatible.sql After setting compatible to a new value, 'RESTART THE DATABASE.' Ensure that parameter 'compatible' is set to '12.1.0.2.0' or '12.1.0.2': --SQL SHOW PARAMETER COMPATIBLE SQL show parameter compatible NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ compatible string 12.1.0.2.0 noncdb_compatible boolean FALSE --SQL SELECT VALUE "COMPATIBLE" FROM V$PARAMETER WHERE NAME = 'COMPATIBLE'; Before you start the remaining database post-upgrade tasks you can create a new guaranteed restore point ====================================================== --SQL CREATE RESTORE POINT "'GRP_AFTER_UPGRADE_12102'" GUARANTEE FLASHBACK DATABASE ; --SQL SELECT NAME FROM V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE = 'YES'; drop V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE = 'YES'; Check for invalid objects: =========================== --SQL select owner, object_name, object_type from dba_objects where status = 'INVALID'; If the object 'DBMS_METADATA' (package body) is still invalid (Ref: patch 17871192), run utlrp to recompile the package. ====================================================== --SQL @?\rdbms\admin\utlrp.sql --SQL select owner, object_name, object_type from dba_objects where status = 'INVALID'; COPY data from OLDorahome\database\ to new database\ FOLLOWING FILES INIT SID .SAP INIT SID .UTL update the kernel CHEK THE TNS FILE NAME IN NETWORK\ADMIN brconnect -u / -c -f stats -t system_stats brconnect -u / -c -f stats -t oradict_stats brconnect -u / -c -f stats -t all -f collect -p 4 deinstall the 11g /*if needed */{}{}{}{}{}{}{}{}{}{}{}{}{}{}{} ================= sqlplus / as sysdba @sapuprof_profile Insufficent privillege 134592 - Import of SAPDBA role (sapdba_role.sql) ========================== sqlplus /nolog @sapdba_role SAPSR3 --CHANGE PARAMTER ONCE UPGRADE COMPLETE. Visit My Blog:http://wrongcodes.blogspot.com/
Views: 325 SNOOPPY TV
Oracle Database 12c: Moving Online Data Files
 
04:07
About moving online data files Oracle Database 12c new feature, with examples.
Views: 5396 OracleDBVision