Home » RDBMS Server » Server Administration » External Tables / System Tablespace (Oracle enterprise Edition - 9i 9.2.0.7)
External Tables / System Tablespace [message #276871] Fri, 26 October 2007 10:01 Go to next message
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?
Re: External Tables / System Tablespace [message #276879 is a reply to message #276871] Fri, 26 October 2007 10:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

I noticed many of the external tables are linked to the SYSTEM Tablespace.

How? This is not possible, external tables are not linked to any tablespace.

Regards
Michel

Re: External Tables / System Tablespace [message #276885 is a reply to message #276871] Fri, 26 October 2007 10:50 Go to previous messageGo to next message
51stpvv
Messages: 2
Registered: October 2007
Junior Member
When I view them in Enterprise Manager, the Tablespace shown is, in many cases 'SYSTEM', in some others an application tablespace.
Re: External Tables / System Tablespace [message #276886 is a reply to message #276885] Fri, 26 October 2007 10:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So, it is EM bug, you can raise a SR, if you have a CSI.

Regards
Michel
Re: External Tables / System Tablespace [message #277014 is a reply to message #276871] Sat, 27 October 2007 23:48 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

@OP, what versions you have?
Previous Topic: Strange applicaton problem of :Rebuild of indices
Next Topic: USER PRIVS Migration from 9i to 10g
Goto Forum:
  


Current Time: Sat Dec 10 15:03:34 CST 2016

Total time taken to generate the page: 6.44651 seconds