EASY Q - How to check that import was successful? [message #189694] |
Fri, 25 August 2006 11:49  |
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   |
joy_division
Messages: 4963 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   |
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 #189713 is a reply to message #189712] |
Fri, 25 August 2006 15:36   |
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 #189932 is a reply to message #189918] |
Mon, 28 August 2006 11:37   |
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 #189973 is a reply to message #189955] |
Mon, 28 August 2006 15:34   |
joy_division
Messages: 4963 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 #190194 is a reply to message #190174] |
Tue, 29 August 2006 11:28   |
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...
|
|
|
|
|