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: when to use SQL loader
Next Topic: to accept the column which has newline character into the table using sql loader
Goto Forum:
  


Current Time: Sun Aug 20 20:01:53 CDT 2017

Total time taken to generate the page: 0.03718 seconds