Is there anyway I could perform tablespace export on Oracle...

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: [FAQ] Oracle Database FAQ

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by Vinny
Submitted on 10/15/2003
Related FAQ: [FAQ] Oracle Database FAQ
Rating:	Rate this question:
Is there anyway I could perform tablespace export on Oracle 8.0.5? I have oracle 8i client installed in my machine. Could someone tell me if I can use my 8i client exp utility to export a tablespace residing on oracle 8.0 database? Also everytime I try to run exp from command line I get this error. EXP-00056: ORACLE error 2248 encountered ORA-02248: invalid option for ALTER SESSION EXP-00000: Export terminated unsuccessfully I could do the same directly from the box where the DB is located though.

Answer by Ed
Submitted on 1/19/2004
Rating: Not yet rated	Rate this answer:
You need to have the same Oracle client as the database. You can setup Oracle 8.0.5 on another machine to do an export, instead of yours. Or uninstall 8i client on your computer.

Answer by jesse05
Submitted on 5/18/2005
Rating: Not yet rated	Rate this answer:
You cannot export a tablespace. However, you can export the containt of that tablespace then drop the tablespace and finally recreate a new tablespace with the same specs.

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: