| External Tables / System Tablespace [message #276871] |
Fri, 26 October 2007 10:01  |
51stpvv
Messages: 2
Registered: October 2007
|
Junior Member |
|
|
Re: External tables
We use external tables extensively. I understand where the data is stored. (Have an Oracle directory tied to a Unix file system defined, read,write granted on the directory).
The problem is - I noticed many of the external tables are linked to the SYSTEM Tablespace. Don't know how that's happening since the shell script used to create them does not explicitly specify SYSTEM. After thinking about this I concluded it's not a big deal - no data is actually being stored in SYSTEM Tablespace.
I'm guessing the only thing being stored is metadata about the tables, and if the table is dropped (many are temporary - for the life of a job - people just forget to clean up after themselves) then I cold stop worrying about SYSTEM Tablespace being chewed up by External tables
Thoughts?
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
