*** Trying to Import FULL export *****
I have created a new database.
Now I have created all required tablespaces that was there in my previous database, where from export has been taken.
Now If I will try to import with FULL=Y then ......
1. It will import all schema objects..... IS THAT CORRECT ???
2. What will happen to SYSTEM schema. New database has already a system schema and Export dump also has an old System schema. ..... WHAT WILL HAPPEN IN THIS CASE???
I will appreciate ur time spent for my query.
when you take a full export dump, the system schema objects are excluded from the export. means there is no System Schema object into your full export dump. Go ahead with your dump for full import without any hesitation.
"Greatest Rewards come only with Greatest Commitments!"
System schema will also be exported.
exp SYSTEM/password FULL=y FILE=dba.dmp GRANTS=y ROWS=y
Export: Release 188.8.131.52.0 - Production on Mon Mar 19 19:01:59 2001
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 184.108.40.206.0 - Production
With the Partitioning option
JServer Release 220.127.116.11.0 - Production
Export done in WE8DEC character set and AL16UTF16 NCHAR character set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table AQ$_INTERNET_AGENTS 0 rows exported
is anybody else can answer my doubt?
If you use the FROMUSER parameter with a list of usernames only those users will be imported.
Do not specify the TOUSER parameter.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
I don't want to import my data using USER option. That is surely possibe.
My question was different, what will happen with my new database System schema where I am iporting (FULL) data using
imp userid=<> file=<> FULL=Y
because I have taken FULL export before , that also contents System schema of my previous database.
If you import from the full export of your old database and if you specify the parameter IGNORE=Y then it will overwrite you existing SYSTEM schema and at the time of overwriting it will ignore the error. The most important thing during this operation is the password of your SYSTEM user will be also replaced with your old database SYSTEM user password.
Just Try it.
Yes it will import all objects for all schemas. If you use ignore=y then it skips (does not overwrite)the object creation and attempts to insert the data.
If the tables have a unique index or constraint then duplicate data errors out. If there is no unique constraint on those tables then you may get duplicate rows.
As for the system schema, the same applies. I did this this morning on Oracle 18.104.22.168 so I am fairly sure of this.
Yes your system password after import will be the same as the password on your source database.
Click Here to Expand Forum to Full Width