OraFAQ Forum: Server Utilities » export/import and files size

Home » RDBMS Server » Server Utilities » export/import and files size

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

export/import and files size [message #160987]

Wed, 01 March 2006 04:50

alanm
Messages: 284
Registered: March 2005

Senior Member

hi all,
probably a bit of a daft question.
I have approx 15 GB of tablespace to export to disk. will this create a 15 GB export file or is the dump file larger than the tablespace?

cheers

Report message to a moderator

Re: export/import and files size [message #160999 is a reply to message #160987]

Wed, 01 March 2006 06:14

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

Senior Member
Account Moderator

Depends.
export will dump only the table data. For index, only ddl is exported and will be rebuilt during import.
So, the question is out of 15Gb tablespace how much is actually used (only table data).

Report message to a moderator