OraFAQ Forum: Server Administration » Populate an Oracle table from external....

Home » RDBMS Server » Server Administration » Populate an Oracle table from external....

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

Populate an Oracle table from external.... [message #52508]

Fri, 26 July 2002 08:56

Nita
Messages: 34
Registered: March 2002

Member

How do I populate a new Oracle table from an external data source?

I'm using 8i on a W2K Server.

Many thanks for any help.

Report message to a moderator

Re: Populate an Oracle table from external.... [message #52510 is a reply to message #52508]

Fri, 26 July 2002 09:47

Sanjay
Messages: 236
Registered: July 2000

Senior Member

What external data source ? More details please.

Report message to a moderator

Re: Populate an Oracle table from external.... [message #52512 is a reply to message #52508]

Fri, 26 July 2002 11:10

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

If the external data u r talking about..is in the .txt files we can get that data into Tables using the UTL_FILE Package/SQL * Loader..refer to those documentation for furthur details...

sai

Report message to a moderator

Re: Populate an Oracle table from external.... [message #52516 is a reply to message #52508]

Fri, 26 July 2002 11:35

Radek
Messages: 33
Registered: April 2002

Member

You can check out sql loader too. It is utility that is able to import text files into db.
Radek

Report message to a moderator

Re: Populate an Oracle table from external.... [message #52543 is a reply to message #52508]

Mon, 29 July 2002 07:04

Sanjay
Messages: 236
Registered: July 2000

Senior Member

Output to a csv file and use SQLLoader to populate oracle database.

Report message to a moderator

Re: Populate an Oracle table from external.... [message #53203 is a reply to message #52543]

Tue, 03 September 2002 02:36

simon molan
Messages: 1
Registered: September 2002

Junior Member

I am doing some class work and the question is asking me to
Populate the department table with data from the dept table. Include only columns that you need????

Name Null? Type
------------------------------- -------- ----
COLUMN_NAME VARCHAR2(20)
DEPARTMENTID NOT NULL NUMBER(7)
NAME VARCHAR2(14)

Name Null? Type
------------------------------- -------- ----
DEPTNO NOT NULL NUMBER(2)
DNAME CHAR(14)
LOC CHAR(13)

what is my next step can anyone help me out???

Report message to a moderator

Previous Topic:	One user logins twice
Next Topic:	Creating a new database instance as a diferent unix user.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 21:18:12 CST 2024