One Star

create table if doesn't exist ,drop table if exist and create options

create table if doesn't exist ,drop table if exist and create options are not working.
when i used  "drop table if exist and create " it was throwing exception like "name is already used by an existing object". It shouldn't throw like that .Please let me know how to resolve this issue
7 REPLIES
Moderator

Re: create table if doesn't exist ,drop table if exist and create options

Hi,
Which DB component are you using? Could you please give us more information about your current job design?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: create table if doesn't exist ,drop table if exist and create options

toracle output.and action on table is "drop table if exist and create"
throwing exception like 
"
Exception in component tOracleOutput_1
java.sql.SQLException: ORA-00955: name is already used by an existing object
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:963)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1192)
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1731)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1701)
    at deposits_for4_2.bassett_furniture_0_1.Bassett_Furniture.tFileInputPositional_1Process(Bassett_Furniture.java:2230)
    at deposits_for4_2.bassett_furniture_0_1.Bassett_Furniture.tSetGlobalVar_2Process(Bassett_Furniture.java:1101)
    at deposits_for4_2.bassett_furniture_0_1.Bassett_Furniture.tOracleConnection_1Process(Bassett_Furniture.java:988)
    at deposits_for4_2.bassett_furniture_0_1.Bassett_Furniture.tFileInputProperties_1Process(Bassett_Furniture.java:825)
    at deposits_for4_2.bassett_furniture_0_1.Bassett_Furniture.tPrejob_1Process(Bassett_Furniture.java:476)
    at deposits_for4_2.bassett_furniture_0_1.Bassett_Furniture.runJobInTOS(Bassett_Furniture.java:3485)
    at deposits_for4_2.bassett_furniture_0_1.Bassett_Furniture.main(Bassett_Furniture.java:3352)
disconnected"
One Star

Re: create table if doesn't exist ,drop table if exist and create options

from 5 months it was working properly .since yesterday it was getting problem
Moderator

Re: create table if doesn't exist ,drop table if exist and create options

Hi,
It is probably caused by your DB.
Could you please search your table in SQL. such as: select OBJECT_NAME,CREATED,STATUS,TIMESTAMP from user_objects where OBJECT_name='TableName'; to see if there any procedure with same name?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: create table if doesn't exist ,drop table if exist and create options

Hi,
If i drop the table explicitly from sql developer  and using job it was working.for the next time i run the same job with drop table if exist and create it was not working and throwing that error
Moderator

Re: create table if doesn't exist ,drop table if exist and create options

Hi,
If i drop the table explicitly from sql developer  and using job it was working.for the next time i run the same job with drop table if exist and create it was not working and throwing that error

Could you please indicate the build version you are using? Does this issue repro on other talend studios?
I have splited your XulRunner issue into a new topic.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: create table if doesn't exist ,drop table if exist and create options

Hi,
I have the same issue.

When I specify the schema in the filed "Table" and select "Drop table if exists ant create" the table isn't removed. So I get the error "ORA-00955 name is already used by an existing object".
If the schema isn't specified (only table name), it works.
If the schema is specified and the action "Drop and create" is selected, it works.
It seems to be a component bug.
Regards