Hi Hussein

You can make a backup of database, tablespace or datafile BUT never ever just backup the datafile
using an OS command while the database is running unless you have issued the command
"alter tablespace <tablespace_name> begin backup" in a database that is running in archive log mode.
If your database is not running in archive log mode you need to shut it down first.
However, this is a rather outdated way of backing up an Oracle database. Oracle (and I) recommend
using RMAN (Oracle Recovery Manager) for any backup, copy or move of an Oracle database.

What do you mean with "all users in system tablespace"? Only Oracle system users should have
system as default tablespace if any. No other.

Regards

Måns Axell
<http://www.trivadis.com/>

________________________________

Von: Hussein Korkomaz [mailto:oracledba-ezmlmshield-x70724949.[Email address protected]
Gesendet: Di 7/3/2007 09:18
An: LazyDBA Discussion
Betreff: table space system









Greetings





If I make backup for table space system in this case all users who have
table space system will backup or what ?



What is the different between make backup for table space system and make
backup for system datafile ?



Bets regards,

Hussein Korkomaz

































---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page