OraFAQ Forum: Server Utilities » Need to copy table with NCLOB column into another database (10g to 11g)

Home » RDBMS Server » Server Utilities » Need to copy table with NCLOB column into another database (10g to 11g) (Oracle 11g)

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

Need to copy table with NCLOB column into another database (10g to 11g) [message #571914]

Tue, 04 December 2012 02:22

Anishkrithik
Messages: 23
Registered: June 2011
Location: TN

Junior Member

Hi,

I need to copy one table which is having NCLOB column into our new DB(11g) from old DB (10g). As this table having huge records (1 crore) it is difficult to use direct insert statement (INSERT INTO ... SELECT * FROM @remotedb). Can you please suggest any other way. I don't have DBA privilage to use loader.

Report message to a moderator

Re: Need to copy table with NCLOB column into another database (10g to 11g) [message #571916 is a reply to message #571914]

Tue, 04 December 2012 03:01

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have 2 choices:
- Use a db link and INSERT SELECT
- Use Data Pump (which requires either a db link or a directory on both servers)

Regards
Michel

[Updated on: Tue, 04 December 2012 03:02]

Report message to a moderator

Re: Need to copy table with NCLOB column into another database (10g to 11g) [message #571919 is a reply to message #571916]

Tue, 04 December 2012 03:52

Anishkrithik
Messages: 23
Registered: June 2011
Location: TN

Junior Member

Is it possible to copy CLOB column from remote database using INSRT .. SELECT sttement?..If i do it is throwing error.

Report message to a moderator

Re: Need to copy table with NCLOB column into another database (10g to 11g) [message #571921 is a reply to message #571919]

Tue, 04 December 2012 04:25

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Copy and paste what you do and get (in text inline, no image, no attached file).

Before, Please How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Previous Topic:	SQL Laoder Date Handling
Next Topic:	ORA-01400: cannot insert NULL into ROW_ID

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 22:15:21 CST 2025