<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-602557221877923219</id><updated>2024-08-29T11:29:09.030-07:00</updated><category term="Content"/><category term="WebCenter"/><category term="Content Server"/><category term="Deployment"/><category term="Enterprise"/><category term="Infra"/><category term="Performance"/><category term="Production"/><category term="Proxy"/><category term="UCM"/><category term="WebLogic"/><category term="Database"/><category term="FileStoreProvider"/><category term="ILM"/><category term="LifeCycle"/><category term="Partitioning"/><category term="Repository"/><category term="Storage"/><category term="Web Server"/><category term="Web Tier"/><category term="iPlanet"/><title type='text'>The Content Rave</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://blog.contentra.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/602557221877923219/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://blog.contentra.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/05902870212161153936</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>3</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-602557221877923219.post-3157009104328681967</id><published>2012-05-31T11:00:00.000-07:00</published><updated>2012-05-31T13:33:49.379-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Content"/><category scheme="http://www.blogger.com/atom/ns#" term="Content Server"/><category scheme="http://www.blogger.com/atom/ns#" term="Deployment"/><category scheme="http://www.blogger.com/atom/ns#" term="Enterprise"/><category scheme="http://www.blogger.com/atom/ns#" term="Infra"/><category scheme="http://www.blogger.com/atom/ns#" term="iPlanet"/><category scheme="http://www.blogger.com/atom/ns#" term="Performance"/><category scheme="http://www.blogger.com/atom/ns#" term="Production"/><category scheme="http://www.blogger.com/atom/ns#" term="Proxy"/><category scheme="http://www.blogger.com/atom/ns#" term="UCM"/><category scheme="http://www.blogger.com/atom/ns#" term="Web Server"/><category scheme="http://www.blogger.com/atom/ns#" term="Web Tier"/><category scheme="http://www.blogger.com/atom/ns#" term="WebCenter"/><category scheme="http://www.blogger.com/atom/ns#" term="WebLogic"/><title type='text'>Configuring the iPlanet as web tier for Oracle WebCenter Content (UCM)</title><content type='html'>&lt;p&gt;If you are looking for configure the iPlanet as Web server/proxy to use with the Oracle WebCenter Content, you probably won’t found an specific documentation for that or will found some old complex notes related to the old 10gR3.  &lt;p&gt;This post will help you out with few simple steps.  &lt;p&gt;That’s the diagram of the test scenario, considering that you will deploy in production in an cluster environment.  &lt;p&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjM0l2PpSAVyiTv6AB8KT4VfrDEPCg87QUfBn6YjvfjO-MZFCFScviIVl46R9HanvRo-bl5QeLjkYqcH3MyNFf9WotqpsZTvwd-eJAchH0-Kyw4-JppnICPNOEbsmDsGTD27WzV4rQFguw/s1600-h/Sample-iPlanet-wcC-topology%25255B5%25255D.png&quot;&gt;&lt;img style=&quot;background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px&quot; title=&quot;Sample-iPlanet-wcC-topology&quot; border=&quot;0&quot; alt=&quot;Sample-iPlanet-wcC-topology&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKsqfNr9NpUpujF_aKhyfswhh_X8OVTLaTwY7Q4W02Tw-yQUY1q8A8SBZRPrjJygolXuGFkN3rMkrxNAiXcb5hvTRcei_MtVz9R31rMCphVJJddk6KbFARDJi0VnxNjV-NEaYyU4YIeok/?imgmax=800&quot; width=&quot;581&quot; height=&quot;379&quot;&gt;&lt;/a&gt;&amp;nbsp; &lt;p&gt;First you need the software, for our scenario you will need:  &lt;blockquote&gt; &lt;p&gt;- &lt;b&gt;Oracle iPlanet Web Server 7.0.15+&lt;/b&gt; (Installed)  &lt;p&gt;- &lt;b&gt;Oracle WebCenter Content 11gR1 PS5&lt;/b&gt; (Installed)  &lt;p&gt;- &lt;b&gt;Oracle WebLogic Web Server Plugins 11g (1.1)&lt;/b&gt;  &lt;p&gt;- &lt;strong&gt;Supported JDK (Using Oracle Java JDK 7u4 for the test)&lt;/strong&gt; &lt;p&gt;&lt;b&gt;- Certified Client OS&lt;/b&gt;  &lt;p&gt;- &lt;b&gt;Certified Server OS (Using Oracle Solaris 11 for the test)&lt;/b&gt;  &lt;p&gt;- &lt;b&gt;Certified Database (Using Oracle Database 11.2.0.3 for the test)&lt;/b&gt; &lt;/p&gt;&lt;/blockquote&gt; &lt;p&gt;&amp;nbsp; &lt;p&gt;Then the configuration:&lt;b&gt;&lt;/b&gt;  &lt;p&gt;- Download the latest plugin: &lt;br&gt;&lt;a href=&quot;http://www.oracle.com/technetwork/middleware/ias/downloads/wls-plugins-096117.html&quot;&gt;http://www.oracle.com/technetwork/middleware/ias/downloads/wls-plugins-096117.html&lt;/a&gt;  &lt;p&gt;- Extract the WLSPlugin11g-iPlanet7.0 in some folder, like &amp;lt;iPlanet_Home&amp;gt;/plugins/wls11&lt;b&gt;&lt;/b&gt;  &lt;p&gt;- Include the plugin reference to the magnus.conf:&lt;b&gt;&lt;/b&gt;  &lt;blockquote&gt; &lt;p&gt;If Unix (Solaris or Linux), include the line: &lt;/p&gt;&lt;/blockquote&gt; &lt;div style=&quot;border-bottom: silver 1px solid; text-align: left; border-left: silver 1px solid; padding-bottom: 4px; line-height: 12pt; background-color: #f4f4f4; margin: 20px 0px 10px; padding-left: 4px; width: 104.98%; padding-right: 4px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; height: 46px; max-height: 200px; font-size: 8pt; overflow: auto; border-top: silver 1px solid; cursor: text; border-right: silver 1px solid; padding-top: 4px&quot; id=&quot;codeSnippetWrapper&quot;&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot; id=&quot;codeSnippet&quot;&gt;Init fn=&lt;span style=&quot;color: #006080&quot;&gt;&quot;load-modules&quot;&lt;/span&gt; shlib=&lt;span style=&quot;color: #006080&quot;&gt;&quot;/apps/oracle/WebServer7/plugins/wls11/lib/mod_wl.so&quot;&lt;/span&gt;&lt;/pre&gt;&lt;/div&gt;&lt;br /&gt;&lt;blockquote&gt;&lt;br /&gt;&lt;p&gt;If Windows, Include the line:&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;/blockquote&gt;&lt;br /&gt;&lt;div style=&quot;border-bottom: silver 1px solid; text-align: left; border-left: silver 1px solid; padding-bottom: 4px; line-height: 12pt; background-color: #f4f4f4; margin: 20px 0px 10px; padding-left: 4px; width: 104.97%; padding-right: 4px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; height: 53px; max-height: 200px; font-size: 8pt; overflow: auto; border-top: silver 1px solid; cursor: text; border-right: silver 1px solid; padding-top: 4px&quot; id=&quot;codeSnippetWrapper&quot;&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; margin: 0em; padding-left: 0px; width: 103.37%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; height: 32px; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot; id=&quot;codeSnippet&quot;&gt;Init fn=&lt;span style=&quot;color: #006080&quot;&gt;&quot;load-modules&quot;&lt;/span&gt; shlib=&lt;span style=&quot;color: #006080&quot;&gt;&quot;D:\\oracle\\WebServer7\\plugins\\wls11\\lib\\mod_wl.dll&quot;&lt;/span&gt;&lt;/pre&gt;&lt;/div&gt;&lt;br /&gt;&lt;p&gt;&amp;nbsp; &lt;p&gt;- Include the proxy reference to the obj.conf of each instance:&lt;b&gt;&lt;/b&gt; &lt;/p&gt;&lt;br /&gt;&lt;div style=&quot;border-bottom: silver 1px solid; text-align: left; border-left: silver 1px solid; padding-bottom: 4px; line-height: 12pt; background-color: #f4f4f4; margin: 20px 0px 10px; padding-left: 4px; width: 112.68%; padding-right: 4px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; height: 210px; max-height: 200px; font-size: 8pt; overflow: auto; border-top: silver 1px solid; cursor: text; border-right: silver 1px solid; padding-top: 4px&quot; id=&quot;codeSnippetWrapper&quot;&gt;&lt;br /&gt;&lt;div style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot; id=&quot;codeSnippet&quot;&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: white; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;&amp;lt;Object name=&lt;span style=&quot;color: #006080&quot;&gt;&quot;weblogic&quot;&lt;/span&gt; ppath=&lt;span style=&quot;color: #006080&quot;&gt;&quot;*/cs/*&quot;&lt;/span&gt;&amp;gt;&lt;/pre&gt;&lt;!--CRLF--&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;Service fn=&lt;span style=&quot;color: #006080&quot;&gt;&quot;wl-proxy&quot;&lt;/span&gt; WebLogicCluster=&lt;span style=&quot;color: #006080&quot;&gt;&quot;wcc-node1:16201,wcc-node2:16202, wcc-node3:16203&quot;&lt;/span&gt; &lt;/pre&gt;&lt;!--CRLF--&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: white; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;&amp;lt;/Object&amp;gt;&lt;/pre&gt;&lt;!--CRLF--&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;&amp;nbsp;&lt;/pre&gt;&lt;!--CRLF--&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: white; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;&amp;lt;Object name=&lt;span style=&quot;color: #006080&quot;&gt;&quot;weblogic&quot;&lt;/span&gt; ppath=&lt;span style=&quot;color: #006080&quot;&gt;&quot;*/_dav/*&quot;&lt;/span&gt;&amp;gt;&lt;/pre&gt;&lt;!--CRLF--&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;Service fn=&lt;span style=&quot;color: #006080&quot;&gt;&quot;wl-proxy&quot;&lt;/span&gt; WebLogicCluster=&lt;span style=&quot;color: #006080&quot;&gt;&quot;wcc-node1:16201,wcc-node2:16202, wcc-node3:16203&quot;&lt;/span&gt; &lt;/pre&gt;&lt;!--CRLF--&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: white; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;&amp;lt;/Object&amp;gt;&lt;/pre&gt;&lt;!--CRLF--&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;&amp;nbsp;&lt;/pre&gt;&lt;!--CRLF--&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: white; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;&amp;lt;Object name=&lt;span style=&quot;color: #006080&quot;&gt;&quot;weblogic&quot;&lt;/span&gt; ppath=&lt;span style=&quot;color: #006080&quot;&gt;&quot;*/_ocsh/*&quot;&lt;/span&gt;&amp;gt;&lt;/pre&gt;&lt;!--CRLF--&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;Service fn=&lt;span style=&quot;color: #006080&quot;&gt;&quot;wl-proxy&quot;&lt;/span&gt; WebLogicCluster=&lt;span style=&quot;color: #006080&quot;&gt;&quot;wcc-node1:16201,wcc-node2:16202, wcc-node3:16203&quot;&lt;/span&gt; &lt;/pre&gt;&lt;!--CRLF--&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: white; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;&amp;lt;/Object&amp;gt;&lt;/pre&gt;&lt;!--CRLF--&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;&amp;nbsp;&lt;/pre&gt;&lt;!--CRLF--&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: white; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;&amp;lt;Object name=&lt;span style=&quot;color: #006080&quot;&gt;&quot;weblogic&quot;&lt;/span&gt; ppath=&lt;span style=&quot;color: #006080&quot;&gt;&quot;*/adfAuthentication/*&quot;&lt;/span&gt;&amp;gt;&lt;/pre&gt;&lt;!--CRLF--&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;Service fn=&lt;span style=&quot;color: #006080&quot;&gt;&quot;wl-proxy&quot;&lt;/span&gt; WebLogicCluster=&lt;span style=&quot;color: #006080&quot;&gt;&quot;wcc-node1:16201,wcc-node2:16202, wcc-node3:16203&quot;&lt;/span&gt; &lt;/pre&gt;&lt;!--CRLF--&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: white; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot;&gt;&amp;lt;/Object&amp;gt;&lt;/pre&gt;&lt;!--CRLF--&gt;&lt;/div&gt;&lt;/div&gt;&lt;br /&gt;&lt;blockquote&gt;&lt;br /&gt;&lt;p&gt;If you are using an single node setup, change the Service fn=…. line to something like:&lt;/p&gt;&lt;/blockquote&gt;&lt;br /&gt;&lt;div style=&quot;border-bottom: silver 1px solid; text-align: left; border-left: silver 1px solid; padding-bottom: 4px; line-height: 12pt; background-color: #f4f4f4; margin: 20px 0px 10px; padding-left: 4px; width: 97.5%; padding-right: 4px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; max-height: 200px; font-size: 8pt; overflow: auto; border-top: silver 1px solid; cursor: text; border-right: silver 1px solid; padding-top: 4px&quot; id=&quot;codeSnippetWrapper&quot;&gt;&lt;pre style=&quot;border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; font-size: 8pt; border-left-style: none; overflow: visible; padding-top: 0px&quot; id=&quot;codeSnippet&quot;&gt;Service fn=&lt;span style=&quot;color: #006080&quot;&gt;&quot;wl-proxy&quot;&lt;/span&gt; WebLogicHost=&amp;lt;wcc-server&amp;gt; WebLogicPort=16200&lt;/pre&gt;&lt;br&gt;&lt;/div&gt;&lt;br /&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;With these configurations, your should have the WebCenter Content UI working with the iPlanet, test it. [http://&amp;lt;web-server&amp;gt;/cs/]&lt;/p&gt;&lt;br /&gt;&lt;p&gt;With the UI working, the last step is to configure the WebDav:&lt;/p&gt;&lt;br /&gt;&lt;p&gt;- Go to the iPlanet Admin Console (usually &lt;a href=&quot;https://&amp;lt;web-server&amp;gt;:8989&quot;&gt;https://&amp;lt;web-server&amp;gt;:8989&lt;/a&gt;)&lt;/p&gt;&lt;br /&gt;&lt;p&gt;- Go to Configurations &amp;gt;&amp;gt; [instance] &amp;gt;&amp;gt; Virtual Servers &amp;gt;&amp;gt; [Virtual Server] &amp;gt;&amp;gt; WebDAV:&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzRVJl3B65vKSpXK9HYeNmCwYJnL2qzE-gjJlbYi2KMG2ynK0JBnY5egR561HAp02hi1R-Nc4YioUuxCIOMzXViaF5wUF2gECKrh3Byyt5Yor0W8Aen0qtpHLrJFJPjw8e2gqnzTp9DAs/s1600-h/iPlanet-WebDav-Configuration5.png&quot;&gt;&lt;img style=&quot;background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: block; float: none; border-top-width: 0px; border-bottom-width: 0px; margin-left: auto; border-left-width: 0px; margin-right: auto; padding-top: 0px&quot; title=&quot;iPlanet-WebDav-Configuration&quot; border=&quot;0&quot; alt=&quot;iPlanet-WebDav-Configuration&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQ56sRKQhkZMR3YXRRVVU7pK7vauf3aPW_TPg4wzs5NNj8KavZ49bLVJTFFWHL6YAp3iBAemnQoFlzdLfKTHUbH6KNBCSuOpzF6YVrLydowTziNwWbslv06aK6V1DzOANXUzY2VAjgn_U/?imgmax=800&quot; width=&quot;632&quot; height=&quot;252&quot;&gt;&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;- Click New&lt;/p&gt;&lt;br /&gt;&lt;p&gt;- Populate the URI with /cs/idcplg/webdav:&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPr50CfGcBICSyPkZjaCEj4KpPrS7VxfUpSVle8miF6VWgxnsQDfTnwm-M_y8mhlcoxUlo2GsELYQ6j1dssQOE3XLPpQbAZ4nO-0XVUjfDkcyzxcssgLp7UjMWfSCqi7cUI2T6rQOTz7c/s1600-h/iPlanet-WebDav-Configuration-Wizard4.png&quot;&gt;&lt;img style=&quot;background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: block; float: none; border-top-width: 0px; border-bottom-width: 0px; margin-left: auto; border-left-width: 0px; margin-right: auto; padding-top: 0px&quot; title=&quot;iPlanet-WebDav-Configuration-Wizard&quot; border=&quot;0&quot; alt=&quot;iPlanet-WebDav-Configuration-Wizard&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh56tI0p9j94qlcRzhTbUR7QyXcWy53Ji7Yq0skYu9EJaGU1yE-hw_qshQm52xJn4nSvKuLDcCe1F-ysur63jCtzocg-961BhyphenhyphennQNYegz-UK3wnc-aBWlYk9ENsGkfUOtVifs8gfVdeXtU/?imgmax=800&quot; width=&quot;629&quot; height=&quot;470&quot;&gt;&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;- Select “Anyone (No Authentication)”, the wc Content will take care of the security:&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSLQmiYnFmHwkhZZIVw_gKNZ8irPQZQlD7GHgNs0y2lciHsKHtP95ZOLcgsP3Q-b8mGavlEfMBNbP9BQBkbI0h6JeAtgfciaTncW9cyBsTBbNBbzOfn3WDeU0FfpbIqUOSOYRmXlma1ZA/s1600-h/iPlanet-WebDav-Configuration-Wizard-.png&quot;&gt;&lt;img style=&quot;background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px&quot; title=&quot;iPlanet-WebDav-Configuration-Wizard-Security&quot; border=&quot;0&quot; alt=&quot;iPlanet-WebDav-Configuration-Wizard-Security&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-BSfBvjMTestiqhG9iiAWS-oYYdwTp5EXhjbuh3-QORkN7v20Gze_yKjhjewrzWcyr22TjHxPvk1GSLkzEKimvhFJlvZ51Hj2-uyueNslB2DnhtWcAAqOUIwynoHKdc7PxDvMkYLZkR0/?imgmax=800&quot; width=&quot;631&quot; height=&quot;464&quot;&gt;&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;This will allow you to use the WebDav feature and the Desktop Integration Suite, including double-byte characters.&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGyvZy3Xz51PR1V5LYX6Ejs1G6LCW70WlweVKX4Q7BkUWHdg6-2wM3U2d4PxBhap6YSn9eQ4Y7coO8Xx1ZyJyvMi5DElaHEabJX4_NqxnbTVRxAYIw3WckruTRjTqGeHVaveovyiGoZJQ/s1600-h/DesktopIntegrationSuite-double-byte-.png&quot;&gt;&lt;img style=&quot;background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px&quot; title=&quot;DesktopIntegrationSuite-double-byte-test&quot; border=&quot;0&quot; alt=&quot;DesktopIntegrationSuite-double-byte-test&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg98UvWaAM8qVDLkfSicV49vPzr-gaIvsYXtbJONl7n0HcqaRdeNL9UPoro448C5M1iemvtvR_AXM_yPjfShD8P5ePxzm0rgh9bB9VqfezsyQUVyNnH0Y7SfNcCaXNlrXc1iq4B6dOD7o4/?imgmax=800&quot; width=&quot;630&quot; height=&quot;450&quot;&gt;&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;Another iPlanet tunes could be done, I can cover in the next post related to the iPlanet.&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;em&gt;&lt;font color=&quot;#4bacc6&quot; size=&quot;3&quot;&gt;&lt;a href=&quot;https://blogs.oracle.com/ATEAM_WEBCENTER/entry/configuring_the_iplanet_as_web&quot; target=&quot;_blank&quot;&gt;Cross-posted on the WebCenter A-Team Blog&lt;/a&gt;&lt;/font&gt;&lt;/em&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;em&gt;&lt;font color=&quot;#4bacc6&quot; size=&quot;3&quot;&gt;&lt;/font&gt;&lt;/em&gt;&amp;nbsp;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;font color=&quot;#4bacc6&quot; size=&quot;3&quot;&gt;Related posts:&lt;/font&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;font color=&quot;#4bacc6&quot; size=&quot;3&quot;&gt;- &lt;/font&gt;&lt;a href=&quot;http://blog.contentra.com/2011/07/using-web-proxy-server-with-webcenter_31.html&quot; target=&quot;_blank&quot;&gt;Using a Web Proxy Server with WebCenter Family&lt;/a&gt;&lt;/p&gt;  </content><link rel='replies' type='application/atom+xml' href='http://blog.contentra.com/feeds/3157009104328681967/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.contentra.com/2012/05/configuring-iplanet-as-web-tier-for.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/602557221877923219/posts/default/3157009104328681967'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/602557221877923219/posts/default/3157009104328681967'/><link rel='alternate' type='text/html' href='http://blog.contentra.com/2012/05/configuring-iplanet-as-web-tier-for.html' title='Configuring the iPlanet as web tier for Oracle WebCenter Content (UCM)'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/05902870212161153936</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKsqfNr9NpUpujF_aKhyfswhh_X8OVTLaTwY7Q4W02Tw-yQUY1q8A8SBZRPrjJygolXuGFkN3rMkrxNAiXcb5hvTRcei_MtVz9R31rMCphVJJddk6KbFARDJi0VnxNjV-NEaYyU4YIeok/s72-c?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-602557221877923219.post-6955569872034550596</id><published>2012-04-13T19:03:00.001-07:00</published><updated>2012-04-19T14:12:21.398-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Content"/><category scheme="http://www.blogger.com/atom/ns#" term="Content Server"/><category scheme="http://www.blogger.com/atom/ns#" term="Database"/><category scheme="http://www.blogger.com/atom/ns#" term="FileStoreProvider"/><category scheme="http://www.blogger.com/atom/ns#" term="ILM"/><category scheme="http://www.blogger.com/atom/ns#" term="LifeCycle"/><category scheme="http://www.blogger.com/atom/ns#" term="Partitioning"/><category scheme="http://www.blogger.com/atom/ns#" term="Performance"/><category scheme="http://www.blogger.com/atom/ns#" term="Repository"/><category scheme="http://www.blogger.com/atom/ns#" term="Storage"/><category scheme="http://www.blogger.com/atom/ns#" term="UCM"/><category scheme="http://www.blogger.com/atom/ns#" term="WebCenter"/><title type='text'>Partitioned Repository for WebCenter Content using Oracle Database 11g</title><content type='html'>One of the biggest challenges for content management solutions is related to the storage management due the high volumes of the unstoppable growing of information.  &lt;br /&gt;
Even if you have storage appliances and a lot of terabytes, thinks like backup, compression, deduplication, storage relocation, encryption, availability could be a nightmare.  &lt;br /&gt;
One standard option that you have with the Oracle WebCenter Content is to store data to the database. And the Oracle Database allows you leverage features like compression, deduplication, encryption and seamless backup.  &lt;br /&gt;
But with a huge volume, the challenge is passed to the DBA to keep the WebCenter Content Database up and running.  &lt;br /&gt;
One solution is the use of DB partitions for your content repository, but what are the implications of this? Can I fit this with my business requirements?  &lt;br /&gt;
Well, yes. It’s up to you how you will manage that, you just need a good plan. During you “storage brainstorm plan” take in your mind what you need, such as storage petabytes of documents? You need everything on-line? There’s a way to logically separate the “good content” from the “legacy content”?  &lt;br /&gt;
The first thing that comes to my mind is to use the creation date of the document, but you need to remember that this document could receive a lot of revisions and maybe you can consider the revision creation date. Your plan can have also complex rules like per Document Type or per a custom metadata like department or an hybrid per date, per DocType and an specific virtual folder.  &lt;br /&gt;
Extrapolation the use, you can have your repository distributed in different servers, different disks, different disk types (Such as ssds, sas, sata, tape,…), separated accordingly your business requirements, separating the “hot” content from the legacy and easily matching your compliance requirements.  &lt;br /&gt;
If you think to use by revision, the simple way is to consider the dId, that is the sequential unique id for every content created using the WebCenter Content or the dLastModified that is the date field of the FileStorage table that contains the date of inclusion of the content to the DB Table using SecureFiles.  &lt;br /&gt;
Using the scenario of partitioned repository using an hierarchical separation by date, we will transform the FileStorage table in an partitioned table using&amp;nbsp; “Partition by Range” of the dLastModified column (You can use the dId or a join with other tables for other metadata such as dDocType, Security, etc…).  &lt;br /&gt;
The test scenario bellow covers:  &lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;Previous existent data on the JDBC Storage to be migrated to the new partitioned JDBC Storage  &lt;/li&gt;
&lt;li&gt;Partition by Date  &lt;/li&gt;
&lt;li&gt;Automatically generation of new partitions based on a pre-defined interval (Available only with Oracle Database 11g+)  &lt;/li&gt;
&lt;li&gt;Deduplication and Compression for legacy data &lt;/li&gt;
&lt;li&gt;Oracle WebCenter Content 11g PS5 &lt;span style=&quot;font-size: x-small;&quot;&gt;(Could present some customizations that do not affect the test scenario)&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
For the test case you need some data stored using JDBC Storage to be the “legacy” data. If you do not have done before, just create an Storage rule pointed to the JDBC Storage:  &lt;br /&gt;
&lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDUm0cO_0wCaUqTebRk4wSwB23g9UxpXK1oRgxADC9d8bTYhEnJmerL8l5Zs5-uUkomevKw_HNd_J3JwGDZM1z5OIz8gBrQdH5LwDf4osiOEA3Hn2AN0n8Vo3HPgGEDjD32GX9iNyOBQ8/s1600-h/FigA%25255B5%25255D.png&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img alt=&quot;FileStorage Providers&quot; border=&quot;0&quot; height=&quot;259&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixORUlXrAWFCqX0DLLsHgIxvUhrCRW-NuQHOyMmC9W-dUDubYJKyuiD5CvKhkXRUn5zAmrnNKcORE4tv3AVFhE5UN3mGfGtfS57ECZq00XkkX2dmcufsIyWU52TNhGxE-i-J6CY09kj-A/?imgmax=800&quot; style=&quot;background-image: none; border: 0px; display: block; float: none; margin-left: auto; margin-right: auto; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;File Storages Providers&quot; width=&quot;541&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: xx-small;&quot;&gt;FileStorage Providers&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
Enable the metadata StorageRule in the UI and upload some documents using this rule.  &lt;br /&gt;
For this test case you can run using the schema owner or an dba user. We will use the schema owner TESTS_OCS. &lt;br /&gt;
I can’t forgot to tell that this is just a test and you should do a proper backup of your environment. &lt;br /&gt;
When you use the schema owner, you need some privileges, using the dba user grant the privileges needed:&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;REM &lt;span style=&quot;color: blue;&quot;&gt;Grant&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;privileges&lt;/span&gt; required &lt;span style=&quot;color: blue;&quot;&gt;for&lt;/span&gt; online redefinition.&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;GRANT&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;EXECUTE&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;ON&lt;/span&gt; DBMS_REDEFINITION &lt;span style=&quot;color: blue;&quot;&gt;TO&lt;/span&gt; TESTS_OCS;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;GRANT&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;ALTER&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;ANY&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TABLE&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TO&lt;/span&gt; TESTS_OCS;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;GRANT&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;DROP&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;ANY&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TABLE&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TO&lt;/span&gt; TESTS_OCS;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;GRANT&lt;/span&gt; LOCK &lt;span style=&quot;color: blue;&quot;&gt;ANY&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TABLE&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TO&lt;/span&gt; TESTS_OCS;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;GRANT&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;CREATE&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;ANY&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TABLE&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TO&lt;/span&gt; TESTS_OCS;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;GRANT&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;SELECT&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;ANY&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TABLE&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TO&lt;/span&gt; TESTS_OCS;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;REM &lt;span style=&quot;color: blue;&quot;&gt;Privileges&lt;/span&gt; required &lt;span style=&quot;color: blue;&quot;&gt;to&lt;/span&gt; perform cloning &lt;span style=&quot;color: blue;&quot;&gt;of&lt;/span&gt; dependent objects.&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;GRANT&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;CREATE&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;ANY&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TRIGGER&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TO&lt;/span&gt; TESTS_OCS;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;GRANT&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;CREATE&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;ANY&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;INDEX&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TO&lt;/span&gt; TESTS_OCS;&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
In our test scenario we will separate the content as Legacy, Day1, Day2, Day3 and Future. This last one will partitioned automatically using 3 tablespaces in a round robin mode. In a real scenario the partition rule could be per month, per year or any rule that you choose.&lt;br /&gt;
Table spaces for the test scenario:&lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;CREATE&lt;/span&gt; TABLESPACE TESTS_OCS_PART_LEGACY DATAFILE &lt;span style=&quot;color: #006080;&quot;&gt;&#39;tests_ocs_part_legacy.dat&#39;&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;SIZE&lt;/span&gt; 500K AUTOEXTEND &lt;span style=&quot;color: blue;&quot;&gt;ON&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;NEXT&lt;/span&gt; 500K MAXSIZE UNLIMITED;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;CREATE&lt;/span&gt; TABLESPACE TESTS_OCS_PART_DAY1 DATAFILE &lt;span style=&quot;color: #006080;&quot;&gt;&#39;tests_ocs_part_day1.dat&#39;&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;SIZE&lt;/span&gt; 500K AUTOEXTEND &lt;span style=&quot;color: blue;&quot;&gt;ON&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;NEXT&lt;/span&gt; 500K MAXSIZE UNLIMITED;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;CREATE&lt;/span&gt; TABLESPACE TESTS_OCS_PART_DAY2 DATAFILE &lt;span style=&quot;color: #006080;&quot;&gt;&#39;tests_ocs_part_day2.dat&#39;&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;SIZE&lt;/span&gt; 500K AUTOEXTEND &lt;span style=&quot;color: blue;&quot;&gt;ON&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;NEXT&lt;/span&gt; 500K MAXSIZE UNLIMITED;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;CREATE&lt;/span&gt; TABLESPACE TESTS_OCS_PART_DAY3 DATAFILE &lt;span style=&quot;color: #006080;&quot;&gt;&#39;tests_ocs_part_day3.dat&#39;&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;SIZE&lt;/span&gt; 500K AUTOEXTEND &lt;span style=&quot;color: blue;&quot;&gt;ON&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;NEXT&lt;/span&gt; 500K MAXSIZE UNLIMITED;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;CREATE&lt;/span&gt; TABLESPACE TESTS_OCS_PART_ROUND_ROBIN_A &lt;span style=&quot;color: #006080;&quot;&gt;&#39;tests_ocs_part_round_robin_a.dat&#39;&lt;/span&gt; DATAFILE &lt;span style=&quot;color: blue;&quot;&gt;SIZE&lt;/span&gt; 500K AUTOEXTEND &lt;span style=&quot;color: blue;&quot;&gt;ON&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;NEXT&lt;/span&gt; 500K MAXSIZE UNLIMITED;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;CREATE&lt;/span&gt; TABLESPACE TESTS_OCS_PART_ROUND_ROBIN_B &lt;span style=&quot;color: #006080;&quot;&gt;&#39;tests_ocs_part_round_robin_b.dat&#39;&lt;/span&gt; DATAFILE &lt;span style=&quot;color: blue;&quot;&gt;SIZE&lt;/span&gt; 500K AUTOEXTEND &lt;span style=&quot;color: blue;&quot;&gt;ON&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;NEXT&lt;/span&gt; 500K MAXSIZE UNLIMITED;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;CREATE&lt;/span&gt; TABLESPACE TESTS_OCS_PART_ROUND_ROBIN_C &lt;span style=&quot;color: #006080;&quot;&gt;&#39;tests_ocs_part_round_robin_c.dat&#39;&lt;/span&gt; DATAFILE &lt;span style=&quot;color: blue;&quot;&gt;SIZE&lt;/span&gt; 500K AUTOEXTEND &lt;span style=&quot;color: blue;&quot;&gt;ON&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;NEXT&lt;/span&gt; 500K MAXSIZE UNLIMITED;&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
Before start, gather optimizer statistics on the actual FileStorage table: &lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;EXEC&lt;/span&gt; DBMS_STATS.GATHER_TABLE_STATS(&lt;span style=&quot;color: blue;&quot;&gt;USER&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;FileStorage&#39;&lt;/span&gt;, &lt;span style=&quot;color: blue;&quot;&gt;cascade&lt;/span&gt; =&amp;gt; &lt;span style=&quot;color: blue;&quot;&gt;TRUE&lt;/span&gt;);&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
Now check if is possible execute the redefinition process:&lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;EXEC&lt;/span&gt; DBMS_REDEFINITION.CAN_REDEF_TABLE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;TESTS_OCS&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;FileStorage&#39;&lt;/span&gt;,DBMS_REDEFINITION.CONS_USE_PK);&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
If no errors messages, you are good to go.&lt;br /&gt;
&lt;br /&gt;
Create a Partitioned Interim FileStorage table.&lt;br /&gt;
&lt;br /&gt;
You need to create a new table with the partition information to act as an interim table:&lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;CREATE&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TABLE&lt;/span&gt; FILESTORAGE_Part&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  (&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    DID          NUMBER(*,0) &lt;span style=&quot;color: blue;&quot;&gt;NOT&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;NULL&lt;/span&gt; ENABLE,&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    DRENDITIONID VARCHAR2(30 &lt;span style=&quot;color: blue;&quot;&gt;CHAR&lt;/span&gt;) &lt;span style=&quot;color: blue;&quot;&gt;NOT&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;NULL&lt;/span&gt; ENABLE,&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    DLASTMODIFIED &lt;span style=&quot;color: blue;&quot;&gt;TIMESTAMP&lt;/span&gt; (6),&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    DFILESIZE  NUMBER(*,0),&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    DISDELETED VARCHAR2(1 &lt;span style=&quot;color: blue;&quot;&gt;CHAR&lt;/span&gt;),&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    BFILEDATA &lt;span style=&quot;color: blue;&quot;&gt;BLOB&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  )&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    (&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ENABLE STORAGE &lt;span style=&quot;color: blue;&quot;&gt;IN&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;ROW&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        NOCACHE LOGGING&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        KEEP_DUPLICATES&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        NOCOMPRESS&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    ) &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  PARTITION &lt;span style=&quot;color: blue;&quot;&gt;BY&lt;/span&gt; RANGE (DLASTMODIFIED) &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  &lt;span style=&quot;color: blue;&quot;&gt;INTERVAL&lt;/span&gt; (NUMTODSINTERVAL(1,&lt;span style=&quot;color: #006080;&quot;&gt;&#39;DAY&#39;&lt;/span&gt;))&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  STORE &lt;span style=&quot;color: blue;&quot;&gt;IN&lt;/span&gt; (TESTS_OCS_PART_ROUND_ROBIN_A, TESTS_OCS_PART_ROUND_ROBIN_B, TESTS_OCS_PART_ROUND_ROBIN_C)&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  (&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;          PARTITION FILESTORAGE_PART_LEGACY &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;05-APR-2012 12.00.00 AM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;            TABLESPACE TESTS_OCS_PART_LEGACY&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;            LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;              ( TABLESPACE TESTS_OCS_PART_LEGACY &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;                RETENTION &lt;span style=&quot;color: blue;&quot;&gt;NONE&lt;/span&gt; &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;                DEDUPLICATE &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;                COMPRESS HIGH&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;              ),&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;          PARTITION FILESTORAGE_PART_DAY1 &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;06-APR-2012 07.25.00 PM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;            TABLESPACE TESTS_OCS_PART_DAY1 &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;            LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;              ( TABLESPACE TESTS_OCS_PART_DAY1 &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;                RETENTION AUTO &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;                KEEP_DUPLICATES &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;                COMPRESS &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;              ),&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;          PARTITION FILESTORAGE_PART_DAY2 &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;06-APR-2012 07.55.00 PM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;            TABLESPACE TESTS_OCS_PART_DAY2&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;            LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;              ( TABLESPACE TESTS_OCS_PART_DAY2&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;                RETENTION AUTO &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;                KEEP_DUPLICATES &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;                NOCOMPRESS &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;              ),&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;          PARTITION FILESTORAGE_PART_DAY3 &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;06-APR-2012 07.58.00 PM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;            TABLESPACE TESTS_OCS_PART_DAY3&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;            LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;              ( TABLESPACE TESTS_OCS_PART_DAY3 &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;                RETENTION AUTO &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;                KEEP_DUPLICATES &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;                NOCOMPRESS &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;              )&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  );&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
After the creation you should see your partitions defined.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKjJPXTyvMAbQsN8yRpkES7ZLpKLe-BYahk9Z1DZSegcsO9UHw4VNWAv6oZZUMOgrAvsB_cTlK37bU0i7z5xMtiIiI9NoppsNoXOD_uTRoVwVbW803xAxObpoXgE0IWEvg82FktybJ4Vs/s1600-h/FigB%25255B4%25255D.png&quot;&gt;&lt;img alt=&quot;FileStorage_PART Partitions&quot; border=&quot;0&quot; height=&quot;79&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPyBu9tdzGg1RA8uN7WBK0pEF97yrELQ0LzL9H6FJNPc0wW-Wnfk-RTbyMuzfV3QBYQPEQ4LcSnY2DGVEtf3NSKPhOTA8T3g1uj_taV5EqFut8fBqsRjbLzreCjuEJ_2w0WfyaZ3W7baI/?imgmax=800&quot; style=&quot;background-image: none; border: 0px; display: block; float: none; margin-left: auto; margin-right: auto; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;SQL Developer view of Partitions of the FileStorage_PART&quot; width=&quot;520&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Note that only the fixed range partitions have been created, none of the interval partition have been created.&lt;br /&gt;
&lt;br /&gt;
Start the redefinition process:&lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;BEGIN&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    DBMS_REDEFINITION.START_REDEF_TABLE(&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;         uname =&amp;gt; &lt;span style=&quot;color: #006080;&quot;&gt;&#39;TESTS_OCS&#39;&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ,orig_table =&amp;gt; &lt;span style=&quot;color: #006080;&quot;&gt;&#39;FileStorage&#39;&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ,int_table =&amp;gt; &lt;span style=&quot;color: #006080;&quot;&gt;&#39;FileStorage_PART&#39;&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ,col_mapping =&amp;gt; &lt;span style=&quot;color: blue;&quot;&gt;NULL&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ,options_flag =&amp;gt; DBMS_REDEFINITION.CONS_USE_PK&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    );&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;END&lt;/span&gt;;&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
This operation can take some time to complete, depending how many contents that you have and on the size of the table.&lt;br /&gt;
Using the DBA user you can check the progress with this command:&lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;SELECT&lt;/span&gt; * &lt;span style=&quot;color: blue;&quot;&gt;FROM&lt;/span&gt; v$sesstat &lt;span style=&quot;color: blue;&quot;&gt;WHERE&lt;/span&gt; sid = 1;&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
Copy dependent objects:&lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;DECLARE&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;redefinition_errors PLS_INTEGER := 0;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;BEGIN&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS(&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        uname =&amp;gt; &lt;span style=&quot;color: #006080;&quot;&gt;&#39;TESTS_OCS&#39;&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ,orig_table =&amp;gt; &lt;span style=&quot;color: #006080;&quot;&gt;&#39;FileStorage&#39;&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ,int_table =&amp;gt; &lt;span style=&quot;color: #006080;&quot;&gt;&#39;FileStorage_PART&#39;&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ,copy_indexes =&amp;gt; DBMS_REDEFINITION.CONS_ORIG_PARAMS&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ,copy_triggers =&amp;gt;  &lt;span style=&quot;color: blue;&quot;&gt;TRUE&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ,copy_constraints =&amp;gt;  &lt;span style=&quot;color: blue;&quot;&gt;TRUE&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ,copy_privileges =&amp;gt;  &lt;span style=&quot;color: blue;&quot;&gt;TRUE&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ,ignore_errors =&amp;gt;  &lt;span style=&quot;color: blue;&quot;&gt;TRUE&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ,num_errors =&amp;gt; redefinition_errors&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ,copy_statistics =&amp;gt; &lt;span style=&quot;color: blue;&quot;&gt;FALSE&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ,copy_mvlog =&amp;gt; &lt;span style=&quot;color: blue;&quot;&gt;FALSE&lt;/span&gt;    &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    );&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    &lt;span style=&quot;color: blue;&quot;&gt;IF&lt;/span&gt; (redefinition_errors &amp;gt; 0) &lt;span style=&quot;color: blue;&quot;&gt;THEN&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        DBMS_OUTPUT.PUT_LINE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;&amp;gt;&amp;gt;&amp;gt; FileStorage to FileStorage_PART temp copy Errors: &#39;&lt;/span&gt; || TO_CHAR(redefinition_errors));&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    &lt;span style=&quot;color: blue;&quot;&gt;END&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;IF&lt;/span&gt;;    &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;END&lt;/span&gt;;&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
With the DBA user, verify that there&#39;s no errors:&lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;SELECT&lt;/span&gt; object_name, base_table_name, ddl_txt &lt;span style=&quot;color: blue;&quot;&gt;FROM&lt;/span&gt; DBA_REDEFINITION_ERRORS;&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
*Note that will show 2 lines related to the constrains, this is expected.&lt;br /&gt;
&lt;br /&gt;
Synchronize the interim table FileStorage_PART:&lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;BEGIN&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  DBMS_REDEFINITION.SYNC_INTERIM_TABLE(&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    uname      =&amp;gt; &lt;span style=&quot;color: #006080;&quot;&gt;&#39;TESTS_OCS&#39;&lt;/span&gt;,        &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    orig_table =&amp;gt; &lt;span style=&quot;color: #006080;&quot;&gt;&#39;FileStorage&#39;&lt;/span&gt;,&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    int_table  =&amp;gt; &lt;span style=&quot;color: #006080;&quot;&gt;&#39;FileStorage_PART&#39;&lt;/span&gt;);&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;END&lt;/span&gt;;&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
Gather statistics on the new table:&lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;EXEC&lt;/span&gt; DBMS_STATS.GATHER_TABLE_STATS(&lt;span style=&quot;color: blue;&quot;&gt;USER&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;FileStorage_PART&#39;&lt;/span&gt;, &lt;span style=&quot;color: blue;&quot;&gt;cascade&lt;/span&gt; =&amp;gt; &lt;span style=&quot;color: blue;&quot;&gt;TRUE&lt;/span&gt;);&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
Complete the redefinition:&lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;BEGIN&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  DBMS_REDEFINITION.FINISH_REDEF_TABLE(&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    uname      =&amp;gt; &lt;span style=&quot;color: #006080;&quot;&gt;&#39;TESTS_OCS&#39;&lt;/span&gt;,        &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    orig_table =&amp;gt; &lt;span style=&quot;color: #006080;&quot;&gt;&#39;FileStorage&#39;&lt;/span&gt;,&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    int_table  =&amp;gt; &lt;span style=&quot;color: #006080;&quot;&gt;&#39;FileStorage_PART&#39;&lt;/span&gt;);&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;END&lt;/span&gt;;&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
During the execution the FileStorage table is locked in exclusive mode until finish the operation.&lt;br /&gt;
After the last command the FileStorage table is partitioned.&lt;br /&gt;
If you have contents out of the range partition, you should see the new partitions created automatically, not generating an error if you “forgot” to create all the future ranges. You will see something like:&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSQI8QoXRKdIdl78gwpLKR3u7k0CJXhPkrey1syGsbzojb421_dZeI3bBWmmIe21I_bVCXIb1Xyv7-5S0bctlKOGbcQLgWW6Rnbz65YAP8h82N_nVF_cVohvWsyq64VvBgx2UUUjw_oGE/s1600-h/FigC%25255B3%25255D.png&quot;&gt;&lt;img alt=&quot;FileStorage Partitions after redefinition&quot; border=&quot;0&quot; height=&quot;108&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjF72jJQ8mbsx2CdO23r4QY0fC8d4AqSY04dB5hExddIlayUUBKc_XmpQIDdimzKOYLXrbF8d-hxYckxRe1mMP2ylZGNJusSZphm3IuTI3wBhLCRBmnuRuL3fqDq96Gwu35pPZaWO4nrbg/?imgmax=800&quot; style=&quot;background-image: none; border: 0px; display: block; float: none; margin-left: auto; margin-right: auto; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;SQL Developer view of partitions of FileStorage after Redefinition&quot; width=&quot;535&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&amp;nbsp; &lt;br /&gt;
You now can drop the FileStorage_PART table:&lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;DROP&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TABLE&lt;/span&gt; FileStorage_PART PURGE;&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
To check the FileStorage table is valid and is partitioned, use the command:&lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;SELECT&lt;/span&gt; num_rows,partitioned&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;FROM&lt;/span&gt;   user_tables&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;WHERE&lt;/span&gt;  table_name = &lt;span style=&quot;color: #006080;&quot;&gt;&#39;FILESTORAGE&#39;&lt;/span&gt;;&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
You can list the contents of the FileStorage table in a specific partition, per example:&lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;SELECT&lt;/span&gt; *&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;FROM&lt;/span&gt;   FileStorage&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;PARTITION&lt;/span&gt; (FILESTORAGE_PART_LEGACY)&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
Some useful commands that you can use to check the partitions, note that you need to run using a DBA user:&lt;br /&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;SELECT&lt;/span&gt; *&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;FROM&lt;/span&gt;   DBA_TAB_PARTITIONS&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;WHERE&lt;/span&gt;  table_name = &lt;span style=&quot;color: #006080;&quot;&gt;&#39;FILESTORAGE&#39;&lt;/span&gt;;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&amp;nbsp;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;SELECT&lt;/span&gt; *&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;FROM&lt;/span&gt;   DBA_TABLESPACES&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;WHERE&lt;/span&gt;  tablespace_name &lt;span style=&quot;color: blue;&quot;&gt;like&lt;/span&gt; &lt;span style=&quot;color: #006080;&quot;&gt;&#39;TESTS_OCS%&#39;&lt;/span&gt;;&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
After the redefinition process complete you have a new FileStorage table storing all content that has the Storage rule pointed to the JDBC Storage and partitioned using the rule set during the creation of the temporary interim FileStorage_PART table.&lt;br /&gt;
At this point you can test the WebCenter Content downloading the documents (Original and Renditions). Note that the content could be already in the cache area, take a look in the weblayout directory to see if a file with the same id is there, then click on the web rendition of your test file and see if have created the file and you can open, this means that is all working.&lt;br /&gt;
The redefinition process can be repeated many times, this allow you test what the better layout, over and over again.&lt;br /&gt;
Now some interesting maintenance actions related to the partitions:&lt;br /&gt;
&lt;ol&gt;&lt;br /&gt;
&lt;li&gt;Make an tablespace read only.&lt;/li&gt;
&lt;br /&gt;&lt;ul&gt;&lt;br /&gt;
&lt;li&gt;No issues viewing, the WebCenter Content do not alter the revisions&lt;/li&gt;
&lt;br /&gt;
&lt;li&gt;When try to delete an content that is part of an read only tablespace, an error will occurs and the document will not be deleted&lt;/li&gt;
&lt;br /&gt;
&lt;li&gt;The only way to prevent errors today is creating an custom component that checks the partitions and if you have an document in an “Read Only” repository, execute the deletion process of the metadata and mark the document to be deleted on the next db maintenance, like a new redefinition.&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;li&gt;Take an tablespace off-line for archiving purposes or any other reason.&lt;/li&gt;
&lt;br /&gt;&lt;ul&gt;&lt;br /&gt;
&lt;li&gt;When you try open an document that is included in this tablespace will receive an error that was unable to retrieve the content, but the others online tablespaces are not affected.&lt;/li&gt;
&lt;br /&gt;
&lt;li&gt;Same behavior when deleting documents.&lt;/li&gt;
&lt;br /&gt;
&lt;li&gt;Again, an custom component is the solution. If you have an document “out of range”, the component can show an message that the repository for that document is offline. This can be extended to a option to the user to request to put online again.&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;li&gt;Moving some legacy content to an offline repository (table) using the Exchange option to move the content from one partition to a empty nonpartitioned table like FileStorage_LEGACY. Note that this option will remove the registers from the FileStorage and will not be able to open the stored content. You always need to keep in mind the indexes and constrains.&lt;/li&gt;
&lt;br /&gt;
&lt;li&gt;An redefinition separating the original content (vault) from the renditions and separate by date ate the same time. This could be an option for DAM environments that want to have an special place for the renditions and put the original files in a storage with less performance.&lt;/li&gt;
&lt;br /&gt;&lt;ul&gt;&lt;br /&gt;
&lt;li&gt;The process will be the same, you just need to change the script of the interim table to use composite partitioning. Will be something like:&lt;/li&gt;
&lt;br /&gt;&lt;div id=&quot;codeSnippetWrapper&quot; style=&quot;background-color: #f4f4f4; border-bottom: silver 1px solid; border-left: silver 1px solid; border-right: silver 1px solid; border-top: silver 1px solid; cursor: text; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 20px 0px 10px; max-height: 200px; overflow: auto; padding-bottom: 4px; padding-left: 4px; padding-right: 4px; padding-top: 4px; text-align: left; width: 97.5%;&quot;&gt;
&lt;br /&gt;
&lt;div id=&quot;codeSnippet&quot; style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;CREATE&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;TABLE&lt;/span&gt; FILESTORAGE_RenditionPart&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  (&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    DID          NUMBER(*,0) &lt;span style=&quot;color: blue;&quot;&gt;NOT&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;NULL&lt;/span&gt; ENABLE,&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    DRENDITIONID VARCHAR2(30 &lt;span style=&quot;color: blue;&quot;&gt;CHAR&lt;/span&gt;) &lt;span style=&quot;color: blue;&quot;&gt;NOT&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;NULL&lt;/span&gt; ENABLE,&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    DLASTMODIFIED &lt;span style=&quot;color: blue;&quot;&gt;TIMESTAMP&lt;/span&gt; (6),&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    DFILESIZE  NUMBER(*,0),&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    DISDELETED VARCHAR2(1 &lt;span style=&quot;color: blue;&quot;&gt;CHAR&lt;/span&gt;),&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    BFILEDATA &lt;span style=&quot;color: blue;&quot;&gt;BLOB&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  )&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    (&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        ENABLE STORAGE &lt;span style=&quot;color: blue;&quot;&gt;IN&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;ROW&lt;/span&gt;&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        NOCACHE LOGGING&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        KEEP_DUPLICATES&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;        NOCOMPRESS&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;    ) &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  PARTITION &lt;span style=&quot;color: blue;&quot;&gt;BY&lt;/span&gt; LIST (DRENDITIONID)&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  SUBPARTITION  &lt;span style=&quot;color: blue;&quot;&gt;BY&lt;/span&gt; RANGE (DLASTMODIFIED) &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  (&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  PARTITION Vault &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; (&lt;span style=&quot;color: #006080;&quot;&gt;&#39;primaryFile&#39;&lt;/span&gt;)&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      ( SUBPARTITION FILESTORAGE_VAULT_LEGACY &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;05-APR-2012 12.00.00 AM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      , SUBPARTITION FILESTORAGE_VAULT_DAY1 &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;06-APR-2012 07.25.00 PM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      , SUBPARTITION FILESTORAGE_VAULT_DAY2 &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;06-APR-2012 07.55.00 PM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE        &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      , SUBPARTITION FILESTORAGE_VAULT_DAY3 &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;06-APR-2012 07.58.00 PM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE  &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      , SUBPARTITION FILESTORAGE_VAULT_FUTURE &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (MAXVALUE)&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      )&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt; ,PARTITION WebLayout &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; (&lt;span style=&quot;color: #006080;&quot;&gt;&#39;webViewableFile&#39;&lt;/span&gt;)&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      ( SUBPARTITION FILESTORAGE_WEBLAYOUT_LEGACY &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;05-APR-2012 12.00.00 AM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      , SUBPARTITION FILESTORAGE_WEBLAYOUT_DAY1 &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;06-APR-2012 07.25.00 PM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      , SUBPARTITION FILESTORAGE_WEBLAYOUT_DAY2 &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;06-APR-2012 07.55.00 PM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE        &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      , SUBPARTITION FILESTORAGE_WEBLAYOUT_DAY3 &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;06-APR-2012 07.58.00 PM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE  &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      , SUBPARTITION FILESTORAGE_WEBLAYOUT_FUTURE &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (MAXVALUE)&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      )      &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt; ,PARTITION Special &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; (&lt;span style=&quot;color: #006080;&quot;&gt;&#39;Special&#39;&lt;/span&gt;)&lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      ( SUBPARTITION FILESTORAGE_SPECIAL_LEGACY &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;05-APR-2012 12.00.00 AM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      , SUBPARTITION FILESTORAGE_SPECIAL_DAY1 &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;06-APR-2012 07.25.00 PM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      , SUBPARTITION FILESTORAGE_SPECIAL_DAY2 &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;06-APR-2012 07.55.00 PM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE        &lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      , SUBPARTITION FILESTORAGE_SPECIAL_DAY3 &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (TO_DATE(&lt;span style=&quot;color: #006080;&quot;&gt;&#39;06-APR-2012 07.58.00 PM&#39;&lt;/span&gt;, &lt;span style=&quot;color: #006080;&quot;&gt;&#39;DD-MON-YYYY HH.MI.SS AM&#39;&lt;/span&gt;)) LOB (BFILEDATA) STORE &lt;span style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt; SECUREFILE  &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      , SUBPARTITION FILESTORAGE_SPECIAL_FUTURE &lt;span style=&quot;color: blue;&quot;&gt;VALUES&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;LESS&lt;/span&gt; &lt;span style=&quot;color: blue;&quot;&gt;THAN&lt;/span&gt; (MAXVALUE)&lt;/pre&gt;
&lt;pre style=&quot;background-color: white; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;      )      &lt;/pre&gt;
&lt;pre style=&quot;background-color: #f4f4f4; border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none; color: black; direction: ltr; font-family: &#39;Courier New&#39;, courier, monospace; font-size: 8pt; line-height: 12pt; margin: 0em; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; width: 100%;&quot;&gt;  )ENABLE &lt;span style=&quot;color: blue;&quot;&gt;ROW&lt;/span&gt; MOVEMENT;&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;/ul&gt;
&lt;/ol&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The next post related to partitioned repository will come with an sample component to handle the possible exceptions when you need to take off line an tablespace/partition or move to another place.&lt;br /&gt;
&lt;br /&gt;
Also, we can include some integration to the Retention Management and Records Management.&lt;br /&gt;
&lt;br /&gt;
Another subject related to partitioning is the ability to create an FileStore Provider pointed to a different database, raising the level of the distributed storage vs. performance.&lt;br /&gt;
&lt;br /&gt;
Let us know if this is important to you or you have an use case not listed, leave a comment.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;em&gt;&lt;span style=&quot;color: #4bacc6; font-size: small;&quot;&gt;&lt;a href=&quot;https://blogs.oracle.com/ATEAM_WEBCENTER/entry/partitioned_repository_for_webcenter_content&quot; target=&quot;_blank&quot;&gt;Cross-posted on the WebCenter A-Team Blog&lt;/a&gt;&lt;/span&gt;&lt;/em&gt;</content><link rel='replies' type='application/atom+xml' href='http://blog.contentra.com/feeds/6955569872034550596/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.contentra.com/2012/04/partitioned-repository-for-webcenter.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/602557221877923219/posts/default/6955569872034550596'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/602557221877923219/posts/default/6955569872034550596'/><link rel='alternate' type='text/html' href='http://blog.contentra.com/2012/04/partitioned-repository-for-webcenter.html' title='Partitioned Repository for WebCenter Content using Oracle Database 11g'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/05902870212161153936</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixORUlXrAWFCqX0DLLsHgIxvUhrCRW-NuQHOyMmC9W-dUDubYJKyuiD5CvKhkXRUn5zAmrnNKcORE4tv3AVFhE5UN3mGfGtfS57ECZq00XkkX2dmcufsIyWU52TNhGxE-i-J6CY09kj-A/s72-c?imgmax=800" height="72" width="72"/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-602557221877923219.post-4727001463391874847</id><published>2011-07-31T23:43:00.002-07:00</published><updated>2011-08-03T16:35:44.579-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Content"/><category scheme="http://www.blogger.com/atom/ns#" term="Deployment"/><category scheme="http://www.blogger.com/atom/ns#" term="Enterprise"/><category scheme="http://www.blogger.com/atom/ns#" term="Infra"/><category scheme="http://www.blogger.com/atom/ns#" term="Production"/><category scheme="http://www.blogger.com/atom/ns#" term="Proxy"/><category scheme="http://www.blogger.com/atom/ns#" term="WebCenter"/><category scheme="http://www.blogger.com/atom/ns#" term="WebLogic"/><title type='text'>Using a Web Proxy Server with WebCenter Family</title><content type='html'>&lt;p&gt;The use of a Web Tier is always recommended in a production environment, for security, performance and better control and load management, no matter if is a Intranet, internet or extranet environment.&lt;/p&gt; &lt;p&gt;The most common use for the Web Tier with WebCenter is acting as Reverse Proxy to forward all requests to a frontend WebCenter site to the application server (Figure A), but there’s to many ways to do an enterprise deployment with a web tier and many flavors of web servers and load balancing options.&lt;/p&gt; &lt;p&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdeOFcGCoTUI3rfZi98HsWmnKFl0rLwW7AQ2vqCHMXj-Gw7YZE4F4ipo93OBf8TTab49ZPRWZD86sS1HFgILOfCZpp4oXjkthZJALr1JoEQ_JsSwxi2i1ySe7C9HNzvzRrYS3VIMM9LtY/s1600-h/FigA%25255B5%25255D.png&quot;&gt;&lt;img style=&quot;background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: block; float: none; margin-left: auto; border-top: 0px; margin-right: auto; border-right: 0px; padding-top: 0px&quot; title=&quot;FigA&quot; border=&quot;0&quot; alt=&quot;FigA&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgF1IQt5osJqRdTBRZV0i-6B_8eSlbsGVoJpc1120pE9wNl9RGCMLPj8Yel2NLA_FNkuKvq2a4ZWK9KeaNa7S_OgBvePztNOcMgIMnAv21NR3gJ1R1ysS7V5s7eYHa-8RAdsMtX-DlmJFo/?imgmax=800&quot; width=&quot;342&quot; height=&quot;312&quot;&gt;&lt;/a&gt;&lt;/p&gt; &lt;p&gt;Let’s start with the WebLogic plugin with supported webservers. You can found the standard plugins in your WebLogic instalation dir, that will something like “%WEBLOGIC_HOME%/server/plugin/%OS%/”, but I recommend you to download the latest plugin from Oracle’s &lt;a title=&quot;Oracle Technology Network - WebLogic Downloads&quot; href=&quot;http://www.oracle.com/technetwork/middleware/weblogic/downloads/wls-main-097127.html&quot; target=&quot;_blank&quot;&gt;OTN&lt;/a&gt; or &lt;a title=&quot;Oracle eDelivery website&quot; href=&quot;http://edelivery.oracle.com&quot; target=&quot;_blank&quot;&gt;eDelivery&lt;/a&gt; websites, you will found the &lt;a href=&quot;http://www.oracle.com/technetwork/middleware/ias/downloads/wls-plugins-096117.html&quot; target=&quot;_blank&quot;&gt;Oracle WebLogic Server Web Server Plugins 1.1&lt;/a&gt; or later. With the version 1.1 you will found plugins for Apache 2.2.x (32-Bits and 64-Bits) and for IIS 6+ and IIS 7+. Always confirm the OS support with the WLS Plugin Support Matrix. If you need support for iPlanet 6+ or 7+, you can use the version 1.0. Any throuble to found the files, try search or create to the Oracle support (Ref.: Doc ID 1111903.1).&lt;/p&gt; &lt;p&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSRYRt6n4x6p0ny4RXP3XCpL0xMQDaCiXEy1SjN4IIicqag4vTtuBCnk_lDNCx2q9V5PZKey-J19R62e4Vs4nbFH0_OxOYzNnaCMbfIsKHiMXO0BDg2YkvTDox_vPyQivVpM7iUR8ER_4/s1600-h/FigB%25255B5%25255D.png&quot;&gt;&lt;img style=&quot;background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: block; float: none; margin-left: auto; border-top: 0px; margin-right: auto; border-right: 0px; padding-top: 0px&quot; title=&quot;FigB&quot; border=&quot;0&quot; alt=&quot;FigB&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBO7x65qDed8bWf3lK-FOZVprWbJO-10Bv0xTE32hRwzaIzrgdCAi-XE-3GeBU40XlQ-tpoDgTEJG5I0faCaSYFBGLMk7xWvcnbjEfgXXzZ1aq0O9BJwrxCaeoEaFOCQ5phB4ui_eaJXs/?imgmax=800&quot; width=&quot;378&quot; height=&quot;367&quot;&gt;&lt;/a&gt;&lt;/p&gt; &lt;p&gt;Some times you do not want to use a separate web server, you can use the WebLogic as a Web Server by using a servlet, but this is subject for another post.&lt;/p&gt; &lt;p&gt;When you are deploying a WebCenter solution using a proxy server, you need to remember to proxy all your requests from all weblogics for Security, performance and Control and also all non-weblogic requests such as static files, WebCenter Content custom requests, Services, Portlets and 3rd Party.&lt;/p&gt; &lt;p&gt;Is common in intranet deployments you see calls direct to the application servers, calls to several different servers, like the Figure C.&lt;/p&gt; &lt;p&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhveEEQjLKAuNocs9jxhYwUbZUsMAQSryRq-Kaypa37cNoNx2SwaoI6Y8IUM2MAQYlVZB5aAnzKPMLN6RXGMQ3wimMdNceIZO6k8KyXPqOc-vF_f-wVd3zJu7GatVXDFORvz5Mb5CdbWhg/s1600-h/FigC%25255B5%25255D.png&quot;&gt;&lt;img style=&quot;background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px&quot; title=&quot;FigC&quot; border=&quot;0&quot; alt=&quot;FigC&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5mknqmbVvF7fG8PjBT2TKHA9hkNDtfWRDzSJRMu66lrBgnrM-XMjoXabkTOB_WQfJPIxCXljMZ9g7uE6npwJk2bzRA8d_dUop7G8F2HdxRABJkPVVK-K0qKidO2PmX4-obRLBvQ4A32E/?imgmax=800&quot; width=&quot;504&quot; height=&quot;510&quot;&gt;&lt;/a&gt;&lt;/p&gt; &lt;p&gt;Above you can see the same sample with all calls using the web server, for proxy forward, for reverse proxy, static files caching, even the &lt;a title=&quot;Modifying Cache Settings for Content Presenter&quot; href=&quot;http://download.oracle.com/docs/cd/E21764_01/webcenter.1111/e12405/wcadm_documents.htm#BABHFCJH&quot; target=&quot;_blank&quot;&gt;use&lt;/a&gt; of Oracle Coherence is easy when you have a WebCenter Spaces + Content deployment.&lt;/p&gt; &lt;p&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBMbmx6LJQ62Gz1r-gt7P1QuforS5oBq4hrO8sQtndKOu3Uryk2P2dFIXjn8LiTHk7INn0Y7fHbcD_D2LVntzrLXe6ZJrmU7wshUAlYgic8WeqmioG3iDOckkIXwVhfhcDaBmlfR_Antw/s1600-h/FigD%25255B1%25255D.png&quot;&gt;&lt;img style=&quot;background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: block; float: none; margin-left: auto; border-top: 0px; margin-right: auto; border-right: 0px; padding-top: 0px&quot; title=&quot;FigD&quot; border=&quot;0&quot; alt=&quot;FigD&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRdT6PE1GezTF52l9Bbtr7dn-Pal5NmNT9geZ2O64J_hYCom-ZNx0p_FdxN2rVXQ_cSSo9mnLuirj2B_qfsT2iGzQ98EjVeoA52yhsiS0hj7L9WEIt7XXMGNSL1gi1pppY1b0TG0bncIU/?imgmax=800&quot; width=&quot;536&quot; height=&quot;492&quot;&gt;&lt;/a&gt;&lt;/p&gt; &lt;p&gt;We cannot forget to talk about the clustering and load balancers, Clustering is easy done by the WebLogic, you just need to follow the documentation. For Load balancing you need to choose what kind and what load balancer you will use. &lt;/p&gt; &lt;p&gt;LOAD BALANCING&lt;/p&gt; &lt;p&gt;You can do load balancing using the Web Proxy Server with WLS Plugin or a servlet as mentioned above or a External Load Balancer (Hardware) or Appliance.&lt;/p&gt; &lt;p&gt;Using the WLS Plugin you will need to remember to create a entry for WebCenter Server that are you using, that means that you need to create a entry for the /webcenter/ another for the /cs/, another for the “custom sitestudio” calls, for the portlets (If you do not create a parent folder for the portlets, you will need to create a entry for each portlet) and an entry for any other 3rd calls.&lt;/p&gt; &lt;p&gt;The configuration file for each entry will looks like this sample for IIS7:&lt;/p&gt; &lt;p&gt;&lt;code&gt;&lt;/p&gt;&lt;/code&gt;&lt;pre style=&quot;border-bottom: #cecece 1px solid; border-left: #cecece 1px solid; padding-bottom: 5px; background-color: #fbfbfb; min-height: 40px; padding-left: 5px; width: 545px; padding-right: 5px; height: 261px; overflow: auto; border-top: #cecece 1px solid; border-right: #cecece 1px solid; padding-top: 5px&quot;&gt;&lt;pre style=&quot;background-color: #f2f2f2; margin: 0em; width: 100%; font-family: consolas,&#39;Courier New&#39;,courier,monospace; font-size: 12px&quot;&gt;&lt;span style=&quot;color: #008000&quot;&gt;# Changed by Oracle A-Team (Adao.Junior)&lt;/span&gt;&lt;br /&gt;&lt;/pre&gt;&lt;pre style=&quot;background-color: #ffffff; margin: 0em; width: 100%; font-family: consolas,&#39;Courier New&#39;,courier,monospace; font-size: 12px&quot;&gt;&lt;span style=&quot;color: #008000&quot;&gt;# Date: 07/31/2011&lt;/span&gt;&lt;br /&gt;&lt;/pre&gt;&lt;pre style=&quot;background-color: #f2f2f2; margin: 0em; width: 100%; font-family: consolas,&#39;Courier New&#39;,courier,monospace; font-size: 12px&quot;&gt;&lt;span style=&quot;color: #008000&quot;&gt;# WebCenter Content: CUSTOMER_WEB_SERVER&lt;/span&gt;&lt;br /&gt;&lt;/pre&gt;&lt;pre style=&quot;background-color: #ffffff; margin: 0em; width: 100%; font-family: consolas,&#39;Courier New&#39;,courier,monospace; font-size: 12px&quot;&gt;&lt;span style=&quot;color: #008000&quot;&gt;# WLSPlugin1.1-IIS6-IIS7-win64-x64&lt;/span&gt;&lt;br /&gt;&lt;/pre&gt;&lt;pre style=&quot;background-color: #f2f2f2; margin: 0em; width: 100%; font-family: consolas,&#39;Courier New&#39;,courier,monospace; font-size: 12px&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;background-color: #ffffff; margin: 0em; width: 100%; font-family: consolas,&#39;Courier New&#39;,courier,monospace; font-size: 12px&quot;&gt;WebLogicCluster=192.168.100.101:8888,192.168.100.102:8888,192.168.100.101:8891,192.168.100.102:8891&lt;br /&gt;&lt;/pre&gt;&lt;pre style=&quot;background-color: #f2f2f2; margin: 0em; width: 100%; font-family: consolas,&#39;Courier New&#39;,courier,monospace; font-size: 12px&quot;&gt;ConnectTimeoutSecs=25&lt;br /&gt;&lt;/pre&gt;&lt;pre style=&quot;background-color: #ffffff; margin: 0em; width: 100%; font-family: consolas,&#39;Courier New&#39;,courier,monospace; font-size: 12px&quot;&gt;ConnectRetrySecs=5&lt;br /&gt;&lt;/pre&gt;&lt;pre style=&quot;background-color: #f2f2f2; margin: 0em; width: 100%; font-family: consolas,&#39;Courier New&#39;,courier,monospace; font-size: 12px&quot;&gt;KeepAliveEnabled=&lt;span style=&quot;color: #0000ff&quot;&gt;true&lt;/span&gt;&lt;br /&gt;&lt;/pre&gt;&lt;pre style=&quot;background-color: #ffffff; margin: 0em; width: 100%; font-family: consolas,&#39;Courier New&#39;,courier,monospace; font-size: 12px&quot;&gt;FileCaching=ON&lt;br /&gt;&lt;/pre&gt;&lt;pre style=&quot;background-color: #f2f2f2; margin: 0em; width: 100%; font-family: consolas,&#39;Courier New&#39;,courier,monospace; font-size: 12px&quot;&gt;SecureProxy=OFF&lt;br /&gt;&lt;/pre&gt;&lt;pre style=&quot;background-color: #ffffff; margin: 0em; width: 100%; font-family: consolas,&#39;Courier New&#39;,courier,monospace; font-size: 12px&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;background-color: #f2f2f2; margin: 0em; width: 100%; font-family: consolas,&#39;Courier New&#39;,courier,monospace; font-size: 12px&quot;&gt;Debug=OFF&lt;br /&gt;&lt;/pre&gt;&lt;pre style=&quot;background-color: #ffffff; margin: 0em; width: 100%; font-family: consolas,&#39;Courier New&#39;,courier,monospace; font-size: 12px&quot;&gt;WLTempDir=C:\DEBUG\CONTENT&lt;/pre&gt;&lt;/pre&gt;&lt;br /&gt;&lt;p&gt;For a External Load Balancer (Hardware) you have many options, such as the &lt;a href=&quot;www.f5.com&quot; target=&quot;_blank&quot;&gt;f5&lt;/a&gt; Big-IP, a guide to help you deploy with WebCenter could be found &lt;a title=&quot;Deploying F5 with Oracle WebCenter 11gR1&quot; href=&quot;http://www.f5.com/pdf/deployment-guides/oracle-webcenter-big-ip-dg.pdf&quot; target=&quot;_blank&quot;&gt;here&lt;/a&gt;.&lt;/p&gt;&lt;br /&gt;&lt;p&gt;There’s a option to use a hybrid configuration, with Hardware loadbalancers and Web Proxy to handle the web calls between the users and web farms, and web proxies and between the proxies and applications servers.&lt;/p&gt;  </content><link rel='replies' type='application/atom+xml' href='http://blog.contentra.com/feeds/4727001463391874847/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blog.contentra.com/2011/07/using-web-proxy-server-with-webcenter_31.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/602557221877923219/posts/default/4727001463391874847'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/602557221877923219/posts/default/4727001463391874847'/><link rel='alternate' type='text/html' href='http://blog.contentra.com/2011/07/using-web-proxy-server-with-webcenter_31.html' title='Using a Web Proxy Server with WebCenter Family'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/05902870212161153936</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgF1IQt5osJqRdTBRZV0i-6B_8eSlbsGVoJpc1120pE9wNl9RGCMLPj8Yel2NLA_FNkuKvq2a4ZWK9KeaNa7S_OgBvePztNOcMgIMnAv21NR3gJ1R1ysS7V5s7eYHa-8RAdsMtX-DlmJFo/s72-c?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry></feed>