Home » RDBMS Server » Server Utilities » Export all but table definitions
Export all but table definitions [message #168012] Tue, 18 April 2006 06:59 Go to next message
toax
Messages: 1
Registered: April 2006
Junior Member
Hi,
Our system is built around stored procedures. Now and then the development team change a stored procedure / trigger and/or view and we need to update a number of customers with the latest version.

Is it possibly to export all except table definitions for a specific owner(schema) and import it into a production data base?

If yes,
how do I write the exp and imp commands?

Report message to a moderator

Re: Export all but table definitions [message #168020 is a reply to message #168012] Tue, 18 April 2006 08:00 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not directly possible.
http://www.orafaq.com/forum/t/61926/42800/

Report message to a moderator

Previous Topic: Export Clob Column
Next Topic: Importing 10g dump to 9i DB
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 04 19:58:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.