OraFAQ Forum: Server Utilities » Importing Tables with new Definition

Home » RDBMS Server » Server Utilities » Importing Tables with new Definition

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

Importing Tables with new Definition [message #166917]

Mon, 10 April 2006 04:51

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi All,

I am facing a problem related with import.

We have one production DB and one test DB.

The developers made an upgrade to the prodution in the test DB.

They altered the table definitions like added new columns.

Also Rewrited the procedures, functions and triggers.

Is it possible to import the export dump from test to production without dropping the existing ones?

Please Help.

Rgds
SALIH KM Embarassed

Report message to a moderator

Re: Importing Tables with new Definition [message #166928 is a reply to message #166917]

Mon, 10 April 2006 06:56

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please re-phrase the question.
What do you mean by this?
>> The developers made an upgrade to the prodution in the test DB.
The developers upgraded production or test?

Report message to a moderator

Re: Importing Tables with new Definition [message #166929 is a reply to message #166928]

Mon, 10 April 2006 07:06

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi,

Developers altered the table structures by adding new columns.
Also made changes to procedures, functions and triggers.
This is done in test database.

But the number of tables , procedures, functions and triggers are same.

There is an export dump of that user.

I want to import that dump to production without dropping existing tables, procedures, functions and triggers.

Is it possible?

Rgds
SALIH KM Cool

[Updated on: Mon, 10 April 2006 07:07]

Report message to a moderator

Re: Importing Tables with new Definition [message #166939 is a reply to message #166929]

Mon, 10 April 2006 07:38

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I still do not understand your intention.
So, you want to 'import' only the changes in table columns and their corresponding data?
Just extract alter table commands from test and run it across production. And then, what happens to data?
Anyhow with procedure ( if the code is changed) , you NEED to re-create them.

Report message to a moderator

Re: Importing Tables with new Definition [message #166944 is a reply to message #166939]

Mon, 10 April 2006 07:46

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi ,

Thanks for your prompt reply.

How to Extract the alter commands?

Rgds
SALIH KM

[Updated on: Mon, 10 April 2006 07:47]

Report message to a moderator

Previous Topic:	ORACLE ERROR 1435
Next Topic:	Deadlock trace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 13 05:48:56 CST 2025