1

I am trying to export some data from a connection say UAT to DEV. Once I export my data into a new table, would do a MINUS to get the missing or incorrect data. I don't have the option of creating a dblink.

SELECT * FROM TABLE1
MINUS
SELECT * FROM NEWLYIMPORTED_TABLE;

I am able to export the data and import it to a new table. However, the MINUS does not work since the table metadata is not exported. Is there an option to export/import table metadata (as in column's properties besides the column name) to be able to do MINUS.

I am using Oracle SQL Developer 19.2

Improve this question
1
  • since it's dev, why not just nuke it, and re-create it from scratch with a data pump export of your source instance? Commented Apr 27, 2020 at 15:45
Related questions
60
How to export data with Oracle SQL Developer?
3
Export Data Definition Script from an Oracle Database
1
Export Oracle Table Data by DBMS_XMLGEN -> How to Import?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.