this video will help how to reclaim space from the table.
Views: 1803
oracdb
1.Shrink the Table:
Shrinking is started from 10g. In this method I’m using user u1 and table name sm1.
Now I’m deleting some rows in sm1
COUNT
----------
1048576
Table sm1 has 1048576 rows.
[email protected]: delete from sm1 where deptno=10;
262144 rows deleted.
I deleted above number of rows.
Rows COUNT
----------
786432
And I’m giving commit
[email protected]: commit;
Commit complete.
So now we have 786432 rows in sm1 table. Now see the following command
[email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS';
OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS
----- --------------- ------------- ------------- ------ ---------- ----------
U1 U1TS SM1 TABLE 29 mb 3712 44
After I deleted some rows in sm1 table still above result showing same values, so now our duty is shrink this table.
This is done by following 2 ways,
i By using COMPACT key word:
In this method shrinking is done in two phases. In the first phase all fragmented space are just defragmented, but still the High Water Mark is persist with last used block only. That mean used free blocks are not de allocated and HWM is not updated here. Issue the following command before use shrink command.
[email protected] alter table sm1 enable row movement;
Table altered.
There is particular use with above command, when we shrink the table all rows are moves to contiguous blocks, so here row movement should be done. By default the row movement is disabled for any table, so above command enabled the row movement. Then execute shrink command now.
[email protected]: alter table sm1 shrink space compact;
Table altered.
Now see the space of table by using below command.
[email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS';
OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS
----- --------------- ------------- ------------- ------ ---------- ----------
U1 U1TS SM1 TABLE 29 mb 3712 44
So here seems nothing happened with above shrink command, but internally the fragmented space is defragmented. But the high water mark is not updated, used free blocks are also not de allocated.
For de allocating the used blocks we have to execute below command. This is the second phase.
[email protected]: alter table sm1 shrink space;
Table altered.
Now see the space by using below command.
[email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS';
OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS
----- --------------- ------------- ------------- ---------- ---------- ----------
U1 U1TS SM1 TABLE 20.8125 mb 2664 36
So now the space of sm1 table is reduced.
Note: Actually the alter table sm1 shrink space command will complete these two phases of the shrinking of table at a time. But here we done shrink process in two phases because when we use alter table sm1 shrink space command the table locked temporarily some time period, during this period users unable to access the table. So if we use alter table sm1 shrink space compact command the table is not locked but space is defragmented. When we not in business hours issue the second phase shrink command then users are won’t get any problem.
ii Because of above method the table dependent objects are goes to invalid state, to overcome this problem we have to use below command.
[email protected]: alter table sm1 shrink space cascade;
Table altered.
The above command also shrinks the space of all dependent objects. We also do this in two phases like above two phases. See the below command.
[email protected]: alter table sm1 shrink space compact cascade;
Table altered.
And then
[email protected]: alter table sm1 shrink space cascade;
Table altered.
Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A
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
Views: 6878
BhagyaRaj Katta
Hello
Today I am showing you how to create tablespace.
Alter tablespace datafile using fileid & filename and resize datafile.
How to check Tablespace Size.
How to check datafile Size in MB.
How to drop Tablespace including contents and all Datafiles of these tablespace.
Views: 1528
Parag Mahalle
In this video you will learn how to learn tablespace to add new datafile,or add existing datafile in tablespace. You will also learn how to list available tablespace and datafile in oracle database engine. At the end you will learn how to drop tablespace.
For Support
===========
Email: [email protected]
Contact Form: http://www.learninhindi.com/home/contact
Our Social Media
================
Facebook: https://www.facebook.com/LearnInHindi
Twitter: https://twitter.com/LearnInHindi
For Training & Videos
=====================
For more videos and articles visit:
http://www.learninhindi.com
Free Java Programming In Hindi Course
=====================================
https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH
Free Oracle PL/SQL Programming In Hindi Course
==============================================
https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6
Free C Programming In Hindi Course
==================================
https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq
Trips & Tricks Channel
======================
https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw
Programming in Hindi Channel
============================
https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 26032
ITORIAN
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: 1726
dbWatch As
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: 21448
Abbasi Asif
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: 870
ORACLE-BASE.com
Welcome Back to KSH Infotainment.
Datafile Resize in Oracle.
Activity done on Oracle 11g ASM DB.
Used Queries:
=============
set lines 200 pages 200
select df.tablespace_name "Tablespace", totalusedspace "Used MB", (df.totalspace - tu.totalusedspace) "Free MB",
df.totalspace "Total MB", round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace)) "Pct. Free"
from (select tablespace_name, round(sum(bytes) / 1048576) TotalSpace
from dba_data_files
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name from dba_segments group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name
order by 1;
set linesize 200
set pagesize 2000
COLUMN tablespace_name format a10
COLUMN file_name format a45
COLUMN free% format a7
SELECT df.tablespace_name,SUBSTR (df.file_name, 1, 60) file_name, df.bytes / 1024 / 1024 allocated_mb,
round(((df.bytes / 1024 / 1024) – NVL (SUM (dfs.bytes) / 1024 / 1024, 0)),1) used_mb,
round(NVL (SUM (dfs.bytes) / 1024 / 1024, 0),2) free_space_mb
FROM dba_data_files df, dba_free_space dfs
WHERE df.FILE_ID = dfs.file_id(+)
GROUP BY df.tablespace_name, dfs.file_id, df.file_id , df.bytes, df.file_NAME
ORDER BY df.tablespace_name;
Views: 53
KSH Infotainment
while we are taking FULL DATABASE BACKUPS , first we need to know the SIZE OF OUR DATABASE. so that if we know the size we can make that much of space available for the backup. so, this video explains how to find the FULL DATABASE SIZE.
Views: 3918
P-Square Technologies
In this video i'm going to demonstrate you how to resize the redolog file step by step, this is only one method to resize the redolog file.
Views: 2359
OCP Technology
In this tutorial, you'll learn how to set linesize and pagesize .
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database.
PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces.
PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard.
The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3]
PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables.
PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7]
The StepSqlite product is a PL/SQL compiler for the popular small database SQLite.
PL/SQL Program Unit
A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database.
The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label.
Package
Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are:
Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation.
Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 17581
radhikaravikumar
How to Check Tablespace Size in SQL Developer | Oracle SQL Developer Tips and Tricks
Oracle SQL Tutorial for Beginners
Oracle Database Tutorial for Beginners
Oracle SQL Developer Tips and Tricks
Oracle Tutorial for Beginners
Oracle Tutorial
How to Check Tablespace Size in SQL Developer
How to Check Tablespace Size in Oracle SQL Developer
How to Monitor Tablespace Size in Oracle SQL Developer
How to Monitor Tablespace Size in SQL Developer
how to check tablespace in oracle sql developer
how to check tablespace size in oracle 12c
how to check particular tablespace size in oracle
how to check tablespace size in gb in oracle
how to check tablespace name in oracle
how to check freespace in tablespace in oracle 11g
how to check tablespace size in oracle 11g
how to check freespace in oracle database
How to Check Storage of Tablespace Size in SQL Developer
How to Check Storage of Tablespace Size in Oracle SQL Developer
how to check tablespace in oracle
how to check tablespace size in oracle 12c
what is tablespace in oracle
how to check tablespace in oracle sql
oracle list tablespaces in schema
how to find tablespace used by a user in oracle
how to check particular tablespace size in oracle
oracle create tablespace
Views: 438
Oracle PL/SQL World
steps to relocate a table to a new tablespace
Views: 2997
Wysheid Wysheid
http://www.itconvergence.com/ - This Oracle EBS R12.2.4 video focuses on the enhancements of Rich table interactions within the E-Business Suite. The new rich features improve the usability and look and feel of classic and advanced tables:
Hide/Show column
Reset to default
Refresh table
Hide/Show column
Reorder column
Resize column
Horizontal scroll
#R12.2.4
#Oracle EBS R12.2.4
#EBS R12.2.4
#R12.2.4 Videos
Views: 1162
IT Convergence, Inc.
انشاء جدول - Create Table
...........................................................
تواصل معانا علي الفيس بوك من هنا :
https://www.facebook.com/askgad
...........................................................
تواصل معانا علي موقعنا من هنا :
https://www.askgad.com
Views: 1216
Ask Gad
--------------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;
Views: 30
ABA Tech Learning Hub
In this video you will learn about Create Tablespace, Create User, Create Role, Drop Role, Drop User, Drop Tablespace in PL/SQL Oracle.
For Support
===========
Email: [email protected]
Contact Form: http://www.learninhindi.com/home/contact
Our Social Media
================
Facebook: https://www.facebook.com/LearnInHindi
Twitter: https://twitter.com/LearnInHindi
For Training & Videos
=====================
For more videos and articles visit:
http://www.learninhindi.com
Free Java Programming In Hindi Course
=====================================
https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH
Free Oracle PL/SQL Programming In Hindi Course
==============================================
https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6
Free C Programming In Hindi Course
==================================
https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq
Trips & Tricks Channel
======================
https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw
Programming in Hindi Channel
============================
https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 15466
ITORIAN
How to increase/decrease memory_target in 11g
======================================================
oracle 10g --sga_target (parameter new in 10g)
oracle 11g --memory_target (parameter new in 11g)
How to check whether the parameter is static or dynamic?
=========================================================
select name, value, issys_modifiable from v$parameter where name like '%¶meter%' ;
if issys_modifiable=false --- parameter is static (database bounce required)
if issys_modifiable=immediate --- parameter is dynamic (database bounce not required)
(note: consider using spfile)
sql commands
================
show parameter memory;
alter system set memory_target=350m scope=spfile;
alter system set memory_max_target=350m scope=spfile;
Views: 5005
Praveen Biyyapu
How to leverage advanced functionality in UI tables including column reordering and resizing, fetch as needed, and content formatting. Related blog - https://blogs.oracle.com/vbcs/advanced-capabilities-for-the-table-components-in-visual-builder-tips
Views: 419
Oracle Visual Builder Cloud Service
This video is the part of Oracle Database Self learn Kit From Wysheid. In this video we discuss about the creation and management of bigfile tablespaces in an Oracle database
Views: 2359
Wysheid Wysheid
Learn how easy it is to make $100k and above by becoming an Oracle Database Administrator.
Website: https://newayitsolutions.com
Subscribe: https://newayitsolutions.com/page
Enroll: https://newayitsolutions.com/enroll
Youtube: newayitsolutions
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Follow on Facebook: https://www.facebook.com/newayitsolutions/
Follow on Twitter: https://twitter.com/Theoracledbaguy
Follow on Instagram: https://www.instagram.com/oracledbatrainer/
Financing Available: https://newayitsolutions.com/loan-application
School Locations: Atlanta, Maryland, Virginia
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Office Contact: 1-866-569-0205
Mobile Contact: 240-244-9935
Views: 3678
NewayITSolutions LLC
By Vivek Saxena Insa Shabad Coachings Shamli
Resumable Space Allocation is given by extending the data file size with a open database
Alter session enable resumable;
Create tablespace spr datafile 'c:\db3\data\spr1a.dbf' size 100k;
Create table spr(rn number(10) tablespace spr;
Insert into spr(select salary from hr.employees);
Insert into spr (select * from spr);
Set oracle_sid= orcl
Sqlplus/nolog
Conn/as syadba
Alter database datafile 'c:\db3\data\spr1a.dbf' resize 300k;
Views: 38
Shabad(शब्द) Coachings
This Video will teach you
How to Move Object one Table Space to Another | How to Rebuild the Index ?
move table from one tablespace to another in oracle 11g
oracle move schema to another tablespace
oracle how to move objects to another tablespace
oracle 11g move schema to another tablespace
alter table move tablespace oracle 8i
oracle move table script
oracle move cluster to new tablespace
oracle move table example
rebuild index oracle script
alter index rebuild online parallel
oracle rebuild all indexes
oracle index rebuild online vs offline
oracle rebuild partitioned index
index rebuild oracle best practice
index rebuild script in oracle 11g
Views: 967
Oracle PL/SQL World
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: 1203
ANKUSH THAVALI
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: 15148
Manish Sharma
Learn Table Auditing using DML Triggers in Oracle Database and Increase the level of security by keep an eye on user tempering your table data.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : http://bit.ly/table-auditing
Previous Tutorial
► DML Triggers with Examples https://youtu.be/-OR7zLzCh_I
► Select-Into Statement: https://youtu.be/F5eMJhwmCQs
►Sysdate Blog : http://bit.ly/sysdate-in-oracle-by-rebellionrider
-------------------------------------------------------------------------
►►►Let's Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.
-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
You can also Email me at
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: 71812
Manish Sharma
Bigfile Tablespace 12c | Oracle Bigfile Tablespace | Create Bigfile Tablespace Oracle 12c Example
---------------------------------------------------------------------------------------------------
oracle bigfile tablespace advantages,create bigfile tablespace oracle 12c example,how to resize bigfile tablespace in oracle,bigfile tablespace 12c,oracle bigfile tablespace performance issues,oracle bigfile tablespace max size,create bigfile tablespace in asm,create tablespace oracle 12c example,big file tablespace, small file tablespace, permanent tablespace, sql tutorials for beginners, sql developer, sql expert, oracle dba tutorials, sql tutorials, oracle bigfile tablespace, big tablespace in oracle, big file temporary tablespace, big file tablespace management, bigfiletablespace in oracle, bigfile tablespace in oracle, tablespace management videos,
oracle 12c,oracle 12c download,oracle database 12c,oracle client 12c,oracle 12c new features,uninstall oracle 12c,oracle xe 12c,oracle 12c documentation,oracle 12c installation,
sql tutorials for beginners, sql expert, sql expert tutorials, database, oracle, table, online training,insert into oracle,oracle insert into multiple rows,create table oracle,oracle 12c alter table add identity column,oracle create table default value sysdate,collections in oracle pl sql with examples,Oracle 12c, database, oracle database (software), sql, sql developer, sql tutorials, how to create database using dbca, how to create database in oracle,oracle cloud, database 12c, dba genesis,database services, database, create, 11g, dba, db, beginner,
Please Subscribe My Channel
Views: 49
Learning With Mahamud
Add extra datafile to exixting tablespace, how to drop the extra datafile, how to reuse a datafile, how to make a tablespace offline n online.
Views: 12066
DbaRocksOracle
This video shows you advanced properties of pivot table in obiee 11g and obiee 12c
Views: 4942
Tutorials for beginners
Resize Column of JTable.
Views: 364
Cambodia Academy Official
Video tutorials on how Manage Oracle Tablespaces using Oracle Enterprise Manager 12C
For more Database Administration articles and scripts go to www.aodba.com More Articles, Scripts and How-To Papers on http://www.aodba.com
Views: 7187
AO DBA
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: 31521
Manish Sharma
Let’s, Make In Java…!
You can SUBSCRIBE Mr.DIpak SOnar's YouTube Channel at :
Mr.DIpak SOnar's YouTube Channel at :https://www.youtube.com/channel/UCGh1eIxU394O57YSRrhOMdg
DIpak SOnar | Facebook Page - https://www.facebook.com/mrdipaksonar
DIpak SOnar | Facebook Profile - https://www.facebook.com/mrdipaksonarofficial
Mr.DIpak SOnar (@mrdipaksonar) - https://twitter.com/mrdipaksonar
Mr.DIpak SOnar | Instagram - https://www.instagram.com/mrdipaksonarofficial/
-~-~~-~~~-~~-~-
Please watch: "Made iN Java - How to PRINT COMMENTS in Java"
https://www.youtube.com/watch?v=ReIPigBDGcM
-~-~~-~~~-~~-~-
Views: 2038
Mr.DIpak SOnar
move table from one tablespace to other
Views: 1127
Jamaal Khan
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: 4173
TechWizard
This video will give you basic idea about tablespace issue.
Plese find the following important query .
Query to check tablespace usage
==============================================
select a.TABLESPACE_NAME,
a.BYTES bytes_used,
b.BYTES bytes_free,
b.largest,
round(((a.BYTES-b.BYTES)/a.BYTES)*100,2) percent_used
from
(
select TABLESPACE_NAME,
sum(BYTES) BYTES
from dba_data_files
group by TABLESPACE_NAME
)
a,
(
select TABLESPACE_NAME,
sum(BYTES) BYTES ,
max(BYTES) largest
from dba_free_space
group by TABLESPACE_NAME
)
b
where a.TABLESPACE_NAME=b.TABLESPACE_NAME
order by ((a.BYTES-b.BYTES)/a.BYTES) desc;
To check datafiles respective to tablespace_name.
========================================================
col tablespace_name format a30;
col file_name format a40;
SELECT TABLESPACE_NAME, FILE_NAME, BYTES/1024/1024 FROM DBA_DATA_FILES where TABLESPACE_NAME='&tablespace_name';
To check ASM disk group usage
========================================
select name, group_number, name, type, state, total_mb, free_mb from v$asm_diskgroup;
Please comment , like, subscribe and reach me if you have any query.
EmailId: [email protected]
================================================
Hi Folks,
Greetings!!
I am professional part time oracle dba trainer and having good experience in oracle database administration.
This is the right place to enroll yourself for Oracle DBA real time course.
Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily.
Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge.
Mobile No : + 91 9960262955 (WhatsApp Number)
EmailID: [email protected]
Views: 846
ANKUSH THAVALI
Administrasi Basis Data
Andy Zamroji - 2110167033
Views: 389
Andy Zamroji
In this video, I will cover two important steps of Installing Linux alongside your windows OS.
1) Choosing the correct Partition scheme
2) Setting up your Windows Boot loader to boot to Linux instead of Linux bootloader (e.g : GRUB)
During a standard Linux installation, a user do not have to worry about this. But when you are trying to install Linux in separate partition, keeping your current OS, it gets little trickier. If you do not configure these two options correctly, you might end up corrupting your bootloader or previous OS installation.
I will also show how you can add your Linux os option to the Windows 8 bootloader using BCDedit. This is important so that in case in future if you decide to get rid of Linux OS, your computer boots normally without any issues.
Views: 85368
XPSTECH
made with ezvid, free download at http://ezvid.com
Views: 49
Pat Shuff
Oracle DBA | Adding Data File Existing Table Space | Bangla | DBA1-15
To See More DBA part-01 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUO3yQq7-LLdfQb5HpsQKNg
To See More DBA part-02 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUviefN3-ZzKDVgbIH0RoaS
To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY
To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU
Dear viewer, In this tutorial you will learn Adding Data File Existing Table Space
Adding Data File:
Command:
Connect sysdba
SQL-alter tablespace test1 add datafile 'E:\app\Administrator\oradata\orcl\dfile2.dbf' size 500m;
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: 78
OracleDB Solutions
SELECT salary FROM (SELECT salary FROM Employee ORDER BY salary DESC LIMIT 2) AS emp ORDER BY salary LIMIT 1;
Views: 642
Ashok Dhulipalla Makings
Blog Link : http://prasaddomala.com/how-to-increase-virtual-hard-disk-size-on-oracle-linux-virtual-machine/
Views: 16561
Prasad Domala
how to add images in ApEx with help of "Form on a Table with Report"
Views: 18835
Петя Иванов
Resize a VMs virtual drive using GPARTED.
this step follows an earlier increase in size performed by Oracle's VirtualBox which effectively increased the available size but did not utilise all of it until now!
Views: 24561
Mon Goose
Views: 140
Cihan Özhan
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: 762
Praveen Biyyapu
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: 1208
Praveen Biyyapu