CODEWITHSUNDEEP
oracle-sqldeveloper
Kirill
Kirill

Reputation: 8046

How to export executed statements from Oracle SQLDeveloper?

There is a statements logging in Oracle SQLDeveloper:

statements log

Is there any way to export them as plain text or log them to file?

UPD: The reason I want to collect statements to file is for easy diff (to compare expected vs truncated export). I have a schema which export is not completely performed by 'Tools -> Database export'. Indexes, constraints, packages and synonyms are missing in resulting file while they are obviously present in database and visible in SQLDeveloper.

Upvotes: 0

Views: 274

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22412

No, just copy and paste.

You could always do a client based jdbc trace or a database session trace if you wanted that to go to a file.

Upvotes: 2

Related Questions