If the unloaded file is too large, UNLOAD STRUCTURE, UNLOAD DATA to separate files. Edit the Structure file and split it into the table column structure and a second file for constraints and indexes. Using my naming conventions you will have three files: database.str, database.ind, database.dat. Edit the structure file to change the table name.
RUN Database.str RUN Database.dat RUN Database.ind You need to split out the constraints because the unload will not unload all the primary key tables followed by foreign keys, and data will not load. As well, the procedure will be much faster without indexes during the data load. "Alastair Burr" <[EMAIL PROTECTED]> wrote: >Sharon, you may have had a dozen answers by now as my posts seem to taking hours, if >not days, to get posted back to me at the moment, but you could try this: > >Make a backup of the database first!!! then... > >Highlight and copy the table name including the strange characters then type at the >R:> prompt: > >drop table [paste your copied text] [Return] > >If - and it's a big if - R:Base doesn't see that as a system table them it might drop >it for you. You can then reload the database and a new proper sys_defaults should be >created. > >Alternatively, backup up the database to a file and then edit the file with Wordpad >or Edit, whatever you use, and correct the name. Then restore the database. > >eg: > >out backup.txt; backup all; out screen >[edit backup.txt] >rename database db_old >run backup.txt > >If you desperately need to keep the layouts you have you could backup the data to a >file first and then reload them once you have the table name correct: > >out layouts.bup; unload data for sys_layouts; out screen >[do corrections] >run layouts.bup > >Hope this helps, >Regards, >Alastair. > > �----- Original Message ----- > �From: Sharon Lima > �To: R:Base List > �Sent: Wednesday, December 04, 2002 11:04 PM > �Subject: SYS_LAYOUTS table - name error > > > �I have a database that has an error in the name of the SYS_LAYOUTS table. > �Below it a snippet from the capture of the data check. > �See those extra characters at the end of the table name SYS_LAYOUTS > > � � Examining table SYS_LAYOUTS > � � � �Index: � � � � 14 > � � � �Column: � � � �SYS_LAYOUT_NAME > � � � �Column: � � � �SYS_LAYOUT_DATA > > �My question is, how can I fix most easily fix this database? > > �I the past I have resorted to dumping the data to ASCII files > �from the individual tables and then loading the data back into > �an uncorrupted database, table by table. > �There must be an easier way. > �Hope someone can help. > �Thanks, > �Sharon Lima > > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
