- Make the tablespace Read-Only = alter tablespace xxxx read only;
- Export it connecting as sys as sysdba = exp file=tt.dmp log=tt.log tablespaces=xxxx transportable_tablespaces=y
- Copy the .dmp file and the data_files to the destination
- Put the tablespace back in write mode = alter tablespace xxxx read write;
- In the destination offline and drop the tablespace if exists
- Import = imp file=tt.dmp log=tt.log tablespaces=test transportable_tablespace=y datafiles=(......., ........)
Monday, July 26, 2004
Oracle - Transportable Tablespaces
Sunday, July 25, 2004
Sqlserver database maintenance--Free disk space.
schedule a job which uses the undocumented call xp_fixeddrives Or you can try with master..xp_cmdsh
Oracle :: Disk I/O, Events, Waits
Datafile I/O
DATAFILE I/O NOTES:
select NAME,
PHYRDS "Physical Reads",
round((PHYRDS / PD.PHYS_READS)*100,2) "Read %",
PHYWRTS "Physical Writes",
round(PHYWRTS * 100 / PD.PHYS_WRTS,2) "Write %",
fs.PHYBLKRD+FS.PHYBLKWRT "Total Block I/O's"
from (
select sum(PHYRDS) PHYS_READS,
sum(PHYWRTS) PHYS_WRTS
from v$filestat
) pd,
v$datafile df,
v$filestat fs
where df.FILE# = fs.FILE#
order by fs.PHYBLKRD+fs.PHYBLKWRT desc
Subscribe to:
Posts (Atom)