-
Hi all,
I want to touch the age old issue of Export/Import of Oracle databases. I am trying to import from a data dump - both the source & destination are of Oracle 816 and when I run my import command, this is the output I get :
"
Export file created by EXPORT:V08.01.06 via direct path
Warning: the objects were exported by SYS, not by you
import done in US7ASCII character set and US7ASCII NCHAR character set
Import terminated successfully without warnings.
"
I do not get any error messages, but no objects have been imported. Is this due to the character set mismatch ?
Thanks,
Shiva.
-
Could you post which options are you putting in the imp command?
Regards
Angel
-
This is my Parameter file
FILE = aleron_udb.dmp
TOUSER = aleron_data
FROMUSER = sys
-
Warning: the objects were exported by SYS, not by you
This will occur when you start importing from a user other the exported userid ..So nothing wrong in this error message ...
use the show or indexfile to see the contents of the dump ...
Radhakrishnan.M
-
sys objects cannot be imported boss ...
Radhakrishnan.M
-
Actually the SYS object was used so that all the objects of all the required schemas could be exported.
Now how do I go about importing it ?
If SYS objects could not be imported, is there any other alternative way to export all the schemas ( May be FULL = Y) ?
Thanks,
Shiva.
-
Hi,
Is the best moment to organize your database. You shall import one scheme every time:
1. Create tablespace scheme A.
2. Create user with default tablespace A.
3. imp sys/passwd file=XXX log=XXX indexfile=file fromuser=A touser=A
With this you have the code for the index creation.
4. imp sys/passwd file=XXX log=XXX indexes=no grants=y fromuser=A touser=A buffer=XXXX
5. Execute the creation indexes script.
Hope that helps
Angel
-
Ops,
You will need at least one index tablespace for each scheme if you want a separate scheme (data and indexes).
Regards
Angel
-
So does this mean that even if the import is done with username = 'SYS', I should be able to do an import schema wise ?? Or does the export also need to be schema wise ?
Thanks,
Shiva.
-
And also, I was trying to see the contents of the export file using the SHOW parameter as
FILE = aleron_udb.dmp
TOUSER = aleron_data
FROMUSER = sys
SHOW = Y
but it doesn't seem to work. Is there any other environment variable which needs to be set ?
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|