Skip to Main Content

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!

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.

How do I use DTD's with XML DB ?

mdrake-OracleAug 24 2006 — edited Aug 24 2006
Assume I have an XML document containing a DOCTYPE that looks like this...
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> 
<plist version="1.0">
<dict>
	<key>Major Version</key><integer>1</integer>
	<key>Minor Version</key><integer>1</integer>
	<key>Application Version</key><string>6.0.5</string>
	<key>Features</key><integer>1</integer>
	<key>Music Folder</key><string>file://localhost/C:/My%20Documents/My%20Music/iTunes/iTunes%20Music/</string>
	<key>Library Persistent ID</key><string>08072423C5C39B39</string>
	<key>Tracks</key>
	<dict>
		<key>113</key>
		<dict>
			<key>Track ID</key><integer>113</integer>
			<key>Name</key><string>Speak to Me/Breathe in the Air</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>David Gilmour/Nick Mason/Richard Wright/Roger Waters</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>9500202</integer>
			<key>Total Time</key><integer>237479</integer>
			<key>Track Number</key><integer>1</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:06:59Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B48</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/01%20Speak%20to%20Me-Breathe%20in%20the%20Air.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>115</key>
		<dict>
			<key>Track ID</key><integer>115</integer>
			<key>Name</key><string>On the Run</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>David Gilmour/Roger Waters</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>8480282</integer>
			<key>Total Time</key><integer>211983</integer>
			<key>Track Number</key><integer>2</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:06:59Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B49</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/02%20On%20the%20Run.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>117</key>
		<dict>
			<key>Track ID</key><integer>117</integer>
			<key>Name</key><string>Time</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>David Gilmour/Nick Mason/Richard Wright/Roger Waters</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>17007482</integer>
			<key>Total Time</key><integer>425168</integer>
			<key>Track Number</key><integer>3</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:06:59Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B4A</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/03%20Time.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>119</key>
		<dict>
			<key>Track ID</key><integer>119</integer>
			<key>Name</key><string>The Great Gig in the Sky</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>Richard Wright</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>11484657</integer>
			<key>Total Time</key><integer>287085</integer>
			<key>Track Number</key><integer>4</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:06:59Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B4B</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/04%20The%20Great%20Gig%20in%20the%20Sky.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>121</key>
		<dict>
			<key>Track ID</key><integer>121</integer>
			<key>Name</key><string>Money</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>Roger Waters</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>15343842</integer>
			<key>Total Time</key><integer>383582</integer>
			<key>Track Number</key><integer>5</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:00Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B4C</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/05%20Money.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>123</key>
		<dict>
			<key>Track ID</key><integer>123</integer>
			<key>Name</key><string>Us and Them</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>Richard Wright/Roger Waters</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>18756812</integer>
			<key>Total Time</key><integer>468897</integer>
			<key>Track Number</key><integer>6</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:00Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B4D</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/06%20Us%20and%20Them.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>125</key>
		<dict>
			<key>Track ID</key><integer>125</integer>
			<key>Name</key><string>Any Colour You Like</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>David Gilmour/Nick Mason/Richard Wright</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>8225302</integer>
			<key>Total Time</key><integer>205609</integer>
			<key>Track Number</key><integer>7</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:00Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B4E</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/07%20Any%20Colour%20You%20Like.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>127</key>
		<dict>
			<key>Track ID</key><integer>127</integer>
			<key>Name</key><string>Brain Damage</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>Roger Waters</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>9219097</integer>
			<key>Total Time</key><integer>230452</integer>
			<key>Track Number</key><integer>8</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:00Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B4F</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/08%20Brain%20Damage.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>129</key>
		<dict>
			<key>Track ID</key><integer>129</integer>
			<key>Name</key><string>Eclipse</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>Roger Waters</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>5067312</integer>
			<key>Total Time</key><integer>126667</integer>
			<key>Track Number</key><integer>9</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:00Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B50</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/09%20Eclipse.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>157</key>
		<dict>
			<key>Track ID</key><integer>157</integer>
			<key>Name</key><string>Shine on You Crazy Diamond, Pts. 1-5</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>David Gilmour/Richard Wright/Roger Waters</string>
			<key>Album</key><string>Wish You Were Here</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>32523642</integer>
			<key>Total Time</key><integer>813061</integer>
			<key>Track Number</key><integer>1</integer>
			<key>Year</key><integer>1975</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:14Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:33Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B51</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Wish%20You%20Were%20Here/01%20Shine%20on%20You%20Crazy%20Diamond,%20Pts.%201-5.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>159</key>
		<dict>
			<key>Track ID</key><integer>159</integer>
			<key>Name</key><string>Welcome to the Machine</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>Roger Waters</string>
			<key>Album</key><string>Wish You Were Here</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>17855766</integer>
			<key>Total Time</key><integer>446380</integer>
			<key>Track Number</key><integer>2</integer>
			<key>Year</key><integer>1975</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:14Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:33Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B52</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Wish%20You%20Were%20Here/02%20Welcome%20to%20the%20Machine.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>161</key>
		<dict>
			<key>Track ID</key><integer>161</integer>
			<key>Name</key><string>Have a Cigar</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>Roger Waters</string>
			<key>Album</key><string>Wish You Were Here</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>12320401</integer>
			<key>Total Time</key><integer>307983</integer>
			<key>Track Number</key><integer>3</integer>
			<key>Year</key><integer>1975</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:14Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:33Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B53</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Wish%20You%20Were%20Here/03%20Have%20a%20Cigar.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>163</key>
		<dict>
			<key>Track ID</key><integer>163</integer>
			<key>Name</key><string>Wish You Were Here</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>David Gilmour/Roger Waters</string>
			<key>Album</key><string>Wish You Were Here</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>13609931</integer>
			<key>Total Time</key><integer>340218</integer>
			<key>Track Number</key><integer>4</integer>
			<key>Year</key><integer>1975</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:14Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:33Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B54</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Wish%20You%20Were%20Here/04%20Wish%20You%20Were%20Here.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>165</key>
		<dict>
			<key>Track ID</key><integer>165</integer>
			<key>Name</key><string>Shine on You Crazy Diamond, Pts. 6-9</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>David Gilmour/Richard Wright/Roger Waters</string>
			<key>Album</key><string>Wish You Were Here</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>29708412</integer>
			<key>Total Time</key><integer>742687</integer>
			<key>Track Number</key><integer>5</integer>
			<key>Year</key><integer>1975</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:14Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:33Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B55</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Wish%20You%20Were%20Here/05%20Shine%20on%20You%20Crazy%20Diamond,%20Pts.%206-9.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
	</dict>
	<key>Playlists</key>
	<array>
		<dict>
			<key>Name</key><string>Library</string>
			<key>Master</key><true/>
			<key>Playlist ID</key><integer>37</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B3A</string>
			<key>All Items</key><true/>
			<key>Playlist Items</key>
			<array>
				<dict>
					<key>Track ID</key><integer>113</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>115</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>117</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>119</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>121</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>123</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>125</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>127</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>129</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>157</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>159</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>161</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>163</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>165</integer>
				</dict>
			</array>
		</dict>
		<dict>
			<key>Name</key><string>90’s Music</string>
			<key>Playlist ID</key><integer>40</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B3B</string>
			<key>All Items</key><true/>
			<key>Smart Info</key>
			<data>
			AQEAAwAAAAIAAAAZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAA==
			</data>
			<key>Smart Criteria</key>
			<data>
			U0xzdAABAAEAAAABAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAcAAAEAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABEAAAAAAAAB8YAAAAAAAAAAAAAAAAAAAAB
			AAAAAAAAB88AAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAA=
			</data>
		</dict>
		<dict>
			<key>Name</key><string>My Top Rated</string>
			<key>Playlist ID</key><integer>43</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B3C</string>
			<key>All Items</key><true/>
			<key>Smart Info</key>
			<data>
			AQEAAwAAAAIAAAAZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAA==
			</data>
			<key>Smart Criteria</key>
			<data>
			U0xzdAABAAEAAAABAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABkAAAAQAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABEAAAAAAAAADwAAAAAAAAAAAAAAAAAAAAB
			AAAAAAAAADwAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAA=
			</data>
		</dict>
		<dict>
			<key>Name</key><string>Party Shuffle</string>
			<key>Playlist ID</key><integer>61</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B40</string>
			<key>Party Shuffle</key><true/>
			<key>All Items</key><true/>
			<key>Playlist Items</key>
			<array>
				<dict>
					<key>Track ID</key><integer>115</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>125</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>129</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>123</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>127</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>117</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>113</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>119</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>121</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>123</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>125</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>113</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>127</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>115</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>119</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>129</integer>
				</dict>
			</array>
		</dict>
		<dict>
			<key>Name</key><string>Podcasts</string>
			<key>Playlist ID</key><integer>64</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B41</string>
			<key>Podcasts</key><true/>
			<key>All Items</key><true/>
		</dict>
		<dict>
			<key>Name</key><string>Recently Added</string>
			<key>Playlist ID</key><integer>52</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B3F</string>
			<key>All Items</key><true/>
			<key>Smart Info</key>
			<data>
			AQEAAwAAAAIAAAAZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAA==
			</data>
			<key>Smart Criteria</key>
			<data>
			U0xzdAABAAEAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAIAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABELa4tri2uLa7//////////gAAAAAACTqA
			La4tri2uLa4AAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAA=
			</data>
			<key>Playlist Items</key>
			<array>
				<dict>
					<key>Track ID</key><integer>113</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>115</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>117</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>119</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>121</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>123</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>125</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>127</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>129</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>157</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>159</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>161</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>163</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>165</integer>
				</dict>
			</array>
		</dict>
		<dict>
			<key>Name</key><string>Recently Played</string>
			<key>Playlist ID</key><integer>49</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B3E</string>
			<key>All Items</key><true/>
			<key>Smart Info</key>
			<data>
			AQEAAwAAAAIAAAAZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAA==
			</data>
			<key>Smart Criteria</key>
			<data>
			U0xzdAABAAEAAAABAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABcAAAIAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABELa4tri2uLa7//////////gAAAAAACTqA
			La4tri2uLa4AAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAA=
			</data>
		</dict>
		<dict>
			<key>Name</key><string>Top 25 Most Played</string>
			<key>Playlist ID</key><integer>46</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B3D</string>
			<key>All Items</key><true/>
			<key>Smart Info</key>
			<data>
			AQABAwAAABkAAAAZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAA==
			</data>
			<key>Smart Criteria</key>
			<data>
			U0xzdAABAAEAAAABAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQBAAACAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			</data>
		</dict>
		<dict>
			<key>Name</key><string>Videos</string>
			<key>Playlist ID</key><integer>67</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B42</string>
			<key>All Items</key><true/>
			<key>Videos</key><true/>
		</dict>
	</array>
</dict>
</plist>
For those who are interested it's a Libary.xml generated when you export your library from Apple's iTunes

Comments

Levi Pereira

Yes you can, but not recommended for many reasons.


Check docs recommendation:

...

To use direct-attached storage (DAS) or storage area network (SAN) disks for Oracle ASM, each disk must have a partition table.

Oracle recommends creating exactly one partition for each disk that encompasses the entire disk.

Oracle recommends that you limit the number of partitions you create on a single disk to prevent disk contention. Therefore, you may prefer to use extended partitions rather than primary partitions.

...


Refer: http://docs.oracle.com/cd/E11882_01/install.112/e48194/storage.htm#CHDDDBDH


User_A7RKT

Thanks for pointing that out to me.

Now, my intention is to ask our Storage Admin to provide three LUNs as follows:

- OCRVoting Disk: of 3 GB size

- FRA Disk: of 4 GB (we aren't going to enable the DB flashback

- Data disk: depends on the db size.

Is my understanding right?


Thanks in advance.

BPeaslandDBA

The FRA is not required. But it is helpful. If you are going to run in archive log mode, then you will want the FRA or some other archive log destination.

I also create a +REDO disk to separate that from the data. Typically, with ASM, I have the following disk groups at a minimum:

+VOTE  (also holds OCR)

+REDO

+DATA

and then the optional:

+FRA

Cheers,
Brian

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 21 2006
Added on Aug 24 2006
4 comments
12,239 views