Re: AW: catalogload said talbe is readonly

[Gu Lei]

Schildberg, Steffen ??:
Hi Gu Lei,
Gu Lei [mailto:[EMAIL PROTECTED] wrote:
 

Loader protocol: '/home/sdb/.sdb/loader/log/loader.prt'
User USR connected to database MAIL on local host.
loadercli>catalogload user instream file only_fk
-25392
'[MySQL MaxDB][LIBSQLOD SO][MaxDB] General error;-115 POS(1) Table is
read only'
OK
   

Hmm, strange, I'd say. How can a table be read only if you create it?
Or does the file name only_fk point to the fact that only foreign keys
shall be created? If so - what did you do with that table prior to
creating the fk? If you used FASTLOAD to load it the table is set to
read only and you need to backup the DB.
Regards,
Steffen
 

Hi Steffen:
You are right. I loaded some data by loadercli before.
After I backup the DB it's ok. Thanks a lot!
There's another question.
I used only_fk to create foreign keys after TABLELOAD USER finished.
Loadercli would show me an error about integrity if I created foreign 
keys before TABLELOAD USER.
It seems that TABLELOAD doesn't take into account loading order to 
prevent integrity error.
Maybe I'm wrong.
Any suggestion?

Regards gulei
--
   _/\_
  /    \
__\    /__          ??:
\        /
 \      /
 /      \           ????
/        \
/__      __\
 /      \           ????
|        |
|        |
_\      /_          ????
|          |
|          |
|          |         ????
|__________|