SYSAUX for xml repository? [message #299103] |
Sat, 09 February 2008 06:31 |
Calamar
Messages: 1 Registered: February 2008
|
Junior Member |
|
|
Hi,
I'm new in the xml db oracle (10g).
With the command "create or replace directory XML_DIR as '/home/foo/xml';" I've created a DIRECTORY object that points where I saved the XML files. Now some questions worry me...
Is it a correct way to store xml files into oracle database?
In what tablespace has the directory XML_DIR been created?
I'm afraid the user SYS is the owner of this directory, though I've used my own user foo. Why? Is it this like that?
So, I think that XML DB Repository uses the SYSAUX, but I don't want to use it for that. What do I have to do to use another tablespace? Is it possible not to use SYSAUX?
Thank you in advance.
|
|
|