HomeОбразованиеRelated VideosMore From: Abbasi Asif

Creating Managing Droping Oracle Database Tablespaces

80 ratings | 19931 views
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;
Html code for embedding videos on your blog
Text Comments (10)
Artur Petrashov (8 months ago)
Thanks! it was useful
Nawaz Khan (8 months ago)
thank you sir
Hermann Steinrucks (1 year ago)
Very well explained Asif and I also understood your english easily.
siddhartha rao (1 year ago)
Very Clear explanation...Thanks a lot!
Geeta Tiku Goswami (2 years ago)
very good tutorial... Thanks
Hitesh Bajpai (2 years ago)
Thanks a lot Sir !
LovingLife (3 years ago)
Great tutorial. You get straight to the point... Thanks!
Peter Koranteng (3 years ago)
Good tutorial, learned a lot.
Prakash jha (4 years ago)
Thanks sir .Very helpful tutorial.
Carmelo Soberano (5 years ago)
Awesome tutorial! Thanks man!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.