Home » RDBMS Server » Server Utilities » listing the tables contained in a dump file
listing the tables contained in a dump file [message #333725] Mon, 14 July 2008 04:53 Go to next message
sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal
Member
I created a dump file (.dmp) using the exp utility.
The dump file contains few tables and their data.

Now, I want to list only the names of the tables in the dump file. Is it possible?

I tried show=yes. But, it shows too much of details.

Is there any other way to do it?

Please suggest.

Thank you.
Re: listing the tables contained in a dump file [message #333731 is a reply to message #333725] Mon, 14 July 2008 05:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can use other options along with "show=y" like "rows=n".
You can also use "indexfile" option.

Regards
Michel
Re: listing the tables contained in a dump file [message #333735 is a reply to message #333731] Mon, 14 July 2008 05:21 Go to previous messageGo to next message
sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal
Member
But, this also shows the CREATE TABLE statement.

Can we get only the names, please ?
Re: listing the tables contained in a dump file [message #333739 is a reply to message #333735] Mon, 14 July 2008 05:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Pipe this with sed/awk...
You want something that is not provided, you have to build your tool.

Regards
Michel
Re: listing the tables contained in a dump file [message #333742 is a reply to message #333739] Mon, 14 July 2008 05:42 Go to previous message
sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal
Member
Ok. I will try it.

Thanks.
Previous Topic: SQLLDR using input file in different server
Next Topic: export error : converting column overflows integer datatype
Goto Forum:
  


Current Time: Sun Dec 11 00:33:31 CST 2016

Total time taken to generate the page: 0.07955 seconds