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

Creating Managing Droping Oracle Database Tablespaces

84 ratings | 20823 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 (11 months ago)
Thanks! it was useful
Fun&pc laughter (11 months ago)
thank you sir
Hermann Steinrucks (1 year ago)
Very well explained Asif and I also understood your english easily.
siddhartha rao (2 years 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.