Home » RDBMS Server » Server Utilities » exporting big table
exporting big table [message #190669] Thu, 31 August 2006 12:05 Go to next message
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.
Re: exporting big table [message #190672 is a reply to message #190669] Thu, 31 August 2006 12:32 Go to previous messageGo to next message
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,

Re: exporting big table [message #190676 is a reply to message #190669] Thu, 31 August 2006 12:45 Go to previous message
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?
Previous Topic: SQL Loader Date&Time Upload Column Problem
Next Topic: IMPORT
Goto Forum:
  


Current Time: Mon Dec 05 13:16:15 CST 2016

Total time taken to generate the page: 0.10329 seconds