For Oracle8i, is it possible?

I found that there are options 'TRANSPORT_TABLESPACE=' and 'TABLESPACES=' for export command in Oracle8i

However, I got the following error messages after I tried:
----------------------------------------------------------
C:\>exp file=users.dmp transport_tablespace=y tablespaces=users

Export: Release 8.1.6.0.0 - Production on Sun Dec 2 14:51:05 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.

Username: sys
Password:

Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
EXP-00044: must be connected 'AS SYSDBA' to do Point-in-time Recovery or Transportable Tablespace import
EXP-00000: Export terminated unsuccessfully
----------------------------------------------------------

How to resolve it?

exp userid="""sys/manager as sysdba""" transport_tablespace=y
tablespaces=(tts_ex1,tts_ex2)

Tom,
How could I get away without the sys password? I have tried and could not work out.

Thanks

In 9iR2:

If you dont specify the transport_tablespace=y parameter, the tablespaces= parameter does indeed export the tables contained in the specified tablespaces! Didnt know this, came as a welcome surprise!

We use 9iR2 on Solaris 8.

We have a large table with 90 daily partitions, each in its own tablespace. Each tablespace also contains partitions for 2 local indexes on the table (the partition key and one other). Each week, we drop partitions > 90 days old, and add new ones for next week.

We have been exporting the outdated partitions before dropping them, but I decided to actually LOOK at the .dmp file (show=y) and noticed that ALL of the tablespaces are contained in the export file, not just the ones for the exported partitions. So, I tried doing a tablespace level export, with tablespaces=( ts1, ts2, etc) and it was exporting ALL of the tablespace partitions until I killed the export.

These exports are only being done "just in case" the business gets up one day and decides it needs data > 90 days old....it will be a lot faster to restore from exports than any other way. We cannot take the tablespaces offline and are not doing this for purposes of transportability.

Is there a way to export ONLY the specified tablespaces and the data and index partitions in it? There is NOTHING in these tablespaces other than the data partition and the two index partitions, and no referential integrity to or from this table.

Excellent!

can I export only a singlr partition and then export.
syntax please.

I have install 9i.
When i am taking taking backup from export user.....i am geting an error messages..(RE$ACTION_IMP_TAB was tried to remove by exp_user) Actually anyone who want to drop any table in my database i have receive an email.

i m runing this command during export:
exp file=c:\ log=c:\ compress=n consistent=y full=y or owner=xyz

DB version 9.2.0.1.0
Error during Export of single user or full DB:

ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 311
ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 142

This error occur with sys / system / exp_user

here are the rights for export user

select * from session_roles;
ROLE
------------------------------
EXP_FULL_DATABASE
SELECT_CATALOG_ROLE
HS_ADMIN_ROLE
EXECUTE_CATALOG_ROLE
CONNECT

On start of backup i m geeting this error
. exporting object type definitions
. exporting system procedural objects and actions
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.LT_EXPORT_PKG", line 64
ORA-06512: at line 1

On the bottom i m getting this error

ORA-06512: at line 15
ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 311
ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 142
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully with warnings.

Dear Tom

One of our DBA has taken a export.
Now I would like to see the only contents of the export dump file without actually import into database.
Can i do this.

Thanks in advance
Devendra

Dear Tom,
Thanks for your reply.