Kbase 21957: Binary Load Errors with 6183 -- Why?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/04/2002 |
|
SUMMARY:
When you perform a binary dump of a table and attempt to load it into another database which is suppose to be identical to source database, you might sometimes receive error 6183:
Table <name> is number <num> in dump file and <num> in schema.
(6183)
EXPLANATION:
This is an informational message. The purpose of the message is just to let you know that the source and target databases have different table numbers for the same table name. This is normal. If you are creating a database from another database and have not made any schema changes, such as adding or deleting tables, then the source and target table numbers typically will match.
If your original database has had some tables added and deleted, you will have an inconsistency in table numbers between the source and target databases. This is due to the way table numbers are assigned within the database manager. Table numbers are assigned in ascending order and are not reused. Thus, any modifications that involve adding or deleting tables within your source database typically will not be seen in a dump of the .df. They would however be seen in an incremental .df. Therefore, if you dumped the .df from your source database and loaded it into a new empty database, you would not have consistent table numbers.