Thanks for your time. Actually you are right. I was migrating the
database from oracle to MySQL and had issues with migrating few tables in it.
I saw that the reason was that the size of the table. So, I changed the
settings in the migration kit with the Dynamic settings and migrated again.
It was successful. Basically the problem is that when we try to migrate the
DB from oracle to MySQL, the number of rows that has to migrate are set as
DEFAULT. So, we have to get rid of it by setting it as DYNAMIC and change few
other settings. And thus, we get rid of the problem. Anyways, I appreciate
From: Dan Nelson [mailto:dnelson@stripped]
Sent: Tuesday, March 13, 2007 2:08 PM
To: Tangirala, Srikalyan
Cc: dgriffiths@stripped; mysql@stripped
Subject: Re: How can I increase the size of the table
In the last episode (Mar 13), Tangirala, Srikalyan said:
> I'm a newbie and I'm trying to understand how can I increase or set
> the size of the table in Oracle database. I'm trying to migrate the
> database from oracle to MySQL and was successful in that. But, few of
> the tables are not created and when I checked back in the oracle
> database, it displays the following warning.
> The table GOESDBA.SAT_PARAM_VALUES contains more than 2000 rows.
> Displaying all the columns and rows of the table could be
That's probably generated by whatever query tool you're using, not by
Oracle itself. Check its documentation to see how to remove or bypass
> I want to display all the columns and rows of the table but for doing
> that I understand that the size of the table has to be increased. How
> can I get over it? Any suggestions?
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql