[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference rocks::dec_edi

Title:	DEC/EDI
Notice:	DEC/EDI V2.1 - see note 2002
Moderator:	METSYS::BABER

Created:	Wed Jun 06 1990
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	3150
Total number of notes:	13466

3051.0. "Oracle7 More Table Spaces?" by SCASS1::HARRISON (Systems Integration - EDI) Wed Mar 12 1997 15:53

    Hi,
    
    A customer called today wanting to create more Oracle7 table spaces for
    the DEC/EDI database instance.  Is there a problem with the customer
    doing this?  Are there any problems with the decedi_config dump/load
    after this is done?  Are there any other issues that would cause the
    recommendation to be 'no'?
    
    Thanks,
    
    Don

T.R	Title	User	Personal Name	Date	Lines
3051.1	It's in the userguide so....	UTRTSC::SMEETS	Workgroup support	`Wed Mar 12 1997 17:26`	6
	Hi Don, Just have a look at the DEC/EDI V3.1A user guide page 16-12 "Changing the size of your Oracle7 database. Martin
3051.2	More tablespaces?	SCASS1::HARRISON	Systems Integration - EDI	`Wed Mar 12 1997 19:29`	10
	Martin, The customer wants to specifically add another (or additional) tablespaces than just the MINDEX tablespace. Extending the database as described in the manual is no problem (they have already done this). Can additional tablespaces be created and tables reallocated accordingly (and still be supported within the DEC/EDI environment?). Don
3051.3	May cause problems down the line	METSYS::HELLIAR	http://samedi.reo.dec.com/	`Thu Mar 13 1997 08:01`	11
	Don, We create tables and indexes in SPECIFIC tablespeaces. Any future version migration scripts MIGHT rely on that fact. So, unless the customer has some real reason as to why there need to be multiple tablespaces then I'd leave well alone. V3.1A Backup and restore do a complete oracle database dump or load, so the actual tablespaces involved should be irrelevant. Graham