Home
Search results “Oracle temp dbf”
Oracle Database Tutorial 65: How to create temporary tablespace in oracle database
 
05:55
Learn How to create big file and small file temporary tablespace in oracle database by Manish Sharma RebellionRider Follow Me on Twitter @RebellionRider and Instagram "RebellionRider" ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : Previous Tutorial ► Permanent Tablespace https://youtu.be/vkwKZIssvfc ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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 for E-mail address please check About section 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: 14572 Manish Sharma
how to manual database creation on oracle 11g
 
18:53
how to manual database creation parameter file -- ------------------------------------------------------------------ db_name=TEST Instance_name=TEST Control_files='/u01/home/TEST/control01.ctl' Db_block_size=8192 Undo_management='auto' Undo_tablespace=undotbs1 Undo_retention=900 Compatible=11.2.0 Memory_max_target=400m Memory_target=300m Log_buffer=100 Workarea_size_policy=auto Diagnostic_dest='/u01/home/TEST/diag' ----------------------------------------------------------------------- control file -- --------------------------------------------------------------- CREATE DATABASE TEST user sys identified by oracle user system identified by oracle logfile group 1 ('/u01/home/TEST/redo01.log') size 50m, group 2 ('/u01/home/TEST/redo02.log') size 50m, group 3 ('/u01/home/TEST/redo03.log') size 50m maxlogfiles 5 maxlogmembers 5 maxloghistory 50 maxdatafiles 100 maxinstances 1 datafile '/u01/home/TEST/system01.dbf' size 100m autoextend on sysaux datafile'/u01/home/TEST/sysaux01.dbf' size 100m autoextend on default tablespace users datafile '/u01/home/TEST/users01.dbf' size 100m autoextend on default temporary tablespace temp tempfile '/u01/home/TEST/temp01.dbf' size 50m undo tablespace undotbs1 datafile '/u01/home/TEST/undotbs01.dbf' size 200m; ------------------------------------------------------------------------------ script -- -------------------------------------------------------------------------- @$ORACLE_HOME/rdbms/admin/catalog.sql @$ORACLE_HOME/rdbms/admin/catproc.sql connect system/oracle @$ORACLE_HOME/sqlplus/admin/pupbld.sql -----------------------------------------------------------------------------
Views: 1560 Cocktail Video
RECOVER LOST  DataFile
 
15:33
DATAFILE file Lost ================================ Archive log mode-Enabled create tablespace test_ts datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' size 10M; create table testtable (id number(5))tablespace test_ts; insert into testtable (id) select * from testtable; SQL>select count(*) from testtable; COUNT(*) ---------- - before deleting datafile 524288 SQL>select count(*) from testtable; COUNT(*) ---------- - After recovery 524288 select tablespace_name, segment_name from dba_segments where segment_name = 'TESTTABLE'; alter system flush buffer_cache; alter database create datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' as '/u01/app/oracle/oradata/testdb/ts_test02.dbf' alter database datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' offline drop; alter database create datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' as '/u01/app/oracle/oradata/testdb/ts_test02.dbf' recover datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf'; alter database datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' online; select count(*) from TESTTABLE; =================================================== Please like,subscribe my channel. Kindly contact for online training on below contacts. Emai: [email protected] Mob No: +91 9960262955 ====================================================== 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: 811 ANKUSH THAVALI
Instalación Oracle Express 11g & SQLdeveloper  **Creación de TABLESPACE, DATAFILE, USER**
 
10:06
Holaaa! Muchas gracias por ver el vídeo, no olvides dejar tu like si te ha gustado y suscribete si te gusta mi contenido :) ME PUEDES ENCONTRAR EN➨ 🔥 INSTAGRAM https://www.instagram.com/charliesannz/ Oracle Database Express Edition 11: http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html Oracle sql-develope: http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html ---CODIGO EN SQL DEVELOPER--- --CREAR TABLESPACE CREATE TABLESPACE "BASEDATOSTABLA" DATAFILE 'C:\oraclexe\app\oracle\Pruebafinal.DBF' SIZE 200M; --TABLESPACE TEMPORAL CREATE TEMPORARY TABLESPACE "BASEDATOSTABLA" TEMPFILE 'C:\oraclexe\app\oracle\Pruebafinal_TEMP.DBF' SIZE 200M; --DBA CREATE ROLE ADMI; --Dar Permisos a los DBD GRANT CREATE SESSION TO ADMI; GRANT CREATE ANY TABLE TO ADMI; GRANT CREATE ROLE TO ADMI; GRANT CREATE USER TO ADMI; GRANT CREATE VIEW TO ADMI; GRANT CREATE ANY INDEX TO ADMI; GRANT CREATE TRIGGER TO ADMI; GRANT CREATE PROCEDURE TO ADMI; GRANT CREATE SEQUENCE TO ADMI; --CREAR USUARIO CREATE USER NOM_USUA IDENTIFIED BY CONTRA_USUA DEFAULT TABLESPACE BASEDATOSTABLA TEMPORARY TABLESPACE BASEDATOSTABLA_TEMP; --DAR PERMISOS AL USUARIO "ADMI" SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO NUEVOUSUARIO_BD; --INVERTIR "ADMI" A COLECCIONES GRANT ADMI TO NUEVOUSUARIO_BD;
Views: 145 Sanz
OracleDBに新規で表領域/スキーマを作成する方法/IT0018
 
09:41
●説明)0.概説 0-1.前回までのおさらい&今回の概要 (0:00) 0-2.データベースファイル&表領域とは? (0:44) 0-2-1.データベースファイルとは? (0:44)  ・物理的な記憶域単位(物理ファイル)  ・OSの中にある物理ファイルで、拡張子".dbf"である  ・表領域に紐づき、場合により複数のdbfが表領域に紐づく  ・TABLEやINDEXのデータが入っている  ・自動拡張や容量の設定などを実施できる 0-2-2.表領域とは? (1:46)  ・論理的な記憶域単位  ・表やインデックスなどオブジェクトを論理的にグルーピングしてる  ・バックアップの単位(例:人事用表領域、商品用表領域) ●実演)1.表領域の作成 (3:22) ~【作業場所:Oracle DB】~~~ --表領域作成 CREATE TABLESPACE [表領域の名前] DATAFILE '/u01/app/oracle/oradata/orcl/rbweg.dbf' SIZE 2M; --作成確認 SELECT * FROM DBA_TABLESPACES; ~【作業場所:DBサーバ(OS)】~~ --作成確認 $ cd /u01/app/oracle/oradata/orcl/ $ ls -la ~~~~~~~~~~~~~~~~ ●実演)2.スキーマの作成 (5:24) オブジェクトを置く空間のようなもの(自分のマンションの部屋のような)。 各ユーザの所有するオブジェクトがスキーマに配置される。 ~【作業場所:Oracle DB 】~~~ --スキーマ作成 CREATE USER [スキーマの名前] IDENTIFIED BY [各自のパスワード] DEFAULT TABLESPACE RBWEGTBS TEMPORARY TABLESPACE TEMP; ~~~~~~~~~~~~~~~~ ●実演)3.スキーマの接続権限を付与 (7:16) スキーマに接続するためGRANTでセッション確立権限を付与する必要有り。 ~【作業場所:Oracle DB 】~~~ --接続権限付与 GRANT CONNECT, RESOURCE TO [スキーマの名前] ~~~~~~~~~~~~~~~~
Descarga-Instalación ORACLE Express 11g, SQLdeveloper  ||  CREAR TABLESPACE -DATAFILE- USER -PASS.
 
09:03
ORACLE :http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html SQL Developer: http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html CODIGO EN SQL DEVELOPER --CREAR TABLESPACE CREATE TABLESPACE "TSTABLA" DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\PRUEBITA.DBF' SIZE 200M; --TABLESPACE TEMPORAL CREATE TEMPORARY TABLESPACE "TSTABLA_TEMP" TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\PRUEBITA_TEMP.DBF' SIZE 200M; --DBA CREATE ROLE ADMINISTRADOR_BD; --Dar Permisos a rol GRANT CREATE SESSION TO ADMINISTRADOR_BD; GRANT CREATE ANY TABLE TO ADMINISTRADOR_BD; GRANT CREATE ROLE TO ADMINISTRADOR_BD; GRANT CREATE USER TO ADMINISTRADOR_BD; GRANT CREATE VIEW TO ADMINISTRADOR_BD; GRANT CREATE ANY INDEX TO ADMINISTRADOR_BD; GRANT CREATE TRIGGER TO ADMINISTRADOR_BD; GRANT CREATE PROCEDURE TO ADMINISTRADOR_BD; GRANT CREATE SEQUENCE TO ADMINISTRADOR_BD; --CREAR USUARIO CREATE USER USER_BD IDENTIFIED BY PASSWORD_BD DEFAULT TABLESPACE TSTABLA TEMPORARY TABLESPACE TSTABLA_TEMP; --DAR PERMISOS AL USUARIO ADMINISTRADOR_BD SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO USER_BD; --VOLCAR ADMINISTRADOR_BD A COLECCIONES GRANT ADMINISTRADOR_BD TO USER_BD; ASTUDILLO SÁNCHEZ DANTEE MAURICIO 4-2
Views: 262 Dantee Astudillo
Descarga-Instalación ORACLE Express 11g, SQLdeveloper || CREAR TABLESPACE -DATAFILE- USER
 
11:09
Espero les guste amigos y les sirva de ejemplo en su creación de tablespaces, datafiles, usuario y contraseña. Aquí les dejo el script del código para poder crearlos: CREATE TABLESPACE PERSONA_DATAejem DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\Personadataejem.DBF' SIZE 200M; CREATE TEMPORARY TABLESPACE PERSONA_TEMP TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\Personatemp.DBF' SIZE 200M; CREATE TABLESPACE PERSONA_INDEX DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\Personaind.DBF' SIZE 200M; SELECT * FROM DBA_DATA_FILES; CREATE ROLE ADMINISTRADOR_BD; --Dar Permisos a rol GRANT CREATE SESSION TO ADMINISTRADOR_BD; GRANT CREATE ANY TABLE TO ADMINISTRADOR_BD; GRANT CREATE ROLE TO ADMINISTRADOR_BD; GRANT CREATE USER TO ADMINISTRADOR_BD; GRANT CREATE VIEW TO ADMINISTRADOR_BD; GRANT CREATE ANY INDEX TO ADMINISTRADOR_BD; GRANT CREATE TRIGGER TO ADMINISTRADOR_BD; GRANT CREATE PROCEDURE TO ADMINISTRADOR_BD; GRANT CREATE SEQUENCE TO ADMINISTRADOR_BD; --CREAR USUARIO CREATE USER PERSONA_BD IDENTIFIED BY PERSONA_BD DEFAULT TABLESPACE PERSONA_DATAejem TEMPORARY TABLESPACE PERSONA_TEMP; --DAR PERMISOS AL USUARIO ADMINISTRADOR_BD SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO PERSONA_BD; --VOLCAR ADMINISTRADOR_BD A COLECCIONES GRANT ADMINISTRADOR_BD TO PERSONA_BD;
Views: 25 kevin surf
TABLESPACE MANAGEMENT BIGFILE TABLESPACE RESIZING TABLESPACE TEMPORARY TABLESPACE GROUP RENAMING TAB
 
03:52
HOW TO RENAME A TABLESPACE =========================== alter tablespace king rename to king1; 10G FEATURES ON TABLESPACES 1)HOW TO CREATE BIGFILE TABLESPACE ================================== create bigfile tablespace king_big datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\king_big.dbf' size 20m; 2)HOW TO RESIZE A BIGFILE TABLESPACE ==================================== alter tablespace king_big resize 40m; 3)HOW TO CREATE TEMPORARY TABLESPACE GROUP ========================================== create temporary tablespace king_temp tempfile 'E:\DATABASE\DATABASE\ORADATA\ORCL\king_temp.dbf' size 20m tablespace group group1; select * from dba_tablespace_groups;
Views: 703 Praveen Biyyapu
Installing CentOS7/OracleXE18C/APEX/NODE4RDS (Beginners)
 
21:53
Oracle APEX is a great user friendly platform for development of robust web apps. Having a local setup is a good way to develop APEX apps and have them ready to just be imported to a production environment The video is meant for people new to installing these technologies. It should not be applied to production environments as I've taken steps to simplify things that have a negative effect on security, such as turning off the firewall and disabling selinux. I used VMware as it was available to me, however, same concepts should apply to using Oracle virtual box. It's just slightly trickier to get the networking sorted on vbox. Timestamps: 0:00 Creating the VM 1:34 Installing CentOS and Prep 7:35 Install Oracle 18c XE 11:30 Install APEX 15:30 Install ORDs 18:50 Install node4ords Links: ============================================== Vmware: https://www.vmware.com/ca/products/workstation-player/workstation-player-evaluation.html CentOS: https://www.centos.org/download/ Putty: https://www.putty.org/ WinSCP: https://winscp.net/eng/download.php JAVA JDK: https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html Tomcat: https://tomcat.apache.org/download-90.cgi sqlcl: https://www.oracle.com/database/technologies/appdev/sqlcl.html XE: Preinstall: curl -o oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html APEX: https://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html Commands: ============================================== ------------------------------------------------------------ yum update yum install nano systemctl disable firewalld nano /etc/selinux/config yum install git ------------------------------------------------------------ copy all to /tmp ------------------------------------------------------------ yum localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm yum localinstall oracle-database-xe-18c-1.0-1.x86_64.rpm nano /etc/init.d/oracle-xe-18c -remove -emConfiguration flags for enterprise manager /etc/init.d/oracle-xe-18c configure systemctl enable oracle-xe-18c systemctl start oracle-xe-18c ------------------------------------------------------------ cd /opt tar xzf /tmp/jdk-8u191-linux-x64.tar.gz tar xzf /tmp/apache-tomcat-9.0.12.tar.gz unzip /tmp/sqlcl-18.3.0.259.2029.zip unzip /tmp/apex_18.2_en.zip mkdir /opt/ords cd /opt/ords unzip /tmp/ords-18.3.0.270.1456.zip mkdir /opt/ords/conf export JAVA_HOME=/opt/jdk1.8.0_191 cd /opt/apex /opt/sqlcl/bin/sql sys/[email protected]:1521/XEPDB1 as sysdba CREATE TABLESPACE apex DATAFILE '/opt/oracle/oradata/XE/XEPDB1/apex01.dbf' SIZE 100M AUTOEXTEND ON NEXT 1M; @apexins.sql APEX APEX TEMP /i/ @apxchpwd.sql @apex_rest_config.sql ALTER USER APEX_PUBLIC_USER IDENTIFIED BY "Abcd1234!" ACCOUNT UNLOCK; ALTER USER ORDS_PUBLIC_USER IDENTIFIED BY "Abcd1234!" ACCOUNT UNLOCK; mkdir /ords mkdir /ords/apex_images mkdir -p /var/www useradd tomcat nano /home/tomcat/.bash_profile export JAVA_HOME=/opt/jdk1.8.0_191 export CATALINA_HOME=/opt/apache-tomcat-9.0.12 export CATALINA_BASE=$CATALINA_HOME export ORACLE_SID=XE export ORACLE_BASE=/opt/oracle export ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE export PATH=$PATH:$ORACLE_HOME/bin chown -R tomcat /opt/apache-tomcat-9.0.12/ chown -R tomcat /opt/jdk1.8.0_191/ chown -R tomcat /opt/ords/ chown -R tomcat /ords su - tomcat cd /opt/ords $JAVA_HOME/bin/java -jar ords.war /opt/ords/conf mkdir $CATALINA_HOME/webapps/i/ cp -R /opt/apex/images/* $CATALINA_HOME/webapps/i/ cp -R /opt/apex/images/* /ords/apex_images cp /opt/ords/ords.war $CATALINA_HOME/webapps/ nano /etc/systemd/system/tomcat.service [Unit] Description=Apache Tomcat 8 Servlet Container After=syslog.target network.target [Service] User=tomcat Group=tomcat Type=forking Environment=CATALINA_PID=/opt/apache-tomcat-9.0.12/tomcat.pid Environment=CATALINA_HOME=/opt/apache-tomcat-9.0.12 Environment=CATALINA_BASE=/opt/apache-tomcat-9.0.12 Environment=JAVA_HOME=/opt/jdk1.8.0_191 ExecStart=/opt/apache-tomcat-9.0.12/bin/startup.sh ExecStop=/opt/apache-tomcat-9.0.12/bin/shutdown.sh Restart=on-failure SuccessExitStatus=143 [Install] WantedBy=multi-user.target systemctl daemon-reload systemctl start tomcat systemctl enable tomcat yum install epel-release yum install nodejs cd /opt git clone https://github.com/OraOpenSource/node4ords.git cd /opt/node4ords npm i -g pm2 npm install --unsafe-perm pm2 start app.js --name="node4ords" --watch pm2 stop app.js --name="node4ords" pm2 save
Views: 31 Hisham Shoblaq
Part 17 - Databases  - Temp Tables
 
18:14
- Introduction to Temp Tables -- Local Temp Tables (#) -- Global Temp Tables (##) -- Table Variables (@) - User Defined Types - Passing Table valued Parameter - sp_help Stored Procedure - GO statement
Views: 194 Learn In Urdu
recovery manager scenario 8   restore recover lost control DBF with multiplexed control DBF copy
 
20:15
In this tutorial you will learn how to restore recover control DBF when they are multiplexed.
Views: 129 DBA Pro
recover manager scenario 7   restore recover datafile to different locations
 
15:27
In this tutorial you will learn how to restore recover datafiles to different locations.
Views: 139 DBA Pro
create user dbase management security
 
27:21
create user, identified by, default parmanent tablespace, temporary table space, quota, profile, dba_users,dba_ts_quota,dba_profile, USERS, TEMP, DEFAULT, SYSTEM TABLESPACE,sql, oracle 11g , database management security, security database
Views: 1233 Dr. Girija Narasimhan
Oracle 11g DBA Bangla Tutorial | Ch11_2 - Managing Undo Data | Database Management System | Training
 
40:05
See the Description for required source code and links Oracle DBA Tutorial Source Code of Oracle Database Training: https://drive.google.com/open?id=0Bz0MNaVyRm3lYmdPdTgzODU0RWs Chapter-11 : Managing Undo Data. In this chapter, you will know about undo data, flashback query. Oracle DBA training including database design is special computer training designed online courses on Database Management System. It is fully bangla tutorial of Oracle 11g database administration. It will be much helpful for every database programmer and administrator. Subscribe this channel to watch my all tutorials on PHP, MYSQL, Javascript, Linux, Networking, Access Programming & Microsoft Office, C++, HTML, CSS. Oracle Database Administration PDF eBook Link : https://drive.google.com/open?id=0Bz0MNaVyRm3la2dYR1A1SlRiVlk All Source Codes & Required Documents together are found in the link: https://drive.google.com/open?id=0Bz0MNaVyRm3ldTUwaTd4cjVka0k Oracle DBA Tutorials: https://www.youtube.com/playlist?list=PLUYY2piVmub6bRM0ScQMNnbyH66yrh1cf Oracle - SQL Tutorial link: https://www.youtube.com/playlist?list=PLUYY2piVmub7QL0ET2_eg4D_SV3AOsPHT Channel Link: http://www.youtube.com/channel/UCT_fWLNX67sDH3W3FZ1wxLg?sub_confirmation=1 Required Document Link : https://drive.google.com/open?id=0Bz0MNaVyRm3lTWNhMURIbFV1MjA FB Page: https://www.facebook.com/BanglaTutorial24 FB Group: https://www.facebook.com/groups/banglatutorial24/ N.B: In the video tutorial, I have tried to focus on the steps of undo data management, flashback query. [SQL TUTORIAL, DATABASE MANAGEMENT SYSTEM, BANGLA TUTORIAL, TRAINING, DATABASE, ORACLE DBA]
Views: 280 MD. SHARIFUL ALAM
How to create oracle 11g Table space (user schema creation)
 
11:02
create tablespace rfdemo logging datafile '/oradata/DB11G/rfdemo.dbf' size 5G autoextend on next 512m maxsize 10G extent management local; CREATE USER rfdemo IDENTIFIED BY rfdemo DEFAULT TABLESPACE rfdemo TEMPORARY TABLESPACE TEMP; GRANT "RESOURCE" to rfdemo; GRANT "CONNECT" to rfdemo; GRANT "DATAPUMP_EXP_FULL_DATABASE" to rfdemo; GRANT "DATAPUMP_IMP_FULL_DATABASE" to rfdemo; REVOKE UNLIMITED TABLESPACE FROM rfdemo; ALTER USER rfdemo QUOTA UNLIMITED ON rfdemo; commit;
Views: 7682 ab1 ek
Gérer les tablespaces et les fichiers et de données
 
02:21
Oracle , Gérer les tablespaces et les fichiers et de données
Views: 391 Nsaibi Mohamed
TABLESPACE MANAGEMENT RENAME OR MOVE A DATAFILE
 
04:40
RENAME OR MOVE A DATAFILE (when there is space issue in os level file movement is required) ========================== 1)TABLESPACE SHOULD BE OFFLINE(when we move or rename a datafile users should not access) 2)FROM OS LEVEL DATAFILE COPY TO NEW LOCATION 3)SQL LEVEL RENAME THE DATAFILE TO NEW LOCATION 4)MAKE THE TABLESPACE ONLINE alter tablespace king offline; os level rename king01.dbf TO GOODKING01.dbf os level move the file to new location(KING02.DBF) alter tablespace king rename datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' to 'E:\DATABASE\DATABASE\ORADATA\ORCL\GOODKING01.DBF'; alter tablespace king rename datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING02.DBF' TO 'D:\ORADATA\KING02.DBF'; alter tablespace king online; HOW TO CHECK DATAFILES INFO IN PARTICULAR TABLESPACE ===================================================== COL FILE_NAME FOR A50 COL TABLESPACE_NAME FOR A20 select tablespace_name,file_name from dba_data_files where tablespace_name like '&tablespace_name';
Views: 725 Praveen Biyyapu
Simplified DBA-018-User Privileges
 
13:21
A privilege is a right to execute a particular type of SQL statement or to access another user’s object. The Oracle database enables you to control what the users can and cannot do in the database. Privileges are divided into two categories: System privileges: Each system privilege allows a user to perform a particular database operation or class of database operations. For example, the privilege to create tablespaces is a system privilege. System privileges can be granted by the administrator or by someone who has been given explicit permission to administer the privilege. Object privileges: Object privileges allow a user to perform a particular action on a specific object, such as a table, view, sequence, procedure, function, or package. Without specific permission, users can access only their own objects. Object privileges can be granted by the owner of an object, by the administrator, or by someone who has been explicitly given permission to grant privileges on the object. For example, in our demo ERPUSER will own the tables and other users will require read, write object privileges on ERPUSER tables. Example Connect erpuser/welcome1 Grant insert on myable1 to user1; Grant insert on myable1 to user5 Create tablespace erp_data datafile ‘/u01/app/oradata/db11lin/erpdata01.dbf’ size 100M autoextend on; Create user erpuser identified by welcome1 default tablespace erp_data temporary tablespace temp; Grant connect, resource to erpuser; Create user user1 identified by welcome1 default tablespace erp_data temporary tablespace temp; Create table erpuser.mytable1 ( sno number(5), sname varchar2(20)); We can create a table for any user in this format if we have dba privileges. [owner.tablename] Connect user1/welcome1 Insert into erpuser.mytable1 values(100, ‘by user1’); Commit;
TABLESPACE MANAGEMENT DROP TABLESPACE REUSE DATAFILE DROP INCLUDING CONTENTS AND DATAFILES
 
03:48
HOW TO DROP TABLESPACE ====================== drop tablespce king; (datafile will not delete from o/s level) create tablespace king datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' reuse;(no need to give size) drop tablespace king including contents and datafiles;(datafile will delete from o/s level) newly created tablespace king with king01 datafile (got deleted from o/s level)
Views: 472 Praveen Biyyapu
TABLESPACE MANAGEMENT CREATE TABLESPACE ALTER DATAFILE
 
03:34
How to check existing tablespace information in database ========================================================= select tablespace_name from dba_tablespaces; How to create a tablespace =============================== create tablespace king datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' size 10m; How to Resize the datafile ========================== alter database datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' resize 20m; Adding a datafile to a tablespace ================================= alter tablespace king add datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING02.DBF' size 10m; How to get the defintion of tablespace ====================================== set head off echo off select 'select dbms_metadata.get_ddl(''TABLESPACE'',''' || tablespace_name || ''') from dual;' from dba_tablespaces;
Views: 794 Praveen Biyyapu
Oracle Express - SQL Developer (DataFile, TableSpace, User)
 
08:55
Codigo: --CREAR TABLESPACE CREATE TABLESPACE "TSTABLA" DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\PRUEBITA.DBF' SIZE 200M; --TABLESPACE TEMPORAL CREATE TEMPORARY TABLESPACE "TSTABLA_TEMP" TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\PRUEBITA_TEMP.DBF' SIZE 200M; --DBA CREATE ROLE ADMINISTRADOR_BD; --Dar Permisos a rol GRANT CREATE SESSION TO ADMINISTRADOR_BD; GRANT CREATE ANY TABLE TO ADMINISTRADOR_BD; GRANT CREATE ROLE TO ADMINISTRADOR_BD; GRANT CREATE USER TO ADMINISTRADOR_BD; GRANT CREATE VIEW TO ADMINISTRADOR_BD; GRANT CREATE ANY INDEX TO ADMINISTRADOR_BD; GRANT CREATE TRIGGER TO ADMINISTRADOR_BD; GRANT CREATE PROCEDURE TO ADMINISTRADOR_BD; GRANT CREATE SEQUENCE TO ADMINISTRADOR_BD; --CREAR USUARIO CREATE USER USER_BD IDENTIFIED BY PASSWORD_BD DEFAULT TABLESPACE TSTABLA TEMPORARY TABLESPACE TSTABLA_TEMP; --DAR PERMISOS AL USUARIO ADMINISTRADOR_BD SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO USER_BD; --VOLCAR ADMINISTRADOR_BD A COLECCIONES GRANT ADMINISTRADOR_BD TO USER_BD;
Views: 29 Jesus Hidalgo
Oracle Database Tutorial 63 : Introduction to Tablespace In Oracle Database
 
04:26
Introduction to tablespace in oracle database consist Brief intro of tablepsace, type of tablespace, Big and small file tablespace, intro of Data files in oracle By manish sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/tablespace-introduction-rebellionrider Previous Tutorial ► Indexes https://youtu.be/F5NrQYD4a9g ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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 for E-mail address please check About section 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: 33363 Manish Sharma
Quickfix: Tablespace full to resize tablespace
 
02:11
Quickfix is a demonstration on how to fix a spesific database issue. In this video we detect that a tablespace is full and go through the steps to resize the tablespace.
Views: 1540 dbWatch As
Oracle Database tutorial 67: How to create Tablespace using SQL Developer By RebellionRider
 
06:56
Learn (The easiest way)how to create tablespace in oracle database using Oracle SQL Developer GUI: SQL Developer trips and tricks tutorial ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/tablespace-using-sql-developer Previous Tutorial ► How to make SYS user Connection: http://bit.ly/how-to-create-new-connection-in-sql-developer ► Permanent tablespace https://youtu.be/vkwKZIssvfc ► Temporary Tablespace https://youtu.be/Hc_OXitKgWM ► Undo Tablespace https://youtu.be/HlSrHX7ffbI ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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 for E-mail address please check About section 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: 29893 Manish Sharma
Oracle Apex 5.1  Installation  Bangla
 
35:17
How To Installl RUN CMD apex folder select-cd C:\oraclexe\apex Conn sys as sysdba select name from v$datafile; CREATE TABLESPACE apex DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\apex.dbf' SIZE 10M AUTOEXTEND ON NEXT 5M; @apexins.sql APEX APEX TEMP /i/ @apxchpwd.sql @apex_epg_config.sql C:\oraclexe ALTER USER ANONYMOUS ACCOUNT UNLOCK; @apxldimg.sql C:\oraclexe EXEC DBMS_XDB.sethttpport 8080 ;
Views: 33 Golam Rabbani
TABLESPACE MANAGEMENT DATAFILE SIZE ENABLE DISABLE AUTOEXTEND ON
 
02:50
HOW TO ENABLE/DISABLE AUTOEXTEND ON FOR A DATAFILE ================================================== alter database datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\GOODKING01.DBF' autoextend on; HOW TO FIND THE SIZE OF A DATAFILE ================================== SELECT SUBSTR (df.NAME, 1, 50) file_name, df.bytes / 1024 / 1024 allocated_mb, ((df.bytes / 1024 / 1024) - NVL (SUM (dfs.bytes) / 1024 / 1024, 0)) used_mb, NVL (SUM (dfs.bytes) / 1024 / 1024, 0) free_space_mb FROM v$datafile df, dba_free_space dfs WHERE df.file# = dfs.file_id(+) GROUP BY dfs.file_id, df.NAME, df.file#, df.bytes ORDER BY file_name; set lines 180 pages 200 col tablespace_name for a20 col file_name for a55 select tablespace_name,file_name,autoextensible from dba_data_files;
Views: 1096 Praveen Biyyapu
How To Create and Drop Tablespace in Oracle 11g
 
09:42
How to Create & Drop a Tablespace
Views: 25670 DbaRocksOracle
Instalación de Oracle Database 11g Express Edition - Creación de Datafile y Namespace
 
10:36
Links de Descarga: Oracle Database: http://www.oracle.com/technetwork/database/database-technologies/express-edition/overview/index.html Oracle SQL Developer: http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html EJEMPLO CÓDIGO (SQL DEVELOPER): --CREAR TABLESPACE CREATE TABLESPACE "TSTABLA" DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\PRUEBITA.DBF' SIZE 200M; --TABLESPACE TEMPORAL CREATE TEMPORARY TABLESPACE "TSTABLA_TEMP" TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\PRUEBITA_TEMP.DBF' SIZE 200M; --DBA CREATE ROLE ADMINISTRADOR_BD; --Dar Permisos a rol GRANT CREATE SESSION TO ADMINISTRADOR_BD; GRANT CREATE ANY TABLE TO ADMINISTRADOR_BD; GRANT CREATE ROLE TO ADMINISTRADOR_BD; GRANT CREATE USER TO ADMINISTRADOR_BD; GRANT CREATE VIEW TO ADMINISTRADOR_BD; GRANT CREATE ANY INDEX TO ADMINISTRADOR_BD; GRANT CREATE TRIGGER TO ADMINISTRADOR_BD; GRANT CREATE PROCEDURE TO ADMINISTRADOR_BD; GRANT CREATE SEQUENCE TO ADMINISTRADOR_BD; --CREAR USUARIO CREATE USER USER_BD IDENTIFIED BY PASSWORD_BD DEFAULT TABLESPACE TSTABLA TEMPORARY TABLESPACE TSTABLA_TEMP; --DAR PERMISOS AL USUARIO ADMINISTRADOR_BD SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO USER_BD; --VOLCAR ADMINISTRADOR_BD A COLECCIONES GRANT ADMINISTRADOR_BD TO USER_BD;
Views: 14 Gabriel Cordero
Oracle DBA | Create TableSpace | Bangla | DBA1-14
 
11:38
Oracle DBA | Create TableSpace | Bangla | DBA1-14 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 know about TableSpace and Create TableSpace About Tablespace: Oracle stores data logically in tablespaces and physically in datafiles associated with the corresponding tablespace. A table space is a storage structure, it contains tables, indexes, large objects, and long data. It can be used to organize data in a database into logical storage group which is related with where data stored on a system. This tablespaces are stored in database partition groups. Types of Tablespace: 1.SYSTEM 2.SYSAUX 3.TEMP 4.UNDOTBS1 5.USERS 6.EXAMPLE (optional) Location of Data file: app\Administrator\oradata\orcl Create Tablespace: Command: 1.connect sysdba1.sql- create tablespace test1 datafile ‘E:\app\Administrator\oradata\orcl\dfile1.dbf'size 200m; 2.sql-create tablespace test2 datafile ‘E:\app\Administrator\oradata\orcl\dfile1.dbf‘ size 200m AUTOEXTEND ON ONLINE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M; Drop Tablespace: SQL- drop tablespace test1 including contents and datafiles; 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: 89 OracleDB Solutions
[2018 Hot] Latest Release 1Z0-067 Dumps Oracle Database 12c
 
01:51
Sale Latest Release Pass4itsure 1Z0-067 Dumps Cert, Real Oracle https://www.pass4itsure.com/1Z0-067.html Dumps Testing With Accurate Answers, Pass Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP From Google Drive https://drive.google.com/open?id=13jc1Qa-ND4dc0H2I3cSLW_zkiCHK8Yi9 QUESTION 1 You must unload data from the orders, order_items, and products database tables to four files using the External Tables. CREATE TABLE orders_ext (order_id, order_date, product_id, product_name,quantity) ORGANIZATION EXTERNAL (TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY ext.dir LOCATION (`ordersl.dmp\',\'orders2.dmp\',\'orders3.dmp\',\'lorders4.dmp\') ) PARALLEL AS SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity FROM orders o,productsp,order_itemsi WHERE o.orderjd = i.order_id and i.product_id = p.product_id; You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created? A. TYPE B. LOCATION C. PARALLEL D. DEFAULT DIRECTORY E. ORGANIZATION EXTERNAL Correct Answer: A QUESTION 2 In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20. Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement? A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used B. Setting the target tablespace to read-only after the segments are moved C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used D. Taking the target tablespace offline after the segments are moved E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used Correct Answer: AB QUESTION 3 A user issues a query on the sales table and receives the following error: ERROR at line 1: ORA-01565: error in identifying file \'/u0l/app/oracle/oradata/ORCL/temp01.dbf\' ORA-27037: unable to obtain file status Which two actions would you take to recover the temporary tablespace? A. Drop the tenpOi.dbf file, and then re-create the temp file. B. Add a new temp file to the temporary tablespace and drop the tempOi.dbf file. C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database. D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online. E. Create a new temporary tablespace and assign it as the default to the user. Correct Answer: DE Read More Youtube: https://youtu.be/0ipPT8nEpgc
Views: 8 Exam Videos
TekTip: How to Convert a .DBF File to Excel
 
01:14
This short video demonstrates how to convert a .DBF database file to an Excel Workbook file for use with your TEKLYNX label design software. Read instructions here: http://ow.ly/U03AC
Views: 21278 TEKLYNX International
Oracle Database tutorial 64: How To Create Permanent tablespace (Big file and small file)
 
07:15
How to create big file and small file permanent tablepsace in oracle database by Manish sharma rebellionRider In this tutorial you will learn the process of big file and small file permanent tablespace creation with datafiles ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/permanent-tablespace-oracle-rebellionrider Script: https://copy.com/whfzfAeUtzy0JEoU Previous Tutorial ► Tablespace The Introduction : https://youtu.be/5i5RtUdxaHY ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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 for E-mail address please check About section 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: 17255 Manish Sharma
recovery manager scenario 1   restore, recover datafiles
 
36:31
In this tutorial you will learn how to perform restore and recovery on datafiles with recover manager (RMAN).
Views: 831 DBA Pro
Install oracle apex 5
 
28:25
To install oracle apex version 5 you must install oracle database 11g. Software download link bellow: http://www.oracle.com/technetwork/developer-tools/apex/downloads/download-085147.html Follow the installation steps: CREATE TABLESPACE apex DATAFILE 'E:\APP\DBA\ORADATA\ORACLE\apex.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M; @apexins.sql APEX APEX TEMP /i/ @apxchpwd.sql password: Oracle123# @apex_epg_config.sql D: ALTER USER ANONYMOUS ACCOUNT UNLOCK; @apxldimg.sql D: EXEC DBMS_XDB.sethttpport(8080);
Views: 4783 IT WORLD
Instalacion ORACLE express, Creacion de TableSpace, DataFile y Usuario
 
08:49
Link de Oracle: http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html Link SqlDeveloper: http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html CODIGO UTILIZADO EN SQL DEVELOPER: --CREAR TABLESPACE CREATE TABLESPACE "TSTABLA" DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\Tutorial.DBF' SIZE 200M; --TABLESPACE TEMPORAL CREATE TEMPORARY TABLESPACE "TSTABLA_TEMP" TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\Tutorial_TEMP.DBF' SIZE 200M; --DBA CREATE ROLE ADMINISTRADOR_BD; --Dar Permisos a rol GRANT CREATE SESSION TO ADMINISTRADOR_BD; GRANT CREATE ANY TABLE TO ADMINISTRADOR_BD; GRANT CREATE ROLE TO ADMINISTRADOR_BD; GRANT CREATE USER TO ADMINISTRADOR_BD; GRANT CREATE VIEW TO ADMINISTRADOR_BD; GRANT CREATE ANY INDEX TO ADMINISTRADOR_BD; GRANT CREATE TRIGGER TO ADMINISTRADOR_BD; GRANT CREATE PROCEDURE TO ADMINISTRADOR_BD; GRANT CREATE SEQUENCE TO ADMINISTRADOR_BD; --CREAR USUARIO CREATE USER USER_BD IDENTIFIED BY PASSWORD_BD DEFAULT TABLESPACE TSTABLA TEMPORARY TABLESPACE TSTABLA_TEMP; --DAR PERMISOS AL USUARIO ADMINISTRADOR_BD SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO USER_BD; --VOLCAR ADMINISTRADOR_BD A COLECCIONES GRANT ADMINISTRADOR_BD TO USER_BD; VIDEO HECHO POR Darlin Gutiérrez Freire Curso: 4-3
Views: 59 Darlin Gutierrez
Oracle Database Tutorial 66: How To Create Undo Tablespace By Manish Sharma RebellionRider
 
05:15
Oracle data base tutorial on how to create undo tablespace By Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/undo-tablespace-rebellionrider Previous Tutorial ► Tut 63 Intro: https://youtu.be/5i5RtUdxaHY ► Tut 64 Permanent Tablespace: https://youtu.be/vkwKZIssvfc ► Tut 65 Temporary Tablespace: https://youtu.be/Hc_OXitKgWM ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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 for E-mail address please check About section 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: 12646 Manish Sharma
TABLESPACE MANAGEMENT GRANT REVOKE QUOTAS ON TABLESPACE FOR USERS
 
06:20
How to grant/revoke quota for Users on Tablespace ================================================= create tablespace test datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\test.dbf' size 10m;---(tablespace created) create user naveen identified by naveen;(user created) alter user naveen quota 2m on test;(granted 2m on test tablespace) alter user naveen quota unlimited on test;(granted unlimited on test) How to revoke unlimited tablespace from user ============================================= revoke unlimited tablespace from &user; How to check the views on quotas ================================= select table_name from dict where table_name like '%QUOTA%'; Queries for tablespace quotas on all users ========================================== set lines 180 set pages 200 col tablespace_name for a30 col username for a20 select * from user_ts_quotas; set lines 180 set pages 200 col tablespace_name for a30 col username for a20 select * from dba_ts_quotas;
Views: 473 Praveen Biyyapu
05 Creacion de Tablespace y Usuario en Oracle 11g
 
11:27
Se explica en forma breve como crear tablespace para los datos, indices y archivos temporales. Además de crear un usuario con la finalidad de que este genere posteriormente un esquema relacional. SCRIPT: CREATE TABLESPACE PERSONA_DATA DATAFILE '/opt/baseDatos/DT_PERSONAS.DBF' SIZE 200M; CREATE TEMPORARY TABLESPACE PERSONA_TEMP TEMPFILE '/opt/baseDatos/DT_PERSONAS_TMP.DBF' SIZE 200M; CREATE TABLESPACE PERSONA_INDEX DATAFILE '/opt/baseDatos/DT_PERSONAS_IDX.DBF' SIZE 200M; SELECT * FROM DBA_DATA_FILES; CREATE ROLE ADMINISTRADOR_BD; --Dar Permisos a rol GRANT CREATE SESSION TO ADMINISTRADOR_BD; GRANT CREATE ANY TABLE TO ADMINISTRADOR_BD; GRANT CREATE ROLE TO ADMINISTRADOR_BD; GRANT CREATE USER TO ADMINISTRADOR_BD; GRANT CREATE VIEW TO ADMINISTRADOR_BD; GRANT CREATE ANY INDEX TO ADMINISTRADOR_BD; GRANT CREATE TRIGGER TO ADMINISTRADOR_BD; GRANT CREATE PROCEDURE TO ADMINISTRADOR_BD; GRANT CREATE SEQUENCE TO ADMINISTRADOR_BD; --CREAR USUARIO CREATE USER PERSONA_BD IDENTIFIED BY PERSONA_BD DEFAULT TABLESPACE PERSONA_DATA TEMPORARY TABLESPACE PERSONA_TEMP; --DAR PERMISOS AL USUARIO ADMINISTRADOR_BD SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO PERSONA_BD; --VOLCAR ADMINISTRADOR_BD A COLECCIONES GRANT ADMINISTRADOR_BD TO PERSONA_BD;
How to Move a Datafile in Oracle Database - Part 1
 
01:32
Dozens of free Oracle tutorials at http://skillbuilders.com/free-oracle-tutorials. See Part 2 (the demonstration) of this tutorial at http://skillbuilders.com/How-to-Move-Datafiles-Oracle-12c. How do you move a datafile in an Oracle Database? Well, it just got a lot easier in 12c! Watch this free video tutorial - OCM John Watson of SkillBuilders will demonstrate both techniques, 11g and 12c. There are many reasons to move a datafile in an Oracle database. Here are just a few: Renaming datafiles to a standard Moving from one file system to another Converting from file system storage to ASM Changing from SAN to NFS storage In 11g, we need to take the tablespace offline, meaning downtime. Argh! In 12c, all that is required is ALTER DATABASE MOVE DATAFILE; this is an online operation with zero downtime. Even "critical" files such as the files associated with the SYSTEM tablespace can be moved online. Consider the ease of migrating to ASM this provides! This also functions in an Active Data Guard standby environment. And, there are syntax options that allow you to keep or delete the original file. Very cool stuff.
Views: 2426 SkillBuilders
001. Oracle Apex 5.0 Installation
 
23:56
Oracle Apex 5.0 Installation Step By Step ================================ 01: Download Apex 5.0 link is http://www.oracle.com/technetwork/developer-tools/apex/downloads/apex-5-archive-2606313.html 02: Unzip APEX5_0_1.zip any drives ex: d:\apex 03: CMD runing: run as administrator 04: Go apex Location path type: cd d:\apex 05: Type sqlplus 06: Entry sys user Type: sys/[email protected] as SYSDBA NB:sys/[email protected] as sysdba 07: datafile location search : select name from v$datafile; 08: Tablespace_name : select tablespace_name from dba_tablespaces; if tablespace exsit : drop tablespace apex including contents; and datafile delete D:\APP\ARSAAD\ORADATA\SAAD\apex.dbf 09: create tablespace : CREATE TABLESPACE apex DATAFILE 'D:\APP\ARSAAD\ORADATA\SAAD\apex.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M; 10: Installation commend : @apexins.sql apex APEX TEMP /i/ NB:Please Wait few minites.... 11: Type sqlplus 12: Entry sys user Type: sys/[email protected] as SYSDBA [user/[email protected] as sysdba] 13: Password set commend : @apxchpwd.sql NB:Abcd#123 14: Image Load commend : @apex_epg_config.sql D: NB:D: is Apex folder Location. NB:Please Wait few minites.... 15: Account Unlock : ALTER USER ANONYMOUS ACCOUNT UNLOCK; 16: Image binary load : @apxldimg.sql D: NB:D: is Apex folder Location. NB:Please Wait few minites.... 17: Apex port set commend : EXEC DBMS_XDB.sethttpport(8080); 18: Go to any browser and type: localhost:8080/apex/apex_admin then username & Password and Enjoy APEX.
Views: 190 Muhammad Nuruddin
Exception in thread "main"  Database instance unavailable
 
00:11
Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableExcep tion: Database instance unavailable. at oracle.sysman.emcp.DatabaseChecks.throwDBUnavailableException(Databas eChecks.java:151) at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChe cks.java:144) at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks. java:163) at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.jav a:582) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAss istant.java:1272) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.jav a:574) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522) CONFIG: ORA-01031: insufficient privileges oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01031: insufficient privileges at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655) at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978) at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineLoacly(GeneralUtil.java:445) at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:637) at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:118) at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:163) at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.java:582) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1272) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
SCPT 7: Oracle Control Files
 
12:13
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 43552 Oresoft LWC
recovery manager scenario 6   restore recover changed data files
 
18:01
In this tutorial you will learn how to restore recover datafiles that are not backed up with RMAN.
Views: 127 DBA Pro
Atelier exercice récapitulatif de la premiere partie DBA1
 
17:30
Correction: 1)Deux composants principals: - Instance (Memoire dans laquelle oracle exploite les fichiers de la base de donnees "RAM" ). - La base de donnees (structure physique da la base "Disque dur" ) 2)- les fichiers de controle:il contient des informations sur la structure physique de la base (tres sensibles) - les fichiers de donnees:pour le stokage des objets de different utilisateurs - les fichiers de journalisation : pour la sauvegarde des mise à jour et des modifications de la base. 3)-SGA (shared global area ) zone memoire partagée par tous les utilisateurs. -PGA (program global area) zone memoire privée pour chaque composant de la base de donnees. 4)C'est la partie memoire dans laquelle oracle travaile. 5)COURS DBAI [Tuto 4]- DataBase Configuration Assistant (dbca) https://www.youtube.com/watch?v=uV6wn1HcG5Y 6)services.msc 7)apres l'arret de service on oconstate l'echec de connexion. 8)Apres le demarrage de service on peut se connecter. 9)shutdown startup mount select status from v$instance; alter database open; 10)isqlplusctl start http://localhost:5560/isqlplus 11)v$instance 12)shutdown immediate 13)oradim -new -SID demo2 14)services.msc 15)oradim -delete -SID demo2 16)desc v$parameter 17)desc v$log et v$logfile alter system switch logfile; 18)desc v$controlfile; show parameter controlfiles; 19)alter database backup controlfile to trace; 20)desc dba_tablespaces; select tablespace_name,content from dba_tablespaces; 21)create tablespace TS2 datafile 'D:\data2.dbf' size 50m; desc dba_data_files;
Views: 59 Houssine Formation
Simple ADO Tutorial With Delphi 7
 
26:14
Simple ADO Tutorial With Delphi 7
Views: 6628 Dadang Iskandar
Creating a data link (UDL) file - Testing connectivity to a SQL server
 
01:46
This video is to show how to perform a UDL test to check connectivity from a Windows server to a SQL server instance and database. For more information: http://www.sophos.com/support/knowledgebase/article/65525.html
Views: 17975 Sophos Global Support
Combine Files with Power Query Excel 2016 (Get & Transform) - Part 3
 
05:27
https://www.datastrategywithjonathan.com This is Part 3/4 Part 1 The first step of any process should start with get and transform / power query. Even if you have no transformation steps this can be valuable. In Excel 2010 and Excel 2013 Power Query was an add-in. In Excel 2016 Power Query has been renamed to Get and Transform. Power Query / Get and Transform allows us to easily perform tasks that use to require Excel VBA. Learn the hidden tweak that makes Excel 2016 Power Query more flexible and gets it back to the way it use to work in Excel 2010 and Excel 2013. By linking with power query we can refresh our Excel dashboards with a click of a button and focus more on our Excel analytics. Part 2 Power Query (aka Get and Transform) is capable of merging data with database joins all without requiring a database. Power Query merge / join in most cases is the better alternative to vlookups and temporary / desktop database solutions. Vlookup calculations are the number one cause of slow performance when developing our Excel dashboards or Excel Analytics. No Excel VBA required. Part 3 Use Power Query (aka Get and Transform) to merge a whole folder of files together. Learn about what to look out for when using Power Query for this feature. This helps to support our Excel dashboard development and Excel analytics when working with lots of files. No Excel VBA required. Part 4 Data resulting from pivot tables often do not confirm to a tidy data format. We can correct for this using Power Query (aka Get and Transform). Power Query fill and Power Query Unpivot are powerful features that can save you a ton of time and allow you to do complex VBA like functions without having to write any VBA code. Easily transform your data ready for your Excel Dashboard or Excel data analytics. If you're looking to learn Advanced Excel, Excel VBA or Databases then you need to check out this video series. In this videos series, I will show you how to use Microsoft Excel in different ways that will make you far more effective at working with data. I'm also going to expand your knowledge beyond Excel and show you tips, tricks, and tools from other top data analytics tools such as R Tidyverse, Python, Data Visualisation tools such as Tableau, Qlik View, Qlik Sense, Plotly, AWS Quick Sight and others. We'll start to touch on areas such as big data, machine learning, and cloud computing and see how you can develop your data skills to get involved in these exciting areas. Excel Formulas such as vlookup and sumifs are some of the top reasons for slow spreadsheets. Alternatives for vlookup include power query (Excel 2010 and Excel 2013) which has recently been renamed to Get and Transform in Excel 2016. Large and complex vlookup formulas can be also done very efficiently in R. Using the R Tidyverse libraries you can use the join functions to merge millions of records effortlessly. In comparison to Excel Vlookup, R Tidyverse Join can pull on multiple columns all at the same time. Microsoft Excel Power Query and R Tidyverse Joins are similar to the joins that you do in databases / SQL. The benefit that they have over relational databases such as Microsoft Access, Microsoft SQL Server, MySQL, etc is that they work in memory so they are actually much faster than a database. Also since they are part of an analytics tool instead of a database it is much faster and easier to build your analysis and queries all in the same tools. My very first R Tidyverse program was written to replace a Microsoft Access VBA solution which was becoming complicated and slow. Note that Microsoft Access is very limited in analytics functions and is missing things as simple as Median. Even though I had to learn R programming from scratch and completely re-write the Microsoft Access VBA solution it was so much easier and faster. It blew my mind how much easier R programming with R Tidyverse was than Microsoft Access VBA or Microsoft Excel VBA. If you have any VBA skills or are looking to learn VBA you should definitely checkout my videos on R Tidyverse. To understand why R Tidyverse is so much easier to work with than VBA. R Tidyverse is designed to work directly with your data. Note the most efficient path is to reduce the data pulled down from the database in the first place. This is referring to the amount of data you are pulling down from your data warehouse or data lake. It makes no sense to pull data from a data warehouse / data lake to pull into another database to query add joins / lookups to then pull it into Excel or other analysis tool. Often analyst build these intermediate databases because they either don’t have control of the data warehouse or they need to join additional information. All of these operations are done significantly faster in a tool such as R Tidyverse or Microsoft Excel Power Query.
Views: 292 Jonathan Ng

Computer service technician cover letter
Inter cover letter
Non disclosure agreement cover letter template
Data analysis dissertation help free
Iphone 3gs ios 6.1.6 application letters