DBA FROM INDIA
DBA FROM INDIA
  • Видео 20
  • Просмотров 37 000
EXPDP/IMPDP PARAMETERS - QUERY || ORACLE DATABASE ADMINISTRATION|| DBA FROM INDIA
Hi Everyone
In the video I have explained about the QUERY PARAMETER OF EXPDP UTILITY in oracle database.
performed steps:
===============
select count(*) from ot.order_items where quantity -100;
COUNT(*)
----------
267
CREATE PARFILE
--------------------------
cat expdp_ot_table.par
dumpfile=Items_get_quantity_100.dmp
logfile=order_items_get_quantity_100.log
directory=EXP_OT
tables=OT.ORDER_ITEMS
QUERY=OT.ORDER_ITEMS:"where QUANTITY - 100"
[oracle@nodeone export]$ expdp parfile=expdp_ot_table.par
Export: Release 12.2.0.1.0 - Production on Thu Sep 22 01:43:44 2022
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Username: OT
Password:
Connected to: Oracle Database 12c Enterprise ...
Просмотров: 953

Видео

8. TEMPORARY TABLESPACE GROUP IN ORACLE DATABASE || ORACLE DATABASE ADMINISTRATION|| DBA FROM INDIA6:038. TEMPORARY TABLESPACE GROUP IN ORACLE DATABASE || ORACLE DATABASE ADMINISTRATION|| DBA FROM INDIA
8. TEMPORARY TABLESPACE GROUP IN ORACLE DATABASE || ORACLE DATABASE ADMINISTRATION|| DBA FROM INDIA
Просмотров 6532 года назад
Hi Everyone In the video I have explained about the TEMPORARY TABLESPACE GROUPS creation in oracle database. performed steps: TEMPORARY TABLESPACE GROUPS select tablespace_name, group_name from DBA_TABLESPACE_GROUPS; CREATE TEMPORARY TABLESPACE GROUP CREATE TEMPORARY TABLESPACE temp01 TEMPFILE '/u02/PROD/db_files/PROD/temp01_01.dbf' SIZE 50M autoextend on next 512K maxsize 200M TABLESPACE GROUP...
7. TEMPORARY TABLESPACE IN ORACLE DATABASE || ORACLE DATABASE ADMINISTRATION || DBA FROM INDIA4:507. TEMPORARY TABLESPACE IN ORACLE DATABASE || ORACLE DATABASE ADMINISTRATION || DBA FROM INDIA
7. TEMPORARY TABLESPACE IN ORACLE DATABASE || ORACLE DATABASE ADMINISTRATION || DBA FROM INDIA
Просмотров 1,4 тыс.2 года назад
Hi Everyone In the video I have explained about the TEMPORARY TABLESPACE creation in oracle database. performed steps: CREATE TEMPORARY TABLESPACE CREATE TEMPORARY TABLESPACE TEMP_NEW TEMPFILE '/u02/PROD/db_files/PROD/temp_new01.dbf' SIZE 50M autoextend on next 512K maxsize 200M; ADD TEMPFILE TO A TEMPORARY TABLESPACE alter tablespace TEMP_NEW add tempfile '/u02/PROD/db_files/PROD/temp_new02.db...
6.RENAME DATAFILE IN ORACLE DATABASE || ORACLE TABLESPACE MANAGEMENT || DBA FROM INDIA ||5:596.RENAME DATAFILE IN ORACLE DATABASE || ORACLE TABLESPACE MANAGEMENT || DBA FROM INDIA ||
6.RENAME DATAFILE IN ORACLE DATABASE || ORACLE TABLESPACE MANAGEMENT || DBA FROM INDIA ||
Просмотров 9942 года назад
Hi Everyone In the video I have explained about renaming datafile in oracle database. performed steps: SQL @db NAME OPEN_MODE DATABASE_ROLE PROD READ WRITE PRIMARY SQL select tablespace_name,file_name from dba_data_files; TABLESPACE_NAME FILE_NAME SYSTEM /u02/PROD/db_files/PROD/system 01.dbf SYSAUX /u02/PROD/db_files/PROD/sysaux 01.dbf TB1 /u01/PROD/db_files/PROD/TB101. dbf USERS /u02/PROD/db_f...
5.RESIZE DATAFILE IN ORACLE DATABASE || ORACLE TABLESPACE MANAGEMENT || DBA FROM INDIA ||2:575.RESIZE DATAFILE IN ORACLE DATABASE || ORACLE TABLESPACE MANAGEMENT || DBA FROM INDIA ||
5.RESIZE DATAFILE IN ORACLE DATABASE || ORACLE TABLESPACE MANAGEMENT || DBA FROM INDIA ||
Просмотров 1,7 тыс.2 года назад
Hi Everyone In the video I have explained about resizing the datafile of an existing tablespace in oracle database. performed steps: RESIZE DATAFILE: alter database datafile '/u01/PROD/db_files/PROD/TB101.dbf' resize 100M; LIKE SHARE AND SUBSCRIBE follow the below videos as well. #postgresql ruclips.net/p/PLS_2aktHD3qKU2I9CN18nNl0p7TfMswei #oracledba ruclips.net/p/PLS_2aktHD3qJA7mGJo1E3T-FqbaUQ...
4.CREATE TABLESPACE ON ORACLE DATABASE || ORACLE DATABASE ADMIN || ORACLE 12C || DBA FROM INDIA10:124.CREATE TABLESPACE ON ORACLE DATABASE || ORACLE DATABASE ADMIN || ORACLE 12C || DBA FROM INDIA
4.CREATE TABLESPACE ON ORACLE DATABASE || ORACLE DATABASE ADMIN || ORACLE 12C || DBA FROM INDIA
Просмотров 1,2 тыс.2 года назад
Hi Everyone In the video I have explained about the TABLESPACE creation in oracle database. performed steps: CREATE TABLESPACE: create tablespace TB1 datafile '/u01/PROD/db_files/PROD/TB101.dbf' size 50M autoextend on next 512K maxsize 250M; ADD DATAFILE TO THE EXISTING TABLESPACE ALTER TABLESPACE TB1 ADD DATAFILE '/u01/PROD/db_files/PROD/TB102.dbf' size 50M autoextend on next 512K maxsize 250M...
3.ORACLE TABLESPACE ONLINE/OFFLINE || ORACLE DATABASE ADMINISTRATION || ORACLE 12C | DBA FROM INDIA3:373.ORACLE TABLESPACE ONLINE/OFFLINE || ORACLE DATABASE ADMINISTRATION || ORACLE 12C | DBA FROM INDIA
3.ORACLE TABLESPACE ONLINE/OFFLINE || ORACLE DATABASE ADMINISTRATION || ORACLE 12C | DBA FROM INDIA
Просмотров 1,2 тыс.2 года назад
Hi Everyone In the video I have explained about the ONLINE AND OFFLINE TABLESPACES of ORACLE DATABASE. It is an introduction of the default tablespaces and their role in oracle database. LIKE SHARE AND SUBSCRIBE follow the below videos as well. #postgresql ruclips.net/p/PLS_2aktHD3qKU2I9CN18nNl0p7TfMswei #oracledba ruclips.net/p/PLS_2aktHD3qJA7mGJo1E3T-FqbaUQUPNd #exportimport ruclips.net/p/PLS...
2. DEFAULT TABLESPACES IN ORACLE DATABASE || ORACLE DBA|| TABLESPACES || DBA FROM INDIA5:062. DEFAULT TABLESPACES IN ORACLE DATABASE || ORACLE DBA|| TABLESPACES || DBA FROM INDIA
2. DEFAULT TABLESPACES IN ORACLE DATABASE || ORACLE DBA|| TABLESPACES || DBA FROM INDIA
Просмотров 1,6 тыс.2 года назад
Hi Everyone In the video I have explained about the DEFAULT TABLESPACES of ORACLE DATABASE. It is an introduction of the default tablespaces and their role in oracle database. LIKE SHARE AND SUBSCRIBE follow the below videos as well. #postgresql ruclips.net/p/PLS_2aktHD3qKU2I9CN18nNl0p7TfMswei #oracledba ruclips.net/p/PLS_2aktHD3qJA7mGJo1E3T-FqbaUQUPNd #exportimport ruclips.net/p/PLS_2aktHD3qJ0...
1. INTRODUCTION TO TABLESPACE ON ORACLE DATABASE || LOGICAL & PHYSICAL STRUCTURE || DBA FROM INDIA10:441. INTRODUCTION TO TABLESPACE ON ORACLE DATABASE || LOGICAL & PHYSICAL STRUCTURE || DBA FROM INDIA
1. INTRODUCTION TO TABLESPACE ON ORACLE DATABASE || LOGICAL & PHYSICAL STRUCTURE || DBA FROM INDIA
Просмотров 4,2 тыс.2 года назад
Hi Everyone In the video I have explained about the TABLESPACE of ORACLE DATABASE. It is an introduction how data gets stored over tablespaces in Oracle Database. LIKE SHARE AND SUBSCRIBE follow the below videos as well. #postgresql ruclips.net/p/PLS_2aktHD3qKU2I9CN18nNl0p7TfMswei #oracledba ruclips.net/p/PLS_2aktHD3qJA7mGJo1E3T-FqbaUQUPNd #exportimport ruclips.net/p/PLS_2aktHD3qJ0Nv0l0gbDPdd9O...
2. WHAT IS PAGE IN POSTGRESQL || DBA FROM INDIA|| POSTGRESSQL||5:142. WHAT IS PAGE IN POSTGRESQL || DBA FROM INDIA|| POSTGRESSQL||
2. WHAT IS PAGE IN POSTGRESQL || DBA FROM INDIA|| POSTGRESSQL||
Просмотров 2432 года назад
Hi Everyone In this video I have given one small introduction about PAGE in PostgreSQL database. Keep an eye on this series will proceed with the practical approaches in upcoming videos. LIKE SHARE SUBSCRIBE
1. INTRODUCTION TO POSTGRESQL || DBA FROM INDIA || #postgresql #postgres #database #dba3:011. INTRODUCTION TO POSTGRESQL || DBA FROM INDIA || #postgresql #postgres #database #dba
1. INTRODUCTION TO POSTGRESQL || DBA FROM INDIA || #postgresql #postgres #database #dba
Просмотров 1662 года назад
Hi Everyone In this video I have given one small introduction about PostgreSQL database. Keep an eye on this series will proceed with the practical approaches in upcoming videos. LIKE SHARE SUBSCRIBE
2. HOW TO PERFORM SWITCHBACK || ACTIVE DATAGUARD || ORACLE 12C || DBA FROM INDIA9:502. HOW TO PERFORM SWITCHBACK || ACTIVE DATAGUARD || ORACLE 12C || DBA FROM INDIA
2. HOW TO PERFORM SWITCHBACK || ACTIVE DATAGUARD || ORACLE 12C || DBA FROM INDIA
Просмотров 3412 года назад
Hi There In this video I have tried to explain about the manual switchback activity in ACTIVE DATA GUARD environment. Below are given steps. If you find this video helpful LIKE SHARE & SUBSCRIBE SWITCH BACK PRECHECKS : nodeone: select name,open_mode,database_role from v$database; nodetwo: select name,open_mode,database_role from v$database; nodetwo : select STATUS, GAP_STATUS from V$ARCHIVE_DES...
1. HOW TO PERFORM SWITCHOVER || ACTIVE DATAGUARD || ORACLE 12C || DBA FROM INDIA13:211. HOW TO PERFORM SWITCHOVER || ACTIVE DATAGUARD || ORACLE 12C || DBA FROM INDIA
1. HOW TO PERFORM SWITCHOVER || ACTIVE DATAGUARD || ORACLE 12C || DBA FROM INDIA
Просмотров 9332 года назад
Hi There In this video I have tried to explain about the manual switchover activity in ACTIVE DATA GUARD environment. Below are given steps. If you find this video helpful LIKE SHARE & SUBSCRIBE Perform Manual Switchover on Physical Standby 1 . Check primary and standby for any gaps On primary: SQL- select GAP_STATUS from V$ARCHIVE_DEST_STATUS where DEST_ID =2; On standby: SQL - select NAME, VA...
HOW TO TAKE FULL DATABASE BACKUP USING EXPDP || ORACLE 12C || ORACLE DBA || DBA FROM INDIA9:00HOW TO TAKE FULL DATABASE BACKUP USING EXPDP || ORACLE 12C || ORACLE DBA || DBA FROM INDIA
HOW TO TAKE FULL DATABASE BACKUP USING EXPDP || ORACLE 12C || ORACLE DBA || DBA FROM INDIA
Просмотров 1,6 тыс.2 года назад
Hi There In this video I have tried to explain how to take FULL database backup using #EXPDP utility in Oracle Database in 2 methods. And before taking any backup we must see how much space it may occupies. Below are the performed steps over the video. FULL DATABASE BACKUP USING EXPDP UTILITY: alias sql='sqlplus / as sysdba' alias c='clear' alias pmon='ps -ef | grep -i pmon' CREATE OR REPLACE D...
HOW TO REFRESH SCHEMA USING EXPDP/IMPDP || ORACLE 12C || EXPDP IMPDP UTILITY || DBA FROM INDIA10:02HOW TO REFRESH SCHEMA USING EXPDP/IMPDP || ORACLE 12C || EXPDP IMPDP UTILITY || DBA FROM INDIA
HOW TO REFRESH SCHEMA USING EXPDP/IMPDP || ORACLE 12C || EXPDP IMPDP UTILITY || DBA FROM INDIA
Просмотров 4,4 тыс.2 года назад
Hi There In this video I have tried to explain about the schema refresh activity using expdp impdp utility of oracle. Below are given steps. If you find this video helpful LIKE SHARE & SUBSCRIBE. PLAN 1. CREATE TABLESPACE 2. CREATE AN USER 3. GIVE QUOTA TO THE USER ON THE TABLESPACE 4. IMPORT THE EPORT BACKUP TO THE NEW USER STEPS: GET DDL: select username,account_status from dba_users where us...
HOW TO PERFORM BACKUP AND RESTORE USING EXPDP/IMPDP UTILITY|| ORACLE 12C || DBA FROM INDIA14:13HOW TO PERFORM BACKUP AND RESTORE USING EXPDP/IMPDP UTILITY|| ORACLE 12C || DBA FROM INDIA
HOW TO PERFORM BACKUP AND RESTORE USING EXPDP/IMPDP UTILITY|| ORACLE 12C || DBA FROM INDIA
Просмотров 7 тыс.2 года назад
HOW TO PERFORM BACKUP AND RESTORE USING EXPDP/IMPDP UTILITY|| ORACLE 12C || DBA FROM INDIA
HOW TO PERFORM BACKUP & RESTORE & RECOVERY|| ORACLE 12C || RMAN BACKUP RESTORE & RECOVERY ||13:22HOW TO PERFORM BACKUP & RESTORE & RECOVERY|| ORACLE 12C || RMAN BACKUP RESTORE & RECOVERY ||
HOW TO PERFORM BACKUP & RESTORE & RECOVERY|| ORACLE 12C || RMAN BACKUP RESTORE & RECOVERY ||
Просмотров 5 тыс.2 года назад
HOW TO PERFORM BACKUP & RESTORE & RECOVERY|| ORACLE 12C || RMAN BACKUP RESTORE & RECOVERY ||
HOW TO DROP DATABASE USING DBCA || ORACLE 19C || WINDOWS 10 || DBA FROM INDIA3:24HOW TO DROP DATABASE USING DBCA || ORACLE 19C || WINDOWS 10 || DBA FROM INDIA
HOW TO DROP DATABASE USING DBCA || ORACLE 19C || WINDOWS 10 || DBA FROM INDIA
Просмотров 3113 года назад
HOW TO DROP DATABASE USING DBCA || ORACLE 19C || WINDOWS 10 || DBA FROM INDIA
HOW TO ENABLE AND DISABLE ARCHIVELOG MODE IN ORACLE DATABASE || ORACLE 19C || DBA FROM INDIA4:14HOW TO ENABLE AND DISABLE ARCHIVELOG MODE IN ORACLE DATABASE || ORACLE 19C || DBA FROM INDIA
HOW TO ENABLE AND DISABLE ARCHIVELOG MODE IN ORACLE DATABASE || ORACLE 19C || DBA FROM INDIA
Просмотров 3663 года назад
HOW TO ENABLE AND DISABLE ARCHIVELOG MODE IN ORACLE DATABASE || ORACLE 19C || DBA FROM INDIA
CREATING PLUGGABLE (PDB) DATABASE IN ORACLE 19C USING DBCA || WINDOWS 10 || DBA FROM INDIA ||3:59CREATING PLUGGABLE (PDB) DATABASE IN ORACLE 19C USING DBCA || WINDOWS 10 || DBA FROM INDIA ||
CREATING PLUGGABLE (PDB) DATABASE IN ORACLE 19C USING DBCA || WINDOWS 10 || DBA FROM INDIA ||
Просмотров 2,1 тыс.3 года назад
CREATING PLUGGABLE (PDB) DATABASE IN ORACLE 19C USING DBCA || WINDOWS 10 || DBA FROM INDIA ||

Комментарии

  • @ashishtayade047
    @ashishtayade047 14 часов назад

    Thank you sir very nice gide & very nice best explain oracle tablespace online and offline oracle database administration oracle 12c DBA from india teaching video.👍

  • @ashishtayade047
    @ashishtayade047 День назад

    Thank you sir very nice gide & very nice explain introduction to tablespace on oracle database teaching video.👍

  • @GeorgeLep-t3s
    @GeorgeLep-t3s 2 месяца назад

    I've watched many tutorials on how to create pdb it wasn't that good compared to yours ,please do more videos

  • @dilrubakhatoon7461
    @dilrubakhatoon7461 3 месяца назад

    Thankyou for sharing

  • @ExploreLife1440
    @ExploreLife1440 3 месяца назад

    Why such a low quality videos? if possible upscale them and reupload :)

  • @priyankapaul7077
    @priyankapaul7077 5 месяцев назад

    Sir how to make that prod database?

  • @ericksonezekiel4104
    @ericksonezekiel4104 5 месяцев назад

    nice demo bro

  • @insanesamgaming4704
    @insanesamgaming4704 10 месяцев назад

    This same steps work in Oracle 19c also ??

  • @danduvenky2053
    @danduvenky2053 Год назад

    Supperb demo

  • @nguyenhuubut3026
    @nguyenhuubut3026 Год назад

    Why do I have to move the file first before altering runs? Sorry for my poor English

  • @subakhank4495
    @subakhank4495 Год назад

    Appreciation for your efforts bro thanks

  • @yantrapragadaaneshteja5272
    @yantrapragadaaneshteja5272 Год назад

    your explanation too good and can you suggest me how to export and import from one server database to another server database.

  • @Atursingh
    @Atursingh Год назад

    sir kindly create video undo table and temp video and different

  • @mehtabkhan4911
    @mehtabkhan4911 Год назад

    Can u give me ?

  • @mehtabkhan4911
    @mehtabkhan4911 Год назад

    Bro mujhe script chahiye jo ap used krte ho

    • @dbafromindia5388
      @dbafromindia5388 Год назад

      Kindly check the description, already provided whichever I executed ☺️

  • @mehtabkhan4911
    @mehtabkhan4911 2 года назад

    Bro where are you from ✨ ?

  • @mehtabkhan4911
    @mehtabkhan4911 2 года назад

    Nice yrr

  • @khanmustufamaroof1568
    @khanmustufamaroof1568 2 года назад

    Thank u for this

  • @PraveenKumar-es7hh
    @PraveenKumar-es7hh 2 года назад

    Hii bro please explain architecture

  • @rajununna6939
    @rajununna6939 2 года назад

    Excellent and vey clear demo ..Thank you very much..!!!

  • @pepethebee2762
    @pepethebee2762 2 года назад

    Thank you so much.

  • @mahmoodalnabhani7979
    @mahmoodalnabhani7979 2 года назад

    Thanks, nice 👍🏻

  • @padmajarani9392
    @padmajarani9392 2 года назад

    Thank u sir

  • @khanmustufamaroof1568
    @khanmustufamaroof1568 2 года назад

    Hi bro You have any telegram channel or whatsapp group ?

  • @chhayabhoyar5469
    @chhayabhoyar5469 2 года назад

    All videos are very easy to understand of oracle. Can you please prepare more video's of it like Dataguard configuratin, lag issue, real time backup issue'.

    • @dbafromindia5388
      @dbafromindia5388 2 года назад

      Thanks for the feedback 👍, definitely I'll come with the topics stay tuned.

  • @khanmustufamaroof1568
    @khanmustufamaroof1568 2 года назад

    Hey hi New subscriber thank you for all the videoss you doing great work Just want to say change text colour and text Size 🧡🧡

  • @SureshKumar-no3eo
    @SureshKumar-no3eo 2 года назад

    nice videos..

  • @dbafromindia5388
    @dbafromindia5388 2 года назад

    My apology for the mic issue.

  • @awmsubham3964
    @awmsubham3964 2 года назад

    Explain expdp parameters

  • @javiervazquezgomez7866
    @javiervazquezgomez7866 2 года назад

    Buen video, muy útil e informativo. Viva España y a rockear siempre.