Printable View
Hi all!
Queries:
1.say a table EMP is stored in a tablespace ABC.Primary Key index PK_INDX is stored in ABC tablespace.P1 partition of sales Table is stored in ABC tablespace.
Now if we export with Tablespace = ABC,WHAT OBJECTS ARE EXPORTED:
a).EMP,P1 partition,PK_INDX Index.
b).Only EMP,PK_INDX.
2.I have not used OEM but I have a Query as below:
Could HTML Reports run:
a).With a Repository.
b).Without a repository.
Thanks & regards,
Amit.
As far as I'm aware the table, index and table to which the partiotion belongs will be exported.
The index will be exported no matter where it is stored if it's corresponding table is exported (unless indexes=N) and all partiotions of a table will be exported if a partition exists in an exported tablespace.
Hope that makes sense ;)
Regards
As a general rule "ALWAYS TAKE MORE THAN YOU NEED" when it comes to export. You never know what will happen and what you will need later.
Since indexes are not really export (only their DDL is) it is always a good idea to take the indexes as well.
Or, to be safe, do an export...
FULL=Y
ROWS=N
This will grab all the .DDL for the database and leave the data, this way you will have "backups" of all your structures. It takes about 2 minutes too.
MH
Hi!
Thanks forthe reply.My doubts are cleared!Thanks forputting in the effort.
Regards,
Amit.
It will cause an error. You can only transport a set of tablespaces that is self-contained. See Oracle 9i Administrator Guide P11-31 for information about transporting tablespaces.
When you use TABLESPACES= ... in the exp par file, all tables in this tablespace will be included in the dump file.
This includes all tables contained in the tablespace and all tables that have a partition located in the TABLESPACES=... list. Indexes are exported with their tables, regardless fo where the index is stored.
Hope that helps,
clio_usa
OCP 8/8i/9i DBA
Visit our Oracle DBA site
I thanks all for replying.I got my doubts cleared considering your
experienced guys replies.
Regards,
Take care.
Amit.