This content has been marked as final. Show 5 replies
there is no such thing limit of number of table imported.....
are you getting any error after 1000 tables......
896398 wrote:What is the version?
i have created a user which import only 1000 tbales at a time but i want it to be import entire 5000 tables at a time what command i should give to this user to import more tables
Why can't use Schema Export? if you have skip only less number of tables then use EXCLUDE clause. http://www.oracle-ckpt.com/metadata-filtering-with-exclude-using-expdp/
no at a time it is importing 1000 only , can we give some tablespace command .please suggest the command to give unlimited tablespace
Edited by: 896398 on Jan 17, 2013 3:07 AM
post the command....
The version you are using will help here more than you think.
In some older versions of Data Pump, you could only export up to 4000 character table string. So, if your table names were 19 characters, you could only have 200 tables on the command. Got to add the , between names. This was fixed so you can have unlimited tables in the command. The same was true for tablespaces as well. I believe that there is no longer a limit, so make the table list as long as you want.
So, to help us help you, please list the version and the command.