Skip to Main Content
Forums

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle equivalent of SQL Server's "FOR XML" and "OPENXML"

570715Jun 4 2007 — edited Jun 6 2007
Hi

Can someone please tell what are the Oracle's equivalent of SQL Server's "FOR XML" and "OPENXML" features?

Comments

Avi Miller-Oracle
Srividhya.PM wrote:
We have a OEL 5.5 server with OCFS2 installed used for Oracle Ebusiness suite.
You'll probably need to upgrade to Oracle Linux 5 Update 7 and the UEK to get OCFS2 with ACL support.
Dude!
The problem with "operation not supported" was already noted in 2009 and supposed to be fixed in a maintenance release.

http://oss.oracle.com/osswiki/OCFS2/NewFeaturesList
If EA's are turned on, the file system will now automatically support POSIX ACLS and selinux.

Do you have ocfs2-tools package installed?

What happens if you enable extended attributes:

mount -o remount,rw,user_xattr,noatime /APPL_TOP

You can see "man mount.ocfs2" for explanation of mount options.

Edited by: Dude on Sep 13, 2011 12:47 AM
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 4 2007
Added on Jun 4 2007
#database-and-application-migrations
3 comments
3,612 views