Home » RDBMS Server » Backup & Recovery » tablespace export vs Schema export
tablespace export vs Schema export [message #564211] Wed, 22 August 2012 02:09 Go to next message
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
Re: tablespace export vs Schema export [message #564213 is a reply to message #564211] Wed, 22 August 2012 02:12 Go to previous messageGo to next message
John Watson
Messages: 4405
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.
Re: tablespace export vs Schema export [message #564218 is a reply to message #564211] Wed, 22 August 2012 02:58 Go to previous messageGo to next message
Michel Cadot
Messages: 58628
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
Re: tablespace export vs Schema export [message #564230 is a reply to message #564218] Wed, 22 August 2012 04:59 Go to previous message
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:
  


Current Time: Thu Jul 31 01:45:35 CDT 2014

Total time taken to generate the page: 0.22776 seconds