Migrating warehouse from Oracle to SQL Server :
Status: In process
In Oracle : 6 Schemas
In SQL Server: Created a database with 6 Schemas.
-Every Schema has 3 Paritioned and 3 non partitioned tables.
-Out of 3 partitioned tables one is parent table and all other 5 tables are child tables.
-Only parent table has date column and non other table has date column for partitioning.
-all the 5 tables in each schema has primary key.
Are those tables partitioned on the Oracle implementation?
If the answer is yes... how are they partitioned?
If the answer is no... why are you thinking on partitioning?
My Question is can I partition parent table with date column and child tables with Primary key column ?
Short answer is: Yes... followed by a question: Why? What are you trying to accomplish?
sometimes the partitioning column in parent table has abnormal dates like 2099,2088. How can i seperate those values. I listened that we can do by MAX and MIN dates while partitioning but not sure how to implement that..
How is the distribution of such 'abnormal" values? Either way, usually those are catched in a maxval partition.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at Amazon and other bookstores.Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.