OraFAQ Forum: Server Administration » How to imp and export only one datafile

Home » RDBMS Server » Server Administration » How to imp and export only one datafile

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to imp and export only one datafile [message #51874]

Wed, 19 June 2002 02:24

Patrick Kuah
Messages: 1
Registered: June 2002

Junior Member

Hi all;

Pls help How to imp and export only one datafile, For example i need to export applsysd.dbf and applsysx.dbf to resize. I had the error of ora03297. what i have done so far is Truncate table. it had been reduce from 5G data to 600M.

Thank in advance

regards
Patrick

Report message to a moderator

Re: How to imp and export only one datafile [message #51880 is a reply to message #51874]

Wed, 19 June 2002 10:28

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

for ora-03297 you need to resize the datafile.
and i beleive, you cannot export a datafile ( becuase export itself is just a LOGICAL BACKUP of the database).

Report message to a moderator

Previous Topic:	How to connect to other (tablespace) database or older tablespace) database
Next Topic:	Re: ocp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 20:31:44 CDT 2024