Search code examples
oracle-databasefunctionproceduretablespace

How to Define Function/Procedure in Oracle in User Defined TABLESPACE

I know that we can create tables in Oracle in user defined TABLESPACE using TABLESPACE keyword, but I can't find anywhere how to define functions/procedures in user defined TABLESPACE.

Can someone help please with details ?

Thanks

Solution

  • You can't. Procedures are stored in data dictionary, and it resides in the SYSTEM tablespace.