Originally posted by parijat67
1)Why isn't it importing the views/packages/procedures/sequences/triggers along with the table and the subset data? My application needs all these objects along with the subset data in the new user that i create using the import utility.
--Restrictions with using Querry in exp.

Originally posted by parijat67

2)How can I solve this problem and export a subset of table data along with all the other database objects present in a user? In the help of export I didnt find any keyword to be mentioned explicitly to import the packages/views/procedures along with the list of table names and the query statement.
-- Export again with rows=n (this will not export any data, only the table structure along with user objects like packages, views etc...)
Do not user querry option this time.

exp username/password owner=username file=filename log=logname rows=n tables=table_names

Then do the import with ignore=y option

imp username/pasword file=filename log=logname fromuser=username touser=username ignore=y

HTH