This content has been marked as final. Show 9 replies
sem_apis.bulk_load_from_staging_table can be used for loading into a non-empty model as well.
What you have encountered is a bug that has to do with total length of the two parameters namely staging_table_owner and staging_table_name.
A workaround would be to rename the staging table to a shorter name so that total length of staging_table_owner and staging_table_name plus four double-quotes and a period is less than or equal to 30 bytes.
Thank's - it works!
bw - Christian
Hello Cristian you explain as I rename the table names the truth is I do not understand much of oracle and I am again the same error could explain step by step I hope your answer
Thank you very much
"A workaround would be to rename the staging table to a shorter name so that total length of staging_table_owner and staging_table_name plus four double-quotes and a period is less than or equal to 30 bytes."
So, here is an example:
if your table owner name is: SCOTT
and staging table name is: THIS_IS_MY_STAGING_TABLE_NAME
then you may encounter this problem because length('"SCOTT"."THIS_IS_MY_STAGING_TABLE_NAME"') = 39 which is > 30.
The workaround would be to use a shorter table name, say STABLE, instead of THIS_IS_MY_STAGING_TABLE_NAME.
For this example, if you are connected as SCOTT, you can use the following rename command:
alter table THIS_IS_MY_STAGING_TABLE_NAME rename to STABLE;
Hello cristian thank you very much for your help but when I execute the sentence as follows sem_apis.bulk_load_from_staging_table execute ('pruebaoer', 'fabricio', 'stable'), and follow your advice and run it as follows sem_apis.bulk_load_from_staging_table ('pruebaoer', 'fabricio', 's') as rename the table but the error keeps coming out, maybe is the tablespace with establishing a network for data semantic is that the size is 128MB .. please help me
Thanks a lot
Please show the session log (including the detailed error message) and also, if possible, the last few events as shown on RDF$ET_TAB.
What happens is that I delete the database I will re-create the database and set the tablespace, but you mention that table is already created or do I have to create what happens is that I have little knowledge or you can give me thank you mail to keep in touch .... thanks
It is not very clear. Could you please post the sem_apis.bulk_load_from_staging_table invocation you are using and the detailed error message it returns upon failure?
Run the statement and all is well, but when I consult the ontology data in the table stable not submit any information ...
and review the data tables and it is not
Can you send me this file bulkload.ctl
believe that here is the error