1. No, they come anyway, use rows=no on import. (and indexes=no, etc).
2. yes, just list the tables you want to import.

-----Original Message-----
From: Deepak Baranwal
[mailto:oracledba-ezmlmshield-x94013485.[Email address protected]
Sent: Wednesday, September 07, 2005 2:51 AM
To: LazyDBA Discussion
Subject: export help

Dear DBA's
1 .I want to include the all objects (procedures, functions, packages
.....)
under the export dump.Do i have spcifically specify some clauseto
include
them.
2. Taking this export, is there any to import only selected tables (say
only
A) ??


"parfile.par"
------------------------------
file=7september.export
statistics=none
direct=y
tables=(
A,
B,
C
..........
)
---------------------------

$ exp user/password parfile=parfile.par



Deepak Baranwal
(Database Administrator)
HCL Technologies Ltd.
E-4,5,6 Secter 11,
NOIDA
Tel: +91-120-2556433
201301


\\\///
/ \
| \\ // |
( | (.) (.) |)
---------o00o--(_)--o00o-----------------

Disclaimer:
This message and any attachment(s) contained here are information that
is
confidential,
proprietary to HCL Technologies and its customers. Contents may be
privileged or
otherwise protected by law. The information is solely intended for the
individual or the entity it is addressed to. If you are not the intended

recipient of this message, you are not authorized to read, forward,
print,
retain, copy or disseminate this message or any part of it.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and delete it from your computer.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page