Hi,
My database reaches 1.9 Giga and I have to split up in 6 or more databases.
Could you give me the command line I have to type?
Thanks
Dear Author,
Hi
As there is no data splitting supported at the product level so the solution is just a work around. You have to manually splitt the data based on the dates and than You have to change your application program accordingly. In this way you can perform splitting. i.e if the date is less than the split date than search in Primary database else search in the splitted database
I hope it will serve your purpose.
Thanks
Rehan Ahmed Khan
"Leelu" wrote:
>
>Hi,
>My database reaches 1.9 Giga and I have to split up in
>6 or more databases.
>Could you give me the command line I have to type?
>Thanks
Hello,
If you are worried about the unix 2 gig limit then you do not need to have
your app recoded, you need to rebuild your database as a multi volume database.
This allows you to specify many files for the storage of data rather than just
the one. This will overcoem teh 2 gig file limit.
Hope this helps.
Keith
"Rehan Ahmed" wrote:
>
>Dear Author,
>
>Hi
>
>As there is no data splitting supported at the product level so the
>solution is just a work around. You have to manually splitt the data
>based on the dates and than You have to change your application program
>accordingly. In this way you can perform splitting. i.e if the date
>is less than the split date than search in Primary database else
>search in the splitted database
>
>I hope it will serve your purpose.
>
>
>Thanks
>Rehan Ahmed Khan
>
>
>"Leelu" wrote:
>>
>>Hi,
>>My database reaches 1.9 Giga and I have to split up in
>>6 or more databases.
>>Could you give me the command line I have to type?
>>Thanks
>