OraFAQ Forum: Server Utilities » exporting big table

Home » RDBMS Server » Server Utilities » exporting big table

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

exporting big table [message #190669]

Thu, 31 August 2006 12:05

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

I have a table of 12 gb and want to transport it to different database, it takes to much time when using table mode export, how can i transport it quick.

Report message to a moderator

Re: exporting big table [message #190672 is a reply to message #190669]

Thu, 31 August 2006 12:32

goudelly
Messages: 52
Registered: August 2006
Location: India

Member

Hi,

You can offline the tablespace and move the datafiles with OS level. After moveing to other database the tablespace you can online.

In case you have only one table is 12gb then make the table in to partions. There is some method is there if you want we can give to you.

Thanks,

Report message to a moderator

Re: exporting big table [message #190676 is a reply to message #190669]

Thu, 31 August 2006 12:45

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

but will partitionng save time.
and if i do a transportable tablespace then how can i assign it to specific user?

Report message to a moderator

Previous Topic:	SQL Loader Date&Time Upload Column Problem
Next Topic:	IMPORT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 00:10:14 CST 2024