Home » SQL & PL/SQL » SQL & PL/SQL » EASY Q - How to check that import was successful?
icon5.gif  EASY Q - How to check that import was successful? [message #189694] Fri, 25 August 2006 11:49 Go to next message
yatingg
Messages: 16
Registered: August 2006
Junior Member
I used the IMP command to import and it seemed to have worked. At the end of it, it said "Import terminated successfully with warnings." The only warning I saw in the log file was:

"The objects were exported by DBADMIN, not by you"

My questions are:
1. Do I need to fix that, or can I ignore the warning?
2. How can I check that my data went in? I have no clue how to work Oracle. Do I check in from Oracle Enterprise Manager Console, or from PL/SQL?

Please help!

Thanks!
Re: EASY Q - How to check that import was successful? [message #189698 is a reply to message #189694] Fri, 25 August 2006 12:38 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
I wouldn't worry about it. If there were no errors then you are ok. If you really want to check, there are just too many things you would have to check. you'd have to SELECT from every table that was imported, check that every function, procedure and package were created, etc.

Was this a single schema export or a full database export? If full database, then it should have been done by the SYS or SYSTEM and would best be imported with the same user, unless you set up a user with all the correct privileges. But since you said you don't know how to work oracle, I would assume you don't know anything about the rights of the exporter or importer.
Re: EASY Q - How to check that import was successful? [message #189704 is a reply to message #189698] Fri, 25 August 2006 13:01 Go to previous messageGo to next message
yatingg
Messages: 16
Registered: August 2006
Junior Member
It was a full export and a full import. I used system to import.

Under Schema Management, I used the "Find Database Object" tool to look for objects that I saw in the log file being created, but no results are returned. How is this possible? I don't need to check that everything was imported. I just want a little sign that some data went in.

Please help! Thanks in advance!

Re: EASY Q - How to check that import was successful? [message #189712 is a reply to message #189704] Fri, 25 August 2006 15:28 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
What were the exact commands for export and import that were used?
What was one object in particular that you are looking for.
What is Schema Management? I am unfamiliar with gui tools.
Re: EASY Q - How to check that import was successful? [message #189713 is a reply to message #189712] Fri, 25 August 2006 15:36 Go to previous messageGo to next message
yatingg
Messages: 16
Registered: August 2006
Junior Member
Actually I was given a .dmp file. So that's why I'm importing.

Here is my import command.

imp "system/password@SID" file=c:\dmp\full_exp1.dmp log=c:\dmp\log.txt TRANSPORT_TABLESPACE=Y full=yes SHOW=Y

I'm just looking for a table that I know was supposed to have been created during the import.

Schema Management - From Oracle Enterprise Manager Console, if you click on the Schema node in the treeview, the right side should give you some tools & wizards. "Find Databse Objects" is one of them.
Re: EASY Q - How to check that import was successful? [message #189918 is a reply to message #189713] Mon, 28 August 2006 09:20 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Can you post the log file?
The object you are looking for would be in the same schema that it was exported from.
Re: EASY Q - How to check that import was successful? [message #189932 is a reply to message #189918] Mon, 28 August 2006 11:37 Go to previous messageGo to next message
yatingg
Messages: 16
Registered: August 2006
Junior Member
The log file is huge. But I cut out a chunk that I would think should show up in my database after the import, but I see no signs of it. For example, the schema DOCSADM doesn't exist before the import. I would think that it would create it in the import. It doesn't look like it does, unless it's related to permissions, but I'm logged in as system, so I would think that I'd be able to see everything.


. importing DOCSADM's objects into DOCSADM
"ALTER SESSION SET CURRENT_SCHEMA= "DOCSADM""
"CREATE SEQUENCE "SEQSYSTEMKEY" MINVALUE 1 MAXVALUE 999999999999999999999999"
"999 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQSYSTEMKEY" TO "DOCS_USERS""
"GRANT SELECT ON "SEQSYSTEMKEY" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "DOCSADM""
"CREATE SEQUENCE "SEQPROFILE" MINVALUE 1 MAXVALUE 99999999999999999999999999"
"9 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQPROFILE" TO "DOCS_USERS""
"GRANT SELECT ON "SEQPROFILE" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "DOCSADM""
"CREATE SEQUENCE "SEQVERSIONS" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQVERSIONS" TO "DOCS_USERS""
"GRANT SELECT ON "SEQVERSIONS" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "DOCSADM""
"CREATE SEQUENCE "SEQNEEDS_INDEXING" MINVALUE 1 MAXVALUE 9999999999999999999"
"99999999 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQNEEDS_INDEXING" TO "DOCS_USERS""
"GRANT SELECT ON "SEQNEEDS_INDEXING" TO "DOCS_USERS""
. importing OCCADMIN's objects into OCCADMIN
"ALTER SESSION SET CURRENT_SCHEMA= "OCCADMIN""
"CREATE SEQUENCE "SEQSYSTEMKEY" MINVALUE 1 MAXVALUE 999999999999999999999999"
"999 INCREMENT BY 1 START WITH 4139839 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQSYSTEMKEY" TO "DOCS_USERS""
"GRANT SELECT ON "SEQSYSTEMKEY" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "OCCADMIN""
"CREATE SEQUENCE "SEQPROFILE" MINVALUE 1 MAXVALUE 99999999999999999999999999"
"9 INCREMENT BY 1 START WITH 158605 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQPROFILE" TO "DOCS_USERS""
"GRANT SELECT ON "SEQPROFILE" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "OCCADMIN""
"CREATE SEQUENCE "SEQVERSIONS" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 285796 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQVERSIONS" TO "DOCS_USERS""
"GRANT SELECT ON "SEQVERSIONS" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "OCCADMIN""
"CREATE SEQUENCE "SEQNEEDS_INDEXING" MINVALUE 1 MAXVALUE 9999999999999999999"
"99999999 INCREMENT BY 1 START WITH 12258 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQNEEDS_INDEXING" TO "DOCS_USERS""
"GRANT SELECT ON "SEQNEEDS_INDEXING" TO "DOCS_USERS""
. importing OVRADMIN's objects into OVRADMIN
"ALTER SESSION SET CURRENT_SCHEMA= "OVRADMIN""
"CREATE SEQUENCE "SEQSYSTEMKEY" MINVALUE 1 MAXVALUE 999999999999999999999999"
"999 INCREMENT BY 1 START WITH 1898 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQSYSTEMKEY" TO "DOCS_USERS""
"GRANT SELECT ON "SEQSYSTEMKEY" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "OVRADMIN""
"CREATE SEQUENCE "SEQPROFILE" MINVALUE 1 MAXVALUE 99999999999999999999999999"
"9 INCREMENT BY 1 START WITH 29 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQPROFILE" TO "DOCS_USERS""
"GRANT SELECT ON "SEQPROFILE" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "OVRADMIN""
"CREATE SEQUENCE "SEQVERSIONS" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 30 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQVERSIONS" TO "DOCS_USERS""
"GRANT SELECT ON "SEQVERSIONS" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "OVRADMIN""
"CREATE SEQUENCE "SEQNEEDS_INDEXING" MINVALUE 1 MAXVALUE 9999999999999999999"
"99999999 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQNEEDS_INDEXING" TO "DOCS_USERS""
"GRANT SELECT ON "SEQNEEDS_INDEXING" TO "DOCS_USERS""
. importing TDSHS_ADMIN's objects into TDSHS_ADMIN
"ALTER SESSION SET CURRENT_SCHEMA= "TDSHS_ADMIN""
"CREATE SEQUENCE "TDSHS_TABLE_DECODE_SEQ" MINVALUE 1 MAXVALUE 99999999999999"
"9999999999999 INCREMENT BY 1 START WITH 2340 CACHE 20 ORDER NOCYCLE"
. importing OCC_PUBLIC's objects into OCC_PUBLIC
"ALTER SESSION SET CURRENT_SCHEMA= "OCC_PUBLIC""
"CREATE SEQUENCE "SEQSYSTEMKEY" MINVALUE 1 MAXVALUE 999999999999999999999999"
"999 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQSYSTEMKEY" TO "DOCS_USERS""
"GRANT SELECT ON "SEQSYSTEMKEY" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "OCC_PUBLIC""
"CREATE SEQUENCE "SEQPROFILE" MINVALUE 1 MAXVALUE 99999999999999999999999999"
"9 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQPROFILE" TO "DOCS_USERS""
"GRANT SELECT ON "SEQPROFILE" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "OCC_PUBLIC""
"CREATE SEQUENCE "SEQVERSIONS" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQVERSIONS" TO "DOCS_USERS""
"GRANT SELECT ON "SEQVERSIONS" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "OCC_PUBLIC""
"CREATE SEQUENCE "SEQNEEDS_INDEXING" MINVALUE 1 MAXVALUE 9999999999999999999"
"99999999 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQNEEDS_INDEXING" TO "DOCS_USERS""
"GRANT SELECT ON "SEQNEEDS_INDEXING" TO "DOCS_USERS""
. importing ORACLE's objects into ORACLE
"ALTER SESSION SET CURRENT_SCHEMA= "ORACLE""
"CREATE SEQUENCE "COA_USER_DATA_ID_SEQ" MINVALUE 1 MAXVALUE 9999999999999999"
"99999999999 INCREMENT BY 1 START WITH 30 NOCACHE NOORDER NOCYCLE"
"GRANT SELECT ON "COA_USER_DATA_ID_SEQ" TO "COA_SUPV_RL""
"GRANT SELECT ON "COA_USER_DATA_ID_SEQ" TO "COA_ADMIN_RL""
. importing COA_PUBLIC's objects into COA_PUBLIC
"ALTER SESSION SET CURRENT_SCHEMA= "COA_PUBLIC""
"CREATE SEQUENCE "SEQSYSTEMKEY" MINVALUE 1 MAXVALUE 999999999999999999999999"
"999 INCREMENT BY 1 START WITH 8731 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQSYSTEMKEY" TO "DOCS_USERS""
"GRANT SELECT ON "SEQSYSTEMKEY" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "COA_PUBLIC""
"CREATE SEQUENCE "SEQPROFILE" MINVALUE 1 MAXVALUE 99999999999999999999999999"
"9 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQPROFILE" TO "DOCS_USERS""
"GRANT SELECT ON "SEQPROFILE" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "COA_PUBLIC""
"CREATE SEQUENCE "SEQVERSIONS" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQVERSIONS" TO "DOCS_USERS""
"GRANT SELECT ON "SEQVERSIONS" TO "DOCS_USERS""
"ALTER SESSION SET CURRENT_SCHEMA= "COA_PUBLIC""
"CREATE SEQUENCE "SEQNEEDS_INDEXING" MINVALUE 1 MAXVALUE 9999999999999999999"
"99999999 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
"GRANT ALTER ON "SEQNEEDS_INDEXING" TO "DOCS_USERS""
"GRANT SELECT ON "SEQNEEDS_INDEXING" TO "DOCS_USERS""
. importing CSRWEB's objects into CSRWEB
"ALTER SESSION SET CURRENT_SCHEMA= "CSRWEB""
Re: EASY Q - How to check that import was successful? [message #189947 is a reply to message #189932] Mon, 28 August 2006 12:52 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Looks like I missed something.

You mentioned about the export was done as DBADMIN. DBADMIN did not have rights to the object, hence it was not in the export.
Re: EASY Q - How to check that import was successful? [message #189950 is a reply to message #189947] Mon, 28 August 2006 12:58 Go to previous messageGo to next message
yatingg
Messages: 16
Registered: August 2006
Junior Member
Ok, so the warning at the beginning said it was exported by dbadmin. But I was importing using system, which should have rights to the objects, so shouldn't it still be ok?
Re: EASY Q - How to check that import was successful? [message #189952 is a reply to message #189950] Mon, 28 August 2006 13:01 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
But DBADMIN didn't have rights to it to export it. If it's not in the export, in cannot be imported. At least that's what it looks like. You'd need to look at the export log too, but you may not have that.
Re: EASY Q - How to check that import was successful? [message #189953 is a reply to message #189952] Mon, 28 August 2006 13:07 Go to previous messageGo to next message
yatingg
Messages: 16
Registered: August 2006
Junior Member
No, I do not have the export log. I was just given a dmp file. What kind of information would I need from the export? Perhaps I can ask the person who exported it.
Re: EASY Q - How to check that import was successful? [message #189954 is a reply to message #189953] Mon, 28 August 2006 13:10 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
You would want to see in the log that the table was indeed exported. I doubt it was as SYSTEM would be able to import it.
Re: EASY Q - How to check that import was successful? [message #189955 is a reply to message #189954] Mon, 28 August 2006 13:15 Go to previous messageGo to next message
yatingg
Messages: 16
Registered: August 2006
Junior Member
I would think that it was exported, otherwise, it wouldn't try to import it. That's common sense to me, since all I have is a .dmp file... unless there is something else about this process that I don't know about.
Re: EASY Q - How to check that import was successful? [message #189973 is a reply to message #189955] Mon, 28 August 2006 15:34 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
You can do a
imp show=y full=y userid=system/password@tnsentry file=yourfile.dmp log=somelogfile.lst

This will show the contents of the dump file and you can search for your table in there. Search for the create table and especially the create user docsadm.

yatingg wrote on Mon, 28 August 2006 14:15

I would think that it was exported, otherwise, it wouldn't try to import it.


Well, I can't really tell unless I know the exact export command line. I already have your import command line. You should have just did an export from SYSTEM. Can you not still do that?

[Updated on: Mon, 28 August 2006 15:40]

Report message to a moderator

Re: EASY Q - How to check that import was successful? [message #189976 is a reply to message #189973] Mon, 28 August 2006 16:20 Go to previous messageGo to next message
yatingg
Messages: 16
Registered: August 2006
Junior Member
I don't have control over the export. It was given to me by a client. The log file you saw was the log file from the import.
Re: EASY Q - How to check that import was successful? [message #190174 is a reply to message #189976] Tue, 29 August 2006 09:53 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Do the import command I gave you in the last posting and then show the lines in that log file for the "create table" and "create user" you are looking for.
Re: EASY Q - How to check that import was successful? [message #190194 is a reply to message #190174] Tue, 29 August 2006 11:28 Go to previous messageGo to next message
yatingg
Messages: 16
Registered: August 2006
Junior Member
The log does show the create tables. Just before the create table statements, it sets the current_schema to something that didn't seem to have been created. Does it not create the schema if it doesn't exist?

I also see a lot of create user statements, but don't see these users after the import...
Re: EASY Q - How to check that import was successful? [message #190200 is a reply to message #190194] Tue, 29 August 2006 12:16 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Oh! Doh! I see it. How did I miss this?

You used the keyword SHOW=Y, which will only list the contents of the file, and not actually import it.
Re: EASY Q - How to check that import was successful? [message #190201 is a reply to message #190200] Tue, 29 August 2006 12:19 Go to previous message
yatingg
Messages: 16
Registered: August 2006
Junior Member
Oh, so if I take out the show=y, it'll import it? So what I was in the log was just what is in the dmp file??? UGH! Ok, I hope this is why... Thanks for that tip.
Previous Topic: Passing a recordset into a stored procedure from java
Next Topic: ORA 01555
Goto Forum:
  


Current Time: Mon Dec 05 21:36:15 CST 2016

Total time taken to generate the page: 0.08346 seconds