Home » RDBMS Server » Server Administration » import/export package and function
import/export package and function [message #215183] Fri, 19 January 2007 10:06 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Hi,
i want to refresh a database but without touching a package and a function.is that possible?how do i retain that .
can you tell all possible methords
Re: import/export package and function [message #215188 is a reply to message #215183] Fri, 19 January 2007 10:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. RMAN tablespace level duplication.
2. Export only the tables you want to.
Re: import/export package and function [message #215192 is a reply to message #215188] Fri, 19 January 2007 10:54 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
oracle@mutation#exp scott/tiger tables=%

Export: Release 9.2.0.7.0 - Production on Fri Jan 19 11:56:22 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.7.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                           DEPT          4 rows exported
. . exporting table                            EMP         14 rows exported
. . exporting table                     PLAN_TABLE          0 rows exported
Export terminated successfully without warnings.
Previous Topic: set display
Next Topic: oracle upgrade
Goto Forum:
  


Current Time: Fri Sep 20 04:59:02 CDT 2024