export full of a database.
Posted on 2011-09-09
I need to do a full export of my database. I am planning to first kill all the current sessions, put the database in restricted mode and do the full export.
a) How can i identify and kill all the users sessions ?
b) How can i check which users has the privelige to connet even when the database is in restricted mode ?
c) What rollback segments problems i could have ?
d) Any tips or consideration for doing an export to a 1Tb database ?
e) I will use the expdp for the export.
f) How much time could the export take ?
g) How big the size of the export file could be ?