Home
Search results “Oracle temp dbf”
RECOVER LOST  DataFile in oracle database
 
15:33
Please donate on below link if you think I am helping you with your career. https://www.paypal.me/ankushthavali OR Google Pay : 9960262955 OR Account No : 31347845762 IFSC: SBIN0012311 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] how to recover lost datafile in oracle how to recover a datafile in oracle without backup how to recover a deleted datafile in oracle 11g how to recover datafile in oracle rman restore datafile oracle missing datafile after clone how to recover system datafile in oracle without backup oracle datafile deleted accidentally
Views: 1312 ANKUSH THAVALI
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: 1720 Cocktail Video
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: 15242 Manish Sharma
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: 348 Dantee Astudillo
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: 38 Jesus Hidalgo
Import data from DBF file (dBase, FoxBase, FoxPro) to Oracle
 
00:22
Want to import data from DBF file (dBase, FoxBase, FoxPro) to Oracle? You can try Withdata DbfToOracle, no need to program, just a few mouse clicks! For more Withdata DbfToOracle information, https://www.withdata.com/dbftooracle/ . To download, https://www.withdata.com/down/DbfToOracle.exe .
Views: 73 Shiji Pan
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: 170 Sanz
How to Rename datafile in Oracle database
 
08:05
How to Rename datafile in Oracle ====================================== How to Rename datafile ====================================== select FILE_NAME,TABLESPACE_NAME,ONLINE_STATUS from dba_data_files; select status,instance_name,database_role,protection_mode from v$database,v$instance; alter database datafile '/opt/oracle/oradata/prim/users_test_after_rename.dbf' offline; server: mv old_data_file new_data_files alter tablespace USERS rename datafile '/opt/oracle/oradata/prim/users_test' to '/opt/oracle/oradata/prim/users_test_after_rename.dbf'; alter database datafile '/opt/oracle/oradata/prim/users_test_after_rename.dbf' online; how to move datafile from one location to another in oracle 11g alter database rename datafile file_id alter database rename datafile script how to move datafile in oracle standby database oracle move system datafile how to move datafile from one location to another in oracle 12c alter database rename file 1 to alter database move datafile 12c asm
Views: 228 ANKUSH THAVALI
Oracle Tablespace Management
 
41:44
How to Create and Manage tablespace watch this video
Views: 5235 COMBINATIONS FOR ALL
How to Set Environment Variables in Windows
 
01:27
Follow this step by step tutorial to learn how to set environment variables from system settings in the windows operating system. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial, you will learn how to set environment variables in windows. Operating systems require environment variables as settings and configurations for several processes. Although these variables are automatically defined or initialized during the installation of the system or specific software, in windows, to set environment variables manually is not a difficult task. That's because windows allows us to manually add, remove or edit environment variables through system settings according to our requirements. Step # 1 -- Opening environment variables In windows, to set environmental variables, you can take two paths. Either we can go to control panel, then access the system security option, and then the system option. Or we can simply right click on My Computer and select its properties. Once we are in the system window, select the advanced system settings from the list on the left side. A new window will pop up. Over here, click on the environment variables button near the bottom of this window and you can now access the Windows environment variables. Step # 2 -- Adding a variable In this window there are two sets of environment variables, one is the "user variables", and the other is the "system variables". Choose the new button in the user variables section to open the "define a new variable" dialog window. Over here, you will be required to define the variable name as anything you wish to set, such as temporary and then define its value as the path to the directory. With that done, let's complete this process by pressing OK. Your new environment variable has been created now. Step # 3 -- Editing and removing a variable To edit an environment variable, click on it, and then click on the edit button to open a dialog window. Here we can edit the name and value of the variable. Likewise to remove an environment variable, simply click on the variable and then click on the delete button. Once all the definitions are complete, close the window and restart your computer to allow the operating system to load these settings on boot. And that's basically all you need to know for how to set environment variables in windows.
Oracle Database 12c (12.1.0.1.0): creating a pluggable database using the files of the seed
 
03:09
How to create a pluggable database PDB in a multitenant container database CDB using the files of the seed PDB$SEED Have a look at this link: http://dbaworkshop.blogspot.it/2013/07/How-to-create-a-pluggable-database-PDB-in-a-multitenant-container-database-CDB-using-the-files-of-the-seed.html Here is my sql script: CREATE PLUGGABLE DATABASE PDB002 ADMIN USER PDB002_ADMIN IDENTIFIED BY oracle storage (maxsize 5G MAX_SHARED_TEMP_SIZE 500M) DEFAULT TABLESPACE "USERS" DATAFILE '/app/oracle/oradata/CDB001/PDB002/PDB002_users01.dbf' SIZE 5M REUSE AUTOEXTEND ON file_name_convert=('/app/oracle/oradata/CDB001/pdbseed/system01.dbf','/app/oracle/oradata/CDB001/PDB002/system01.dbf','/app/oracle/oradata/CDB001/pdbseed/sysaux01.dbf','/app/oracle/oradata/CDB001/PDB002/sysaux01.dbf','/app/oracle/oradata/CDB001/pdbseed/temp01.dbf','/app/oracle/oradata/CDB001/PDB002/temp01.dbf');
Views: 1554 mvige
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;
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: 32 kevin surf
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: 7850 ab1 ek
LAB6.2 RMAN  Restore Recover from Loss of control and datafile
 
31:09
RMAN -Restore Recover from Loss of control and datafile
Views: 260 PishonTech
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: 775 Praveen Biyyapu
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: 209 Muhammad Nuruddin
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: 16 Gabriel Cordero
[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: 14 Exam Videos
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: 31791 Manish Sharma
Oracle Table Space and User Creation with grant Privileges
 
05:05
--------------Table space Creation-------------------- Syntax CREATE TABLESPACE 'DATA FILE NAME' DATAFILE 'Data File Path to store the data' SIZE 'SIZE in MB' AUTOEXTEND ON NEXT 'SIZE in KB/MB' MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 'SIZE in KB' SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE ORA12CR2_DATA DATAFILE 'E:\OracleDB\app\ORA12CR2_DATA.dbf' SIZE 2048M AUTOEXTEND ON NEXT 8K MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE ORA12CR2_INDEX DATAFILE 'E:\OracleDB\app\ORA12CR2_INDEX.dbf' SIZE 1024M AUTOEXTEND ON NEXT 8K MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; Increasing the Tablespace space: ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_DATA.dbf' RESIZE 5120M; ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_DATA.dbf' AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED; ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_INDEX.dbf' RESIZE 2048M; ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_INDEX.dbf' AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED; ------------User Creation and Grant Privileges Syntax:- CREATE USER 'USER NAME' IDENTIFIED BY 'Password' DEFAULT TABLESPACE 'Table Space Name' TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; Example:- CREATE USER DEMOUSER IDENTIFIED BY DEMOUSER DEFAULT TABLESPACE ORA12CR2_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited; alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited; GRANT DBA TO DEMOUSER; ALTER USER DEMOUSER DEFAULT ROLE ALL; -- 16 System Privileges for DEMOUSER GRANT CREATE ROLE TO DEMOUSER; GRANT CREATE TYPE TO DEMOUSER; GRANT CREATE VIEW TO DEMOUSER; GRANT CREATE TABLE TO DEMOUSER; GRANT ALTER SESSION TO DEMOUSER; GRANT CREATE SESSION TO DEMOUSER; GRANT CREATE SYNONYM TO DEMOUSER; GRANT CREATE TRIGGER TO DEMOUSER; GRANT CREATE ANY TYPE TO DEMOUSER; GRANT CREATE SEQUENCE TO DEMOUSER; GRANT CREATE ANY INDEX TO DEMOUSER; GRANT CREATE PROCEDURE TO DEMOUSER; GRANT CREATE ANY TRIGGER TO DEMOUSER; GRANT CREATE DATABASE LINK TO DEMOUSER; GRANT UNLIMITED TABLESPACE TO DEMOUSER; GRANT SELECT ANY DICTIONARY TO DEMOUSER; GRANT DEBUG CONNECT SESSION TO DEMOUSER; GRANT DEBUG ANY PROCEDURE TO DEMOUSER; GRANT CREATE ANY MATERIALIZED VIEW TO DEMOUSER; GRANT GLOBAL QUERY REWRITE TO DEMOUSER; -- 2 Tablespace Quotas for DEMOUSER ALTER USER DEMOUSER QUOTA UNLIMITED ON ORA12CR2_DATA; ALTER USER DEMOUSER QUOTA UNLIMITED ON ORA12CR2_INDEX; -- 1 Object Privilege for DEMOUSER CREATE OR REPLACE DIRECTORY DB_EXP_IMP AS 'E:\OracleDB\app'; GRANT READ, WRITE ON DIRECTORY DB_EXP_IMP TO DEMOUSER;
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: 1227 Praveen Biyyapu
Oracle Apex DMP File (Part 5 of 5)
 
02:22
oracle oracle apex DMP Files تحزيم البيانات في اوراكل اوراكل اوراكل ايبكس
Views: 171 Dr. Nasser Qandil
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: 4894 IT WORLD
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: 797 Praveen Biyyapu
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: 13120 Manish Sharma
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: 44501 Oresoft LWC
creating tablespace in oracle 12c
 
01:44
As Oracle has evolved, the options for creating tablespaces have grown more complex, with more CREATE TABLESPACE options: You create tablespaces with the CREATE TABLESPACE command. Before you create the tablespace you should decide: 1. How big you wish the tablespace to be. 2. Where you want to put the datafile or datafiles that will be associated with that tablespace. 3. What you want to call the tablespace and the datafiles. We recommend that you include the following in the datafile name when you create the tablespace: 1. The name of the database 2. The name of the tablespace 3. A number that makes the datafile unique So, for a tablespace called USERS assigned to a database called BOOKTST we would have a datafile called booktst_users_01.dbf. Here is an example of creating such a tablespace using the create tablespace command: Note that we used 50m to indicate that we wanted to create the tablespace 50 Megabytes in size. You can also use the K symbol for Kilobytes, and the G symbol for Gigabytes. If you want to try to use the P symbol for a 50 Petabyte tablespace, we want to talk to you! There are several "create tablespace" options that determine how big the tablespace will be: Autoextend on: Creating a tablespace with autoextend on alleviates the potential problem of a database outage if the tablespace reaches maximum extents. You create a tablespace using autoextend with the autoextend on option. Using "create tablespace . . . autoextend on" will push the point of failure to the OS filesystem, which is good because you never want you database to hang because a tablespace cannot grow. With autoextend on, you only need to monitor the free space in the filesystem directory. Maxsize: This is the maximum size that the datafile can grow. We recommend creating a tablespace with maxsize unlimited to prevent a lock-up. Size: This is the size of the underlying data file for the tablespace. Blocksize: Specifying a larger blocksize will not result in a larger tablespace. See here on creating tablespaces with non-default blocksizes. Uniform size: This specifies the size that the data file will grow when it needs to extend. By default, an Oracle tablespace will not grow if it runs out of space. If you use up all your space, you are just out of luck unless you use the autoextend keyword to indicate that the tablespace may grow, on it?s own, dynamically. Here is an example of creating a tablespace that is set to autoextend:
Views: 5061 Mohammad Taseen
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;
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: 895 Praveen Biyyapu
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: 35864 Manish Sharma
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: 1323 Dr. Girija Narasimhan
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: 78 Darlin Gutierrez
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: 41 Golam Rabbani
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: 1759 dbWatch As
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: 397 Hisham Shoblaq
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: 114 OracleDB Solutions
SQL tutorial 37: How to create NEW USER account using Create User statement in Oracle database
 
07:39
How to create new user accounts using Create User statement in oracle database. In This tutorial you will learn how to create a new user account. Brief explanation of Create user statement syntax and an example of creating a new user and You will learn How to grant Create session system privilege to your ----_Links_--- Blog :http://bit.ly/create_user_account Video Tut 4: http://youtu.be/wSqoXRlXDUU How to create database: http://youtu.be/enFFezPYhCg Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 41322 Manish Sharma
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: 17976 Manish Sharma
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: 539 Praveen Biyyapu
How To Create and Drop Tablespace in Oracle 11g
 
09:42
How to Create & Drop a Tablespace
Views: 26442 DbaRocksOracle
How to Shrink table in Oracle..
 
11:52
this video will help how to reclaim space from the table.
Views: 1824 oracdb
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 [スキーマの名前] ~~~~~~~~~~~~~~~~
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: 451 Nsaibi Mohamed
ORACLE LABEL SECURITY EXAMPLE
 
10:40
Simple Example of Oracle Label Security Additional Links http://mohamednabeel.blogspot.com/2014/08/oracle-label-security-12c-quick-start.html https://oracle-base.com/articles/9i/oracle-label-security-9i https://pastebin.com/6Ej5J2Kx
Views: 351 iSamy
recovery manager scenario 5   restore recover tablespaces w 1+ data file loss
 
13:14
In this tutorial you will learn how to restore recover tablespaces w 1+ data files lost.
Views: 217 DBA Pro
Oracle DBA Lite: an introduction to Oracle administration, part 3
 
12:50
CAPTIONS AVAILABLE - Tablespace and datafile management in an Oracle database.
Views: 9380 roughsealtd
Manejando Undo Data - Oracle Enterprise
 
06:24
Video practico de algunos comandos para Undo Data
Views: 261 Frank Hernandez