Home » RDBMS Server » Server Utilities » Need to copy table with NCLOB column into another database (10g to 11g) (Oracle 11g)
Need to copy table with NCLOB column into another database (10g to 11g) [message #571914] Tue, 04 December 2012 02:22 Go to next message
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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.
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 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: SQL Laoder Date Handling
Next Topic: ORA-01400: cannot insert NULL into ROW_ID
Goto Forum:
  


Current Time: Thu Mar 28 11:34:35 CDT 2024