OraFAQ Forum: Server Utilities » is there any utility in oracle

Home » RDBMS Server » Server Utilities » is there any utility in oracle

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

is there any utility in oracle [message #297533]

Fri, 01 February 2008 04:40

amritaseema
Messages: 47
Registered: January 2008

Member

Hi,
all i have some questions..in my mind
1)is there any utility in oracle to load and unload datas or for that we have to write control files??
2)wht does util file does?
can anyone plzz help me out

Thanks
Seema.[/B]

Report message to a moderator

Re: is there any utility in oracle [message #297538 is a reply to message #297533]

Fri, 01 February 2008 04:50

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If your database version supports them, you could use the external tables feature as well.
UTL_FILE is used in PL/SQL programs to read and write operating system files.

Both external tables and UTL_FILE can be researched if you

Report message to a moderator

Re: is there any utility in oracle [message #297539 is a reply to message #297533]

Fri, 01 February 2008 04:51

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ load: sql*loader, unload:sql*plus
2/ utl_file: read/write to file

http://otn.oracle.com/pls/db102/db102.federated_search to search in Oracle documentation.
Hope you will never come here with this kind of questions.

Regards
Michel

[Updated on: Fri, 01 February 2008 04:51]

Report message to a moderator

Previous Topic:	Problems setting up Dumpfile Location
Next Topic:	Export and Import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 15 21:48:04 CDT 2024