XML Database (MOSC)

MOSC Banner

column xmltype appears with creator's username

edited Jan 20, 2010 7:55AM in XML Database (MOSC) 3 commentsAnswered ✓
Hi,
Suppose I (user1) create a table with a column of type XMLType in the schema APP:

user1> create table app.t (a xmltype);

If user2 describes the table, he sees:

user2> desc app.t

Name           Null?          Type
---------------------------------------------------
a                                  user1.xmltype

Why? Why the XMLType is being referencing the user who created the table? It shouldn't be just XMLType, or at least, app.xmltype?

TKS
Flavio

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center