Home » RDBMS Server » Server Utilities » how to overwrite the table name (database version 9.0.1.0.0)
how to overwrite the table name [message #330582] Mon, 30 June 2008 09:16 Go to next message
dillango
Messages: 145
Registered: January 2008
Senior Member
Dear All,

While importing the dump file, how to overwrite the existing table?. ie. The table i am importing from the dump file, has been added new columns. I am unable to get these colums into the already existing table.

Please advise.
ILANGO


Re: how to overwrite the table name [message #330583 is a reply to message #330582] Mon, 30 June 2008 09:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Import does not overwrite.
If the table already exists and had you
asked imp to ignore the error (because the table already exists),
the table data will be appended (in case of any violation you get more errors).
So, drop the target table and import.
Re: how to overwrite the table name [message #330601 is a reply to message #330583] Mon, 30 June 2008 09:53 Go to previous messageGo to next message
dillango
Messages: 145
Registered: January 2008
Senior Member
Thank You Mr.Mahesh.

The problem I have is, this table is a master table and In order to remove this table, I have to remove all (child) tables first then only I can remove it.

I have one big doubt is (may be silly for you), while importing will oracle automatically take care the order of imports (ie. first master tables and then child tables).

Say for example, I am exporting all the tables for a particular user. If I am import the same file, If it import first child and then master tables, then all rows from the child table cannot be imported right?

ILANGO
Re: how to overwrite the table name [message #330605 is a reply to message #330601] Mon, 30 June 2008 09:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> while importing will oracle automatically take care the order of imports
yes.
If you are just synchronizing two schema,
just drop all the tables/objects in target and import all the objects. Imp will take care of everything.
Re: how to overwrite the table name [message #330609 is a reply to message #330605] Mon, 30 June 2008 10:07 Go to previous message
dillango
Messages: 145
Registered: January 2008
Senior Member
Thank you Mr.Mahesh for your valuable time.

Ilango
Previous Topic: Sql loader
Next Topic: ORA-00439
Goto Forum:
  


Current Time: Tue Dec 24 11:10:17 CST 2024