#95 Configurable temporary tablespace

v1.7
closed
Patrick Wolf
5
2014-08-14
2008-01-10
Frank Puechl
No

Hi Patrick,

I found that in bigger databases there might exist more than one temporary tablespace or maybe the temporary tablespace is not named TEMP. I would recommend to allow a selection for the temporary tablespace when creating the user for APEXLIB. This requires changes on the file "ApexLib_create_apexlib_schema.sql"

Just add the followings lines below the line 58 (DEFINE apexlib_tablespace = "&apexlib_tablespace"):
PROMPT .
PROMPT . Enter temporary tablespace for &apexlib_schema_name schema.
PROMPT . eg: TEMP or any other existing temporary tablespace.
PROMPT .
DEFINE apexlib_temp_tablespace = "&apexlib_temp_tablespace"

Change the line 73 (old line 68) from "TEMPORARY TABLESPACE TEMP" into "TEMPORARY TABLESPACE &apexlib_temp_tablespace".

Cheers,
Frank

Discussion

  • Patrick Wolf
    Patrick Wolf
    2008-01-10

    • milestone: 699946 --> v1.7
    • assigned_to: nobody --> patrick_wolf
    • status: open --> closed
     
  • Patrick Wolf
    Patrick Wolf
    2008-01-10

    Logged In: YES
    user_id=1449836
    Originator: NO

    Thanks Frank! I have changed the installation file.

    Patrick