RE: Importing Text file into Oracle

you could use external tables



Regards
Chris Farmer



                                                                                                      
                      "Naveed"                                                                        
                      <[email protected]        To:       "Oracle" <[email protected]>               
                      .pk>                     cc:                                                    
                                               Subject:  [oracle] RE: Importing Text file into Oracle 
                      04/03/2003 09:08                                                                
                      Please respond to                                                               
                      "Oracle"                                                                        
                                                                                                      
                                                                                                      




You have to use SQL Loader

-----Original Message-----
From: Amir [mailto:[email protected]]
Sent: 04 March, 2003 1:53 PM
To: Oracle
Subject: [oracle] Importing Text file into Oracle

Hello everyone,

How can we import a text file into a table in Oracle Database. Do we use
SQL
Loader or Imp/Exp utility or is there another way. Can we import it
using
SQL Plus.

Regards,

Amir

Note: I am sorry if you have already addressed this couple of time.
----- Original Message -----
From: "Rajiv Khatri" <[email protected]>
To: "Oracle" <[email protected]>
Sent: Monday, March 03, 2003 9:20 AM
Subject: [oracle] How to pass a values from sqlplus to Unix prompt.


> Hi All,
>
> How to pass a values from sqlplus to Unix prompt.
>
>
> Thanks & Regards
> Rajiv
>
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or
> to unsubscribe send a blank email to %%email.unsub%%.
>

---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to %%email.unsub%%.

=======================================================
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please notify the sender or the
System Administrator at [email protected] .The unauthorized use,
disclosure or alteration of this message is strictly forbidden. Moreover,
this message has been scanned for the presence of computer viruses.


---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to %%email.unsub%%.






---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].