Space required in database

[Former Member]

DATABASE(ORACLE)

OS: WINDOWS

Hi all, before install an ehp i see some prerequisites in the space of database.

The document says that you need approximately 50GB of space in database.

 Free space in the database	Approximately 50 GB

The question is, in which tablaspace i need to assign this space, because at operative system level i have the required space.

Or in others words what's mean need approximately 50GB of space in database

PSAPEL700D	LOCAL	SYSTEM	AUTO
PSAPES700D	LOCAL	SYSTEM	AUTO
PSAPTEMP	LOCAL	UNIFORM	MANUAL*
PSAPUNDO	LOCAL	SYSTEM	MANUAL
SYSAUX	LOCAL	SYSTEM	AUTO
 
PSAPBTABD	DICTIONARY	USER	MANUAL
PSAPBTABI	DICTIONARY	USER	MANUAL
PSAPCLUD	DICTIONARY	USER	MANUAL
PSAPCLUI	DICTIONARY	USER	MANUAL
PSAPDDICD	DICTIONARY	USER	MANUAL
PSAPDDICI	DICTIONARY	USER	MANUAL
PSAPDOCUD	DICTIONARY	USER	MANUAL
PSAPDOCUI	DICTIONARY	USER	MANUAL
PSAPLOADD	DICTIONARY	USER	MANUAL
PSAPLOADI	DICTIONARY	USER	MANUAL
PSAPPOOLD	DICTIONARY	USER	MANUAL
PSAPPOOLI	DICTIONARY	USER	MANUAL
PSAPPROTD	DICTIONARY	USER	MANUAL
PSAPPROTI	DICTIONARY	USER	MANUAL
PSAPROLL	DICTIONARY	USER	MANUAL
PSAPSOURCED	DICTIONARY	USER	MANUAL
PSAPSOURCEI	DICTIONARY	USER	MANUAL
PSAPSTABD	DICTIONARY	USER	MANUAL
PSAPSTABI	DICTIONARY	USER	MANUAL
PSAPUSER1D	DICTIONARY	USER	MANUAL
PSAPUSER1I	DICTIONARY	USER	MANUAL
SYSTEM	DICTIONARY	USER	MANUAL

[former_member204746 · Accepted solution]

Hi,

when you will run the PREPARE phase, it will tell you exactly what it needs and where it needs it.

so, let PREPARE module do the work for you.

PREPARE will even supply BRSAPCE command to use to increase datafiles/tablespaces!

Edited by: Eric Brunelle on Feb 8, 2011 12:32 PM

[Former Member · Accepted solution]

thanks, that have sense.