|
Re: Question Related to Export dump file [message #70137 is a reply to message #70133] |
Fri, 19 April 2002 04:07 |
Cindy
Messages: 88 Registered: November 1999
|
Member |
|
|
See your log file.
Here is an example:
SQL> create table t(col1 number(5));
Table created.
SQL> insert into t values(1);
1 row created.
SQL> c/1/2
1* insert into t values(2)
SQL> /
1 row created.
SQL> c/2/3
1* insert into t values(3)
SQL> /
1 row created.
SQL> commit;
Commit complete.
SQL>
SQL> host
> exp dais/dais log=test.log file=test.dmp tables=T
Export: Release 8.1.7.2.0 - Production on Fri Apr 19 07:55:11 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production
Export done in US7ASCII character set and US7ASCII NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table T 3 rows exported
Export terminated successfully without warnings.
>
> cat test.log
Connected to: Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production
Export done in US7ASCII character set and US7ASCII NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table T 3 rows exported
Export terminated successfully without warnings.
|
|
|
Re: Question Related to Export dump file [message #70143 is a reply to message #70137] |
Fri, 19 April 2002 21:42 |
Praveen Kagalkar
Messages: 2 Registered: April 2002
|
Junior Member |
|
|
Thanks for the reply. This works fine if i am using exp command and view the log file immediately. But assume that i have only dmp file and no log file with me. Then using exp command can i find how many users or table are there in dmp file. Also can i see the DDL and DML statement in DMP file using exp command only.
Thanks for the reply in advance.
|
|
|
Re: Question Related to Export dump file [message #70145 is a reply to message #70143] |
Sun, 21 April 2002 18:44 |
Cindy
Messages: 88 Registered: November 1999
|
Member |
|
|
You can specify the log parameter as you can see on the example. From my experiences with exporting and importing. The answer to your question if you would be able to see the DDL and DML statements in dump file. You can see DDL statements along with binary codes and the raw data in your dump file, but I am not sure if you can see DML statements. I have not done my research on that yet.
|
|
|
|
Re: Question Related to Export dump file [message #70154 is a reply to message #70143] |
Mon, 22 April 2002 11:47 |
Cindy
Messages: 88 Registered: November 1999
|
Member |
|
|
Grant, show parameter will allow us to see DML statement in a dump file after converting it to assci file? Also, what is the actual purpose of the import function here...just for converting purpose or importing data back to the database as well? If the purpose here is for convertion without loading the data back to database, I have not used the import function this way before...anyway, good to know...
Thanks,
Cindy
|
|
|
|