Home » RDBMS Server » Server Utilities » is there any utility in oracle
icon7.gif  is there any utility in oracle [message #297533] Fri, 01 February 2008 04:40 Go to next message
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]
Re: is there any utility in oracle [message #297538 is a reply to message #297533] Fri, 01 February 2008 04:50 Go to previous messageGo to next message
Littlefoot
Messages: 20893
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 ./fa/1681/0/
Re: is there any utility in oracle [message #297539 is a reply to message #297533] Fri, 01 February 2008 04:51 Go to previous message
Michel Cadot
Messages: 64108
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:
  


Current Time: Mon Dec 05 04:51:47 CST 2016

Total time taken to generate the page: 0.09880 seconds