Home
Search results “Oracle tablespaces read only”
Creating  Managing  Droping Oracle Database Tablespaces
 
12:10
Creating Managing Droping Oracle Database Tablespaces select tablespace_name,block_size,status,contents,logging from dba_tablespaces; create tablespace mytbs datafile 'd:\oradata\dbrdbms\mytbs01.dbf' size 10m; alter tablespace mytbs add datafile 'd:\oradata\dbrdbms\mytbs02.dbf' size 10m; alter tablespace mytbs drop datafile 'd:\oradata\dbrdbms\mytbs02.dbf'; desc v$datafile; desc ts#,name from v$datafile; select ts#,name from v$tablespace; select v$datafile.ts#,v$datafile.name,v$tablespace.name from v$datafile,v$tablespace where v$datafile.ts#=v$tablespace.ts# and v$tablespace.name='MYTBS'; alter database datafile 'd:\oradata\dbrdbms\mytbs01.dbf' resize 20m; ALTER DATABASE DEFAULT TABLESPACE mytbs; select ts#,name from v$tablespace; select ts#,name from v$datafile; select ts#,name from v$tablespace; drop tablespace mytbs; drop tablespace mytbs ialtncluding contents and datafiles; drop tablespace mytbs including contents and datafiles cascade; alter tablespace mytbs read only; alter tablespace mytbs read write; alter tablespace mytbs force logging; alter tablespace mytbs nologging; alter tablespace mytbs flashback on; alter tablespace mytbs flashback off; purge tablespace mytbs user myuser;
Views: 21876 Abbasi Asif
Adding a User to Oracle - Full Schema Access, But Read only
 
17:04
Hi friends this video will help you in live environment when you need read only access of other schema object procedure , function packages etc.#AddingaUser #FullSchema #oracle Oracle database Unbeatable,Unbreakable Platform..
Views: 1776 Oracle World
Oracle DBA Justin - How to set an Oracle database to readonly # 1 of 2
 
17:13
How to set an Oracle database to readonly
Views: 3403 jbleistein11
Read-Only Tables in Oracle
 
02:08
Here's a quick video showing how to create Read-Only tables in Oracle. For more information see: https://oracle-base.com/articles/11g/read-only-tables-11gr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by David Peake Blog: http://dpeake.blogspot.com/ Twitter: https://twitter.com/orcl_dpeake Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 905 ORACLE-BASE.com
TABLESPACE MANAGEMENT READ ONLY READ WRITE LOGGING NOLOGGING OFFLINE ONLINE MODES
 
04:36
How to put tablespace in read only, read write, logging , nologging, online, offline =================================================================================== alter tablespace king read only; (we can only read the data(select will work)) alter tablespace king read write; (we can read and write data) alter tablespace king logging; (changes will record in redolog) alter tablespace king nologging; (changes will not record in redolog) alter tablespace king online; (everyone can access) alter tablespace king offline; (can't access) select tablespace_name,status,logging from dba_tablespaces;
Views: 709 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: 36606 Manish Sharma
Transport tablespace by using RMAN.
 
20:11
This is very easy method to transfer tablespace from one database to another database by using RMAN. Explanation: By contrast, when RMAN creates transportable tablespace sets from backup, it does not need access to the live datafiles from the tablespaces to be transported. This eliminates the need to put the tablespace in read-only mode. As a result, database availability is improved, especially for large tablespaces, because the tablespaces to be transported can remain open for writes during the process, and because putting a tablespace into read-only mode can take a long time, depending upon current database activity. Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8 Table Shrinking in Oracle Database : https://www.youtube.com/watch?v=bdockmBDvz8 Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A
Views: 11366 BhagyaRaj Katta
Read only tables in Oracle PLSQL.
 
09:12
How to add or remove read only attribute to a table i Oracle PL/SQL.
Views: 223 Subhroneel Ganguly
Oracle DBA Justin - How to set an Oracle database to readonly # 2 of 2
 
05:30
How to set an Oracle database to readonly
Views: 1564 jbleistein11
How to move Partitions ONLINE  and make them READ ONLY
 
03:46
The clip demonstrates how to move (compressing) Partitions ONLINE and how to make them READ ONLY. Both are 12c New Features. Text version is here: https://uhesse.com/2017/01/05/how-to-move-partitions-online-and-make-them-read-only-in-oracle-12c/
Oracle Networking Between Server and Client machine using TNS listener
 
18:41
Hello friends in today video i am going to explain you that how to perform a Oracle Networking Between Server and Client machine using TNS listener. #OracleNetworking #ServerandClientmachine #TNSlistener Oracle database Unbeatable,Unbreakable Platform..
Views: 13638 Oracle World
what is the maximum size of a Oracle datafile ?
 
01:46
How big a Oracle datafile can get ? References: https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3083.htm#REFRN23049 Music: https://www.bensound.com
Views: 56 ORA-600
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: 1263 Praveen Biyyapu
Oracle Database 12c: Creating a User using Oracle Enterprise Manager Database Express
 
07:02
Demo of how to create a user with EM Express.
Views: 37439 OracleDBVision
5.How to Remap Tablespaces and Schema using Oracle Import/Export Tool
 
06:40
Hi guys in this video you learn How to Remap Tablespaces and Schema using Oracle Import/Export Tool. #RemapTablespaces #Remapschema #OracleImport/ExportTool Oracle database Unbeatable,Unbreakable Platform..
Views: 3027 Oracle World
Oracle Data Guard Tutorial - Open the Standby Read Only (Part 2 of 4)
 
16:49
This tutorial provides a quick review of what Data Guard is, and then goes on to show how you can extract value from Data Guard in every-day usage: how you can use it to enhance performance, and to reduce (yes, reduce!) your need for Oracle licences. Opening the standby database read-only. This has in fact been possible since the automation of redo transport and redo apply when it was first introduced in release 8i. Redo is received on the standby database but is not applied. So the redo is written to the RFS, slave to standby logs, archive to standby logs into archive logs but there's no apply done. So recoverability is not compromised. There's still no danger being lots of data. You're still receiving. The thing is open read-only. What does that mean? It means you can run queries against it. You can offload all your heavyweight queries from the primary to the standby. When I say all of them, even queries that require vast massive temporary space, those horrendous queries, those doing hash joins between multi gigabyte tables, they'll be generating many gigabytes of temporary data. You can write temporary data. Provided that you're using proper temporary tablespaces which you're certain you should be, you can run any query no matter how big, no matter how much temporary data it needs. You can also write audit data and this is important because with version 11, there's quite a lot of auditing enabled by default. By default, that auditing goes to the database, writing database tables. And you can't write to a database table in a read-only database. That we can configure for automatic switching and direct the audit records to the operating system or the trail instead. The queries you run, why is this such a good facility? First, you're taking stress off the primary. I'm sure that we're all DBAs here and we all know how difficult it is to tune your database or a concurrent workload that includes both high volume DML and includes heavyweight queries. Basically, you can't tune that way at all. Offloading the queries to the physical standby will reduce a lot of stress from the primary. So your DML should run significantly better and you can even do a certain amount of tuning on the standby to tune for optimal query performance. The most obvious tuning one would do, would be the memory parameters. No one could for example give the primary a massive PGA aggregate target and the much smaller SGA target or use indeed automatic memory management, perhaps cell tuning. One can adjust many parameters to do with tuning the optimizer to drive the optimizer to a certain execution plan, to exploit the environments. All that can be done on an open read-only database. How does one do it? It really couldn't be simpler. If we look at my physical standby here, this thing database role, physical standby - and if we select the open mode from v$ database, we find this in mount mode. How do we actually open at read-only? First off, we have to stop the recovery process because remember redo is received but no applied. You have to cancel the recovery. So "alter database recover managed standby database cancel." That will give us a read consistent version of the database. The command is intelligent enough to know that there might be incomplete transactions. Long-run transactions could've been partially received. We will end up with a read consistent version. To cancel it, all we do is alter database open read-only. It is that simple.
Views: 3149 SkillBuilders
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: 814 Praveen Biyyapu
Oracle DBA Justin - How to rename a tablespace, and a datafile in an Oracle database # 1 of 3
 
13:54
How to rename a tablespace, and a datafile in an Oracle database
Views: 6036 jbleistein11
Creating Tablespace using Oracle Enterprise Manager
 
05:02
STEPS: 1. Login into Enterprise manager 2. click on server tab - tablespace 3. inside tablespace window you can found default tablespace Example Sysaux System Temp Undo Users Now we going to create our own table-space, To create a new tablespace just click create button on right hand side 4. Now enter Tablespace name, Select extent management type as: Local Type: you can select permanent , temp, undo NOTE: Permanent tablespace:- Data persistent beyond duration of a session or transcation, objects in permanent tablespaces are stored in datafile. Temporary tablespace:- It contain objects only for a session or transcation, objects are stored in temp files Undo tablespacee:- It store data permanently, it important role is to provide read consistency for SELECT statement. the ability to rollback a transcation if it is failed to commit. Status: read,write mode 5. Click on add button to add datafile give name for datafile, size then give ok Thank you for watching Blog:- http://ramprasath91.blogspot.in/
Views: 4276 TechWizard
Oracle DBA Justin - How to rename a tablespace, and a datafile in an Oracle database # 3 of 3
 
03:51
Oracle DBA Justin - How to rename an tablespace, and a datafile in an Oracle database
Views: 2533 jbleistein11
4. Логическая и физическая структура данных СУБД Oracle
 
15:21
1. Логическая структура: табличные пространства, сегменты, экстенты, блоки 2. Физическая структура: файлы данных, журналы повтора, контрольные файлы, файлы параметров, файлы паролей, архивные логи, системный лог, файлы трассировок 3. Табличное пространство. Временное табличное пространство. UNDO TABLESPACE 4. Режимы работы табличного пространства: online, offline, read only Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
Oracle DBA Justin - How to rename a tablespace in an Oracle database
 
02:46
How to rename a tablespace in an Oracle database
Views: 1235 jbleistein11
Oracle DBA Justin - How to drop/delete a tablespace from an Oracle database
 
16:10
How to drop/delete a tablespace from an Oracle database
Views: 3516 jbleistein11
How to create an user and to grant all privileges to them in Oracle database
 
03:52
This video shows you how to create a new user and to grant privileges to them. Syntax to create a new user: create user username identified by password
Views: 37322 Thamizharasan Mohan
How to restore tablespace in case of NO backup
 
14:09
In this video i'm going to show you how to restore tablespace in case of no backup using RMAN.
Views: 1443 OCP Technology
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;
Migration from Non-Container to PDB database-PART I- Oracle 12C Administration
 
09:30
Non-Container Name =NCDB convert to PDB-NCDB Container DB Name=CDB =========================== Steps for Conversion. Step 1. Cleanly Shutdown the Non-CDB Database Instance. ==- set environment to NCDB ==- sqlplus / as sysdba ==- Shutdown immediate Step 2. Once You Have Cleanly Shutdown the Database, Start Up the database in Mount Exclusive Mode and Open the Database in Read-Only Mode. ==- set environment to NCDB ==- sqlplus / as sysdba ==- startup mount exclusive ==- alter database open read only; Step 3. Generate a Pluggable Database Manifest File from the Non-Container Database. ==- set environment to NCDB ==- sqlplus / as sysdba ==- exec dbms_pdb.describe (pdb_descr_file=-'E:\app\oracle\manifest\NCDB_manifest_file.xml'); Step 4. Shutdown the NON-CDB file Once Step 3 Completes Successfully. ==- Set environment to NCDB ==- sqlplus / as sysdba ==- shutdown immediate Step 5. Start the CDB (CDB) if it’s Not Already Up and Check the Compatibility with CDB. ==- set environment to CDB ==- sqlplus / as sysdba ==- startup (If not up) ==- Run below at SQL prompt. SET SERVEROUTPUT ON; DECLARE Compatible CONSTANT VARCHAR2(3) :=CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY (pdb_descr_file =- 'E:\app\oracle\manifest\NCDB_manifest_file.xml') WHEN TRUE THEN 'YES' ELSE 'NO' END; BEGIN DBMS_OUTPUT.PUT_LINE(compatible); END; / Step 6. Once it Completes Successfully, Query PDB_PLUG_IN_VIOLATIONS View from CDB Database for Any Errors. ==- set environment to CDB ==- sqlplus / as sysdba ==- select name, cause, type, message, status from PDB_PLUG_IN_VIOLATIONS where name='NCDB'; Note: "There should be no violations reported. If there are any, you need to fix it before proceeding". Step 7. Connect to the CDB Where Database has to be Plugged in Using the Noncdb Manifest File and Plug the PDDB12C Database. ==- set environment to CDB ==- sqlplus / as sysdba ==- CREATE PLUGGABLE DATABASE NCDB USING 'E:\app\oracle\manifest\NCDB_manifest_file.xml' COPY FILE_NAME_CONVERT = ('E:\APP\ORACLE\ORADATA\NCDB\', 'E:\app\oracle\oradata\CDB1\'); Note: "Below options are supported and you can chose one based on the env" 1) COPY: The datafiles of noncdb remains intact and it is copied to create PDBs at new locations and keep original datafiles intact at the original location. (This would mean that a noncdb database would still be operational after the creation of a PDB). 2) MOVE: The datafiles of noncdb are moved to a new location to create a PDB. In this case, noncdb database would not be available after a PDB is created. NOCOPY: The datafiles of noncdb are used to create a PDB2 and it uses same existing location. In this case, a noncdb database would not be available after a PDB is created. You can use FILE_NAME_CONVERT parameter to specify the new location of the datafiles while using COPY or MOVE option. Step 8. Once Step 7 Completes Successfully, Switch to the PDB Container and Run the "$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql". ==- set environment to CDB ==- sqlplus / as sysdba ==- alter session set container=NCDB ==- @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql Step 9. Startup the PDB and Check the Open Mode. ==- set environment to CDB ==- sqlplus / as sysdba ==- ALTER PLUGGABLE DATABASE OPEN; ==-SELECT name, open_mode FROM v$pdbs;
Views: 864 ANKUSH THAVALI
Oracle Database 12c: Moving Online Data Files
 
04:07
About moving online data files Oracle Database 12c new feature, with examples.
Views: 5280 OracleDBVision
How to work with Tablespaces in Real-Time? Tablespace Administration
 
01:00:59
https://dbagenesis.com/p/oracle-11g-advanced-dba Oracle tablespace administration - Learn how to work on tablespaces in real-time. - Tablespace management tasks - Tablespace utilization - Add space to tablespace - Add new tablespace - Tablespace best practices - Drop tablespace A tablespace is constructed by Oracle from one or more operating system files through the use of the CREATE TABLESPACE command. Every Oracle database consists of at least one tablespace, called SYSTEM.
Views: 15517 DBA Genesis
Oracle DBA Justin - How to change the name of an Oracle database # 1 of 2
 
16:11
How to change the name of an Oracle database
Views: 10167 jbleistein11
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: 1828 dbWatch As
How to create and managed tablespace in oracle
 
12:09
How to create and managed tablespace in oracle step by setp
Views: 137 database exert
8.Oracle Data Guard 11g - Overview Logical Standby Database
 
23:03
Hi guys today topic is very important in Data Guard logical standby apply all changes using SQL APPLY and opened in read write mode for real application testing. #DataGuardConfiguration #LogicalStandbyDatabase Oracle database Unbeatable,Unbreakable Platform..
Views: 3897 Oracle World
RENAME DATAFILE - ORACLE
 
09:17
In this video I explain in detail how to change the datafile to a tablespace .. Like !!!
Views: 605 FULL-ORACLE
Oracle Data Guard - Active Data Guard - Overview - DG Video 5
 
04:32
In this video you will learn about the benefits/features of using Active Data Guard in an Oracle Database. The features include Real Time Query, Fast Incremental Backups at the Standby site and Automatic Block recovery... . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 7804 Ramkumar Swaminathan
[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: 15 Exam Videos
Oracle DBA Tutorial || Oracle DBA Start up and Shutdown modes by shiva
 
15:14
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Reorganizing Tables in Oracle
 
07:45
The clip explains why reorganizing of tables may or may not be required and how to do it. Text version is here: https://uhesse.com/2010/08/23/reorganizing-tables-in-oracle-is-it-worth-the-effort/
Oracle DBA Justin - How to put an Oracle database in restricted session mode
 
09:30
How to put an Oracle database in restricted session mode
Views: 2568 jbleistein11
Oracle Database 11g: Import schema objects
 
08:19
Import schema objects: The Export and Import utilities provide a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations. When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), if any. The extracted data is written to an export dump file. The Import utility reads the object definitions and table data from the dump file. An export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different site. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a network. The files can also be used as backups in addition to normal backup procedures. Export dump files can only be read by the Oracle Import utility. The version of the Import utility cannot be earlier than the version of the Export utility used to create the dump file. Follow me: https://www.facebook.com/Oracle-DB-592800217490198/ Oracle Database 11g: Export schema objects Oracle Database11g: How to uninstall oracle 11g from windows 7 | Uninstall 11g | Deinstall 11g How to install Oracle Database 11g on windows 7 easy and step by step
Views: 6359 Leen's Tech
What is the view in oracle? simple view? complex view?
 
07:41
What is view? What is Simple View? What is Complex View? Are DML's allowed on view? Differance between "Simple" & "Complex" view? List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 615 Siva Academy
Why should we configure limits.conf for Oracle database
 
21:16
Real time example - As Oracle DBA, you must have installed Oracle database software on UNIX platforms. But why did you configure limits.conf file ? This blog will help you understand with a real time example. Want Oracle DBA training? check www.orskl.com/training Whatsapp: +919951696808
Views: 1709 OrSkl Academy
Migration of  Non-Container Database to Pluggable-PART II- Oracle 12C Administration
 
37:16
Non-Container Name =NCDB convert to PDB-NCDB Container DB Name=CDB =========================== Steps for Conversion. Step 1. Cleanly Shutdown the Non-CDB Database Instance. ==- set environment to NCDB ==- sqlplus / as sysdba ==- Shutdown immediate Step 2. Once You Have Cleanly Shutdown the Database, Start Up the database in Mount Exclusive Mode and Open the Database in Read-Only Mode. ==- set environment to NCDB ==- sqlplus / as sysdba ==- startup mount exclusive ==- alter database open read only; Step 3. Generate a Pluggable Database Manifest File from the Non-Container Database. ==- set environment to NCDB ==- sqlplus / as sysdba ==- exec dbms_pdb.describe (pdb_descr_file=-'E:\app\oracle\manifest\NCDB_manifest_file.xml'); Step 4. Shutdown the NON-CDB file Once Step 3 Completes Successfully. ==- Set environment to NCDB ==- sqlplus / as sysdba ==- shutdown immediate Step 5. Start the CDB (CDB) if it’s Not Already Up and Check the Compatibility with CDB. ==- set environment to CDB ==- sqlplus / as sysdba ==- startup (If not up) ==- Run below at SQL prompt. SET SERVEROUTPUT ON; DECLARE Compatible CONSTANT VARCHAR2(3) :=CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY (pdb_descr_file =- 'E:\app\oracle\manifest\NCDB_manifest_file.xml') WHEN TRUE THEN 'YES' ELSE 'NO' END; BEGIN DBMS_OUTPUT.PUT_LINE(compatible); END; / Step 6. Once it Completes Successfully, Query PDB_PLUG_IN_VIOLATIONS View from CDB Database for Any Errors. ==- set environment to CDB ==- sqlplus / as sysdba ==- select name, cause, type, message, status from PDB_PLUG_IN_VIOLATIONS where name='NCDB'; Note: "There should be no violations reported. If there are any, you need to fix it before proceeding". Step 7. Connect to the CDB Where Database has to be Plugged in Using the Noncdb Manifest File and Plug the PDDB12C Database. ==- set environment to CDB ==- sqlplus / as sysdba ==- CREATE PLUGGABLE DATABASE NCDB USING 'E:\app\oracle\manifest\NCDB_manifest_file.xml' COPY FILE_NAME_CONVERT = ('E:\APP\ORACLE\ORADATA\NCDB\', 'E:\app\oracle\oradata\CDB1\'); Note: "Below options are supported and you can chose one based on the env" 1) COPY: The datafiles of noncdb remains intact and it is copied to create PDBs at new locations and keep original datafiles intact at the original location. (This would mean that a noncdb database would still be operational after the creation of a PDB). 2) MOVE: The datafiles of noncdb are moved to a new location to create a PDB. In this case, noncdb database would not be available after a PDB is created. NOCOPY: The datafiles of noncdb are used to create a PDB2 and it uses same existing location. In this case, a noncdb database would not be available after a PDB is created. You can use FILE_NAME_CONVERT parameter to specify the new location of the datafiles while using COPY or MOVE option. Step 8. Once Step 7 Completes Successfully, Switch to the PDB Container and Run the "$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql". ==- set environment to CDB ==- sqlplus / as sysdba ==- alter session set container=NCDB ==- @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql Step 9. Startup the PDB and Check the Open Mode. ==- set environment to CDB ==- sqlplus / as sysdba ==- ALTER PLUGGABLE DATABASE OPEN; ==-SELECT name, open_mode FROM v$pdbs; ==================================== 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: 752 ANKUSH THAVALI
Oracle tutorial : Global Temporary Table In Oracle PL SQL
 
08:49
Oracle tutorial : Global Temporary Table In Oracle PL SQL create temp table sql This video will explain to you how to create Temporary Tables in Oracle Oracle tutorial : Global Temporary Table In Oracle 1)The data in such a table is stored only as long as the session or transaction lasts and is private for each session. 2)The definition is visible to all sessions. 3)After commit or disconnection, the data is lost but the definition of the table remains. 4)Indexes created on a temporary. 5)Scope of TRUNCATE command is a single database session. There is no effect of TRUNCATE on other sessions. 6)Foreign key constraints are not applicable in case of Temporary tables 7)Temporary tables cannot contain column of persistent collection type Syntax : CREATE GLOBAL TEMPORARY TABLE table_name ( column_name column_data_type … … ) ON COMMIT DELETE ROWS; CREATE GLOBAL TEMPORARY TABLE Emp ( id number(5) NOT NULL, name varchar2(50) NOT NULL, city varchar2(50) NOT NULL ) ON COMMIT DELETE ROWS INSERT INTO Emp VALUES (1, ‘Test1’, ‘city1’); INSERT INTO Emp VALUES (2, ‘Test2’, ‘city2’); INSERT INTO Emp VALUES (3, ‘Test3’, ‘city3’); SELECT COUNT(*) FROM emp; Result = 3 rows COMMIT; SELECT COUNT(*) FROM emp; Result = 0 rows For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond oracle temporary table create temporary table sql temp table
Views: 4094 Tech Query Pond
Oracle Database 11g: Export schema objects
 
04:14
Export schema objects: The Export and Import utilities provide a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations. When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), if any. The extracted data is written to an export dump file. The Import utility reads the object definitions and table data from the dump file. An export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different site. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a network. The files can also be used as backups in addition to normal backup procedures. Export dump files can only be read by the Oracle Import utility. The version of the Import utility cannot be earlier than the version of the Export utility used to create the dump file. Follow me: https://www.facebook.com/Oracle-DB-592800217490198/ Oracle Database 11g: Import schema objects Oracle Database11g: How to uninstall oracle 11g from windows 7 | Uninstall 11g | Deinstall 11g How to install Oracle Database 11g on windows 7 easy and step by step
Views: 1081 Leen's Tech
User and Schema - DbArch Video 33
 
04:31
In this video you will understand whats the difference between an Oracle User and Schema. You will also get to know about some of the most frequently created objects in a Schema. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 5824 Ramkumar Swaminathan
Oracle DBA Justin - How to setup multiple archived log locations for an Oracle database
 
10:30
How to setup multiple archived log locations for an Oracle database
Views: 4867 jbleistein11
How to Create a Dblink Between Two Oracle Database oracle12c/11g
 
18:06
"Must Watch" How to Create a Dblink Between Two Oracle Database oracle12c/11g instance in different machine. #CreateaDblink #Oracle Database12c/11g Oracle database Unbeatable,Unbreakable Platform..
Views: 11477 Oracle World