I want to import tables using impdp. What is the wildcard syntax that will allow me to import all tables?
Solution: Wildcard for datapump import
It depends on your requirment ,
If you have only one application user on your production,Just export the schema and in the new database import it into the user wth the same name..
Note : remember to user remap_tablespace and remap_schema parameter if you tablepsace or username in the destination site is different.
Or from your destination site,create a database link to the prodution site and do a parallel export and import (this is the main advantage with data pump).
so check on what is your requirement.either is it a full db or a schema wise.