Oracle Table spaces

 Oracle Table spaces

  • SYSTEM (tablespace for the Oracle dictionary)
  • SYSAUX (additional tablespace as of Oracle database 10g)
  • PSAPTEMP (default tablespace for database sort operations)
  • PSAPUNDO/PSAPROLL (default tablespace for segment undo/rollback)
  • PSAP<SCHEMA_ID> (default tablespace for all SAP objects of the ABAP stack)
  • PSAP<SCHEMA_ID>DB (default tablespace for all SAP objects of the Java stack)
  • PSAP<SCHEMA_ID>USR (default tablespace for all customer objects)
  • PSAP<SCHEMA_ID><REL> (default tablespace for release-dependent data)
  • PSAP<SCHEMA_ID<NAME> (Additional tablespace for example, for large tables)

Post a Comment

0 Comments

  PFile and SPFile in oracle