New Contributor
Posts: 1
Registered: ‎01-08-2018

sqooping multiple tables that ends with a certain character from different schema in oracle

hi experts out there - 


I would like to sqoop import multiple tables from oracle tables but only tables that ends with certan strings from different schemas. For example, our oracle structure is




podxx.user... and we keep adding podxx time to time. Instead of updating script whenever new pod is added i would like to see whether there is any way to import these user tables from different schema using regex. Can anyone advise whether this is doable?


Thanks in advance,


New solutions