hi,
I have this situation. I work with Pentaho Spoon.
- I read some tables with a select from the schemaA.
- One of this tables in join is in the schema B (I call this table SchemaB.TableBBB).
- The DBA need to create a FK from SchemaC.TableCCC to SchemaB.TableBBB, but she can't because she has error ORA-00054 Resource busy and it's me that lock SchemaB.TableBBB.
...But I execute only a select...with the step "Table Input" for people that know Pentaho
It's possible that a table used in a select is locked to create a foreign key? The code in error don't modify SchemaB.TableBBB, it adds a FK
Thanks for the help