RE: Datafile size for backup consideration...

Creating tablespace having smaller datafile size with autoextend flag.

How does it sound???

Sandeep.

	-----Original Message-----
	From:	Slamet Fusianto [SMTP:yangken_at_cbn.net.id]
	Sent:	Thursday, July 20, 2000 7:56 AM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Datafile size for backup consideration...

	Dear DBAs,

	When we first create tablespace (user, index, temporary, etc) and
datafiles,
	should we consider a large amount of datafiles ? What I mean is now
I make one
	datafile for tablespace User is 500 MB. I consider this to be for 3
years ahead.
	Now if I take backup for this tablespace only (for example), it will
surely make
	tape backup full after couple of weeks (capacity of tape backup is 4
GB it means
	that if I take full backup every week, the tape will be fulled in 2
months).
	Sure how many tape backups will be used is not our prime
considerations, but
	cost will not be so high.
	But I want to ask is should I make a smaller data file, just say 50
MB and then
	after running few months, I can add extents or make new datafiles
for this
	tablespace. Or perhaps just make directly 500 MB ?

	Thank you for the answer.


	Regards,

	Slamet Fusianto



	-- 
	Author: Slamet Fusianto
	  INET: yangken_at_cbn.net.id

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L
	(or the name of mailing list you want to be removed from).  You may
	also send the HELP command for other information (like subscribing).