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

[Anonymous]

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

[Anonymous]

Hi,
Which DB component are you using? Could you please give us more information about your current job design?
Best regards
Sabrina

[Anonymous]

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"

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Dmitry2]

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