import/export package and function [message #215183] |
Fri, 19 January 2007 10:06  |
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 #215192 is a reply to message #215188] |
Fri, 19 January 2007 10:54  |
 |
Mahesh Rajendran
Messages: 10708 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.
|
|
|