Home
Videos uploaded by user “Abbasi Asif”
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: 19675 Abbasi Asif
How to Use RMAN Backup Command to perform Full and Incremental Backups of database
 
12:07
How to Use RMAN Backup Command to perform Full and Incremental Backups of database
Views: 22253 Abbasi Asif
Create Oracle 11g Database using DBCA
 
10:52
Creating Oracle 11g Database using Database Creation Assistant DBCA Oracle Database Creation
Views: 36829 Abbasi Asif
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 166031 Abbasi Asif
Recovery Manager RMAN Architecture
 
14:14
Oracle Recovery Manager Architecture Concepts Utility Use Configuration
Views: 30704 Abbasi Asif
How to Create and Execute RMAN Backup Scripts part 01
 
10:58
How to Create and Execute RMAN Backup Scripts part 01
Views: 13390 Abbasi Asif
How to Create Oracle Duplicate Database with Recovery Manager RMAN Part 01
 
12:54
How to Create Oracle Duplicate Database with Recovery Manager RMAN Part 01
Views: 15766 Abbasi Asif
How To Use Configure Command of  RMAN part 01
 
08:18
How To Use Configure Command of RMAN part 01
Views: 5617 Abbasi Asif
Enable Disable Block Change Tracking in Oracle
 
04:49
Enable Disable Block Change Tracking in Oracle
Views: 1282 Abbasi Asif
How To Configure and Use RMAN with Recovery Catalog and Target Database Part 02
 
14:01
How To Configure and Use RMAN with Recovery Catalog and Target Database Part 02
Views: 10599 Abbasi Asif
How To Configure and Use RMAN with Recovery Catalog and Target Database Part 01
 
07:20
How To Configure and Use RMAN with Recovery Catalog and Target Database
Views: 11124 Abbasi Asif
How To Configure Oracle Database in Flashback Mode
 
11:39
How To Configure Oracle Database in Flashback Mode; Configure Flashback related parameters; Enable / Disable Flashback mode
Views: 11180 Abbasi Asif
Oracle E-Business Suite Cloning on Linux Virtual Machine Part 02
 
20:30
Oracle E-Business Suite Cloning on Linux Virtual Machine Part 02
Views: 7029 Abbasi Asif
How to Create Oracle Duplicate Database with Recovery Manager RMAN Part 02
 
12:21
How to Create Oracle Duplicate Database with Recovery Manager RMAN Part 01
Views: 9458 Abbasi Asif
Oracle Database Users / User Management (Simple)
 
09:33
Create, Alter, Drop, Grant Rights, Default Tablespace, Temporary Tablespace, Quota Setup, View Users Information, Lock / Unlock user account select username,account_status,default_tablespace, temporary_tablespace,created from dba_users; create user myuser identified by myuser; alter user myuser quota unlimited on mytbs; alter user myuser quota 100m on mytbs; alter user temporary tablespace temp; alter user myuser default tablespace mytbs; alter user myuser accout unlock; alter user myuser account lock; alter user myuser password expire; alter user myuser identified by youuser; create user myuser identified by myuser default tablespace users temporary tablespace temp quota unlimited on users; grant create session, resource to myuser; grant create session, resource to myuser with grant option; drop user asif; drop user asif cascade;
Views: 39749 Abbasi Asif
How to use Oracle SQL Loader sqlldr to load data into table from text file
 
11:37
How to use Oracle SQL Loader sqlldr to load data into table from text file create table emp(empno number(10),ename varchar(30)); insert into emp values(10,'asif'); set echo off newpage 0 space 0 pagesize 0 feed off head off trimspool on spool d:\oradata\sqlloader\data.txt select empno || ',' || ename from emp; spool off delete emp; update file named data.txt create a file named control.txt load data infile 'd:\oradata\sqlloader\data.txt' into table emp fields terminated by "," optionally enclosed by '"' ( empno, ename ) sqlldr asif/asif control=d:\oradata\sqlloader\control.txt
Views: 45372 Abbasi Asif
How To Flashback a Table to particular SCN in Oracle
 
08:38
How To Flashback a Table to particular SCN in Oracle
Views: 5544 Abbasi Asif
Oracle E-Business Suite Cloning on Linux Virtual Machine Part 01
 
28:49
Oracle E-Business Suite Cloning on Linux Virtual Machine Part 01
Views: 12978 Abbasi Asif
Oracle E-Business Suite Installation on Linux in Virtual Environment Part 01
 
43:00
Oracle E-Business Suite Installation on Linux in Virtual Environment Part 01
Views: 15216 Abbasi Asif
Create Oracle 11g Duplicate Database on Same Machine without RMAN
 
21:15
Creating Oracle 11g Duplicate / Clone Database on Same Maching without using Recovery Manager
Views: 11688 Abbasi Asif
EBS R12 Services Management Starting Stoping Checking the Status
 
17:03
EBS R12 Services Management Starting Stoping Checking the Status adcmctl.sh adoacorectl.sh adoafmctl.sh adformsctl.sh adapcctl.sh adstpall.sh adstrtal.sh addbctl.sh addlnctl.sh concurrent manager / application server / form server / discoverer server / database server / listener
Views: 9297 Abbasi Asif
How To Configure Oracle Database  in ArchiveLog Mode
 
09:47
How To Configure Oracle Database in ArchiveLog Mode / NoArchiveLog Mode
Views: 3828 Abbasi Asif
Oracle E-Business Suite Installation on Linux in Virtual Environment Part 02
 
21:29
I created this video with the YouTube Video Editor (http://www.youtube.com/editor)
Views: 5414 Abbasi Asif
How to Create and Execute RMAN Backup Scripts part 02
 
11:17
How to Create and Execute RMAN Backup Scripts part 02
Views: 6216 Abbasi Asif
Convert Database Cooked File System to ASM File System in Oracle Part 01
 
12:39
Convert Database Cooked File System to ASM File System in Oracle Part 01 1) Convert control file to asm instance 2) Convert datafiles to asm instance 3) Convert tempfiles to asm instance 4) Convert log files to asm instance
Views: 1724 Abbasi Asif
Convert Database ASM File System to Cooked File System in Oracle Part 01
 
06:03
Convert Database ASM File System to Cooked File System in Oracle Part 01
Views: 1535 Abbasi Asif
Convert Database ASM File System to Cooked File System in Oracle Part 02
 
11:18
Convert Database ASM File System to Cooked File System in Oracle Part 02
Views: 937 Abbasi Asif
Attending citizenship ceremony
 
01:00
Attending citizenship ceremony
Views: 257 Abbasi Asif
How To Use Configure Command of  RMAN part 02
 
11:48
How To Use Configure Command of RMAN part 02
Views: 3755 Abbasi Asif
Convert Database Cooked File System to ASM File System in Oracle Part 02
 
07:54
Convert Database Cooked File System to ASM File System in Oracle Part 02 1) Convert control file to asm instance 2) Convert datafiles to asm instance 3) Convert tempfiles to asm instance 4) Convert log files to asm instance
Views: 1506 Abbasi Asif
Kiama Blowhole NSW
 
00:54
Views: 52 Abbasi Asif