Hi Guys,
This is my first post here, I am a student of computer engineering and I would appreciate if someone could help me with a query I have with expdp of an Oracle database.
I am trying to run an export query to export all tables that contain STORE_ID column but only export if STORE_ID in (1,3,4), ignoring all records from eg. STORE_ID = 2 and, from > 5 stores.
So far I only have a list of tables that contains the column STORE_ID, see below:
expdp optolink/*****@LOCALDB DIRECTORY=DPDIR DUMPFILE=exp_optolink_.dmp LOGFILE=exp_optolink_.log SCHEMAS=optolink INCLUDE=TABLE: IN(SELECT table_name FROM user_tables ut WHERE EXISTS (SELECT 'x' FROM user_tab_columns utc WHERE ut.table_name = utc.table_name AND column_name = 'STORE_ID' ) AND table_name NOT LIKE '%$%')
Is it possible to do what I am trying to?
Thank you.
VictorZ