Home » RDBMS Server » Server Administration » Free Datadictionary tools
Free Datadictionary tools [message #54556] Thu, 21 November 2002 10:11 Go to next message
shail
Messages: 3
Registered: November 2002
Junior Member
Is anyone aware of free data dictionary tools that work with Oracle and also with flat files.

Thanks in advance.
Re: Free Datadictionary tools [message #54558 is a reply to message #54556] Thu, 21 November 2002 11:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
can you throw some light on this?
what do u mean by 'data dictionary tools'?
to load the flat files, u can use sql*loader

Re: Free Datadictionary tools [message #54564 is a reply to message #54558] Thu, 21 November 2002 14:05 Go to previous messageGo to next message
shail
Messages: 3
Registered: November 2002
Junior Member
Thank you for the response.

As of right now I would like something that can read off of flat files. We do not have Oracle yet but we will eventually. I just want the tool to be able to read from flat files right now, but be compatible with Oracle for when we do have it.

Thank you
Re: Free Datadictionary tools [message #54577 is a reply to message #54558] Fri, 22 November 2002 06:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
sql*loader is tool that comes alongwith oracle.
or
u can write a proceudure in pl/sql using UTL_FILE
Re: Free Datadictionary tools [message #54588 is a reply to message #54577] Fri, 22 November 2002 09:47 Go to previous message
shail
Messages: 3
Registered: November 2002
Junior Member
Mahesh,

Thank you very much for the response. The problem I will face is that we do not have Oracle yet and SQL*Loader looks like it comes with Oracle. Also, I was looking for something intelligent(not sure if SQL*Loader is) to flag duplicate data elements etc. Can you tell I am new to this stuff? :-)

Please advise.

Thank you
Previous Topic: Free space after a delete
Next Topic: locally Managed tablespaces
Goto Forum:
  


Current Time: Fri Sep 20 01:51:36 CDT 2024