Home » RDBMS Server » Backup & Recovery » Database export with different number of column
Database export with different number of column [message #168189] Wed, 19 April 2006 04:07 Go to next message
Ajitpal
Messages: 18
Registered: May 2005
Location: Malaysia
Junior Member
Hi Guys,

I have 2 databases located in two different server where the source server has more columns than the destination server.

For example, in tableA at source, i have 10 columns
and in tableA at destination, i have 8 columns

How do i actually transfer the data in source which matches the column of the data in the destination

If i use exp utility, it seems like it copies the whole database.

thank you very much in advance

Report message to a moderator

Re: Database export with different number of column [message #168331 is a reply to message #168189] Wed, 19 April 2006 15:50 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Well, you can always use the SQL*Plus COPY command, create a Materialized View, or do a CTAS (CREATE TABLE AS) across a DB Link.

Report message to a moderator

Re: Database export with different number of column [message #168497 is a reply to message #168189] Thu, 20 April 2006 13:25 Go to previous message
markmal
Messages: 113
Registered: April 2006
Location: Toronto, Canada
Senior Member
Or, if you need to load data exactly from that export dump.

create separate schema (i.e IMPSCHEMA), import the table there (yes, you can import a single table, even can apply a filter which rows to import).

then issue
INSERT INTO MYTABLE ...
SELECT ... FROM IMPSCHEMA.MYTABLE

[Updated on: Thu, 20 April 2006 13:26]

Report message to a moderator

Previous Topic: Help on this RMAN job
Next Topic: ORA-01113: file 3 needs media recovery
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 03:11:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.