OraFAQ Forum: Backup & Recovery » tablespace export vs Schema export

Home » RDBMS Server » Backup & Recovery » tablespace export vs Schema export

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

tablespace export vs Schema export [message #564211]

Wed, 22 August 2012 02:09

bpmpk
Messages: 8
Registered: June 2012

Junior Member

Hi all ,

I have taken the tablespace export it came 2.1gb and for the same user i have taken the schema export it came 5.1gb

why their is a lot of difference in size?

Any please answer

Thanks

Report message to a moderator

Re: tablespace export vs Schema export [message #564213 is a reply to message #564211]

Wed, 22 August 2012 02:12

John Watson
Messages: 8928
Registered: January 2010
Location: Global Village

Senior Member

There is no reason for them to be the same. A tablespace can contain segments from many schemas, a schema can store segments in many tablespaces.

Report message to a moderator

Re: tablespace export vs Schema export [message #564218 is a reply to message #564211]

Wed, 22 August 2012 02:58

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

With your questions, ALWAYS post the commands you executed and your Oracle version (with 4 decimals).

Regards
Michel

Report message to a moderator

Re: tablespace export vs Schema export [message #564230 is a reply to message #564218]

Wed, 22 August 2012 04:59

bpmpk
Messages: 8
Registered: June 2012

Junior Member

Thanks john

[Updated on: Wed, 22 August 2012 05:00]

Report message to a moderator

Previous Topic:	ASM Instance
Next Topic:	Move DB to a new server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 11:24:13 CDT 2024