OraFAQ Forum: Server Utilities » listing the tables contained in a dump file

Home » RDBMS Server » Server Utilities » listing the tables contained in a dump file

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

listing the tables contained in a dump file [message #333725]

Mon, 14 July 2008 04:53

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.

Report message to a moderator

Re: listing the tables contained in a dump file [message #333731 is a reply to message #333725]

Mon, 14 July 2008 05:09

Michel Cadot
Messages: 68649
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

Report message to a moderator

Re: listing the tables contained in a dump file [message #333735 is a reply to message #333731]

Mon, 14 July 2008 05:21

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 ?

Report message to a moderator

Re: listing the tables contained in a dump file [message #333739 is a reply to message #333735]

Mon, 14 July 2008 05:33

Michel Cadot
Messages: 68649
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

Report message to a moderator

Re: listing the tables contained in a dump file [message #333742 is a reply to message #333739]

Mon, 14 July 2008 05:42

sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal

Member

Ok. I will try it.

Thanks.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 02:10:57 CDT 2024