OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » export to cd

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

export to cd [message #73195]

Sun, 29 February 2004 11:41

sunitha agarwal
Messages: 7
Registered: February 2004

Junior Member

hi
i have one dought regarding export
shall i export to one place eg exp.dmp
if i write that file to a cd then copy to a location if i import from thaT Location whether it is correct format or invalidated.How can we
export database objects like packages,stored procedures functions
that stored in system tablespace whether it is possible
pls provide a eg any kind of help is appreciable
regards
sunitha agarwal

Report message to a moderator

Re: export to cd [message #73197 is a reply to message #73195]

Mon, 01 March 2004 03:53

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

Senior Member
Account Moderator

1. do the export , ftp the dmp file out of the server IN BIN mode and then write to the CD. It will work fine.
2. as per your post
>>"export database objects like packages,stored >>procedures functions
>>that stored in system tablespace "
by oracle standards only ORACLE METADATA should reside in system tablespace.
YOU NO NEED to export those items.
but if u have any other custom objects in system tablespace FIRST MOVE THEM OUTOF SYSTEM TABLESPACE and do the export.
Oracle strongly recomends NOT TO HAVE ANY CUSTOM OBJECTS
IN SYSTEM TABLESPAE.

Report message to a moderator

Re: export to cd [message #73198 is a reply to message #73197]

Mon, 01 March 2004 07:41

sunitha agarwal
Messages: 7
Registered: February 2004

Junior Member

how to move the objects dataobjects from system tablespace to another or how to copy it but simple export will work it or not
can u clarify more on IN BIN mode
by sunitha

Report message to a moderator

Previous Topic:	Import from higher version(8.1.5) to Lower version(8.0.3)
Next Topic:	Import Utility Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 01:45:14 CDT 2024