Home » RDBMS Server » Server Utilities » export & import tables and procedures @ schema level
export & import tables and procedures @ schema level [message #176733] Fri, 09 June 2006 06:14 Go to next message
lenakarthik
Messages: 2
Registered: January 2006
Location: Bangalore
Junior Member
Hi Gurus...

How to export & import all tables and procedures from one
schema to another in same database.

Oracle version: Release 9.2.0.1.0

Regards
- Karthik

Report message to a moderator

Re: export & import tables and procedures @ schema level [message #176737 is a reply to message #176733] Fri, 09 June 2006 06:21 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Try:

exp OWNER=...

imp FROMUSER=... TOUSER=...

For more info, consult the Oracle Utilities Users guide.

Report message to a moderator

Previous Topic: Ignore Last line of Text File in SQLLOADER - URGENT!!!!!
Next Topic: sql loader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 08:27:26 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.