OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
RE: How can I increase the size of the table

From: Tangirala, Srikalyan (Srikalyan.Tangiralanortelgov.com)
Date: Tue Mar 13 2007 - 13:15:15 CDT

Hi Dan:
            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
your help.

Best,
Sri

-----Original Message-----
From: Dan Nelson [mailto:dnelsonallantgroup.com]
Sent: Tuesday, March 13, 2007 2:08 PM
To: Tangirala, Srikalyan
Cc: dgriffithsboats.com; mysqllists.mysql.com
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
> time-consuming

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
that warning.
 
> 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?

--
        Dan Nelson
        dnelsonallantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=srikalyan.tangiralanortelgov.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql