Oracle SQL Developer is a free tool for SQL & PL/SQL development and reporting similar to Quest's Toad or Allround Automations' PL/SQL Developer.
8
votes
2answers
1k views
Script out Oracle DDL in an automated fashion
Oracle SQL Developer is able to export DDL through Tools -> Database Export... This works very well, but requires manual intervention.
I know of DBMS_METADATA.get_ddl(), but have found that the ...
0
votes
3answers
357 views
ORA-00905: missing keyword when trying to create a synonym
I have a problem when I try to create a synonym like this:
CREATE SYNONYM B2H.BILLING_USER_ACTIVITY@PACOMNET
FOR [email protected];
Why does this happen and how can ...
