Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XML DB and large files

467738Jun 6 2007 — edited Jun 17 2007

Hi,
I am trying to understand how XML DB works with the schema based objects on Oracle 9.2.0.8.
When I register a schema, several tables are created on my XML DB schema, for example for the purchaseOrder sample, I will have the purchaseOrder table, the comments table, the description table, ... one for each node in the XML.

Then I insert a big XML into the table purchaseOrder.

Question is: When are the other tables populated? If I count(*), I only have one record stored in the puchaseOrder, so how are the other tables populated. Do I have to populate them manually?

Please clarify because I didn't find any detail on this on the documentation.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 15 2007

Added on Jun 6 2007

#performance-availability, #xml-db

3 comments

913 views