EXP/IMP (FROM 805 TO 815)

[ocpdude]

Hi,
Here is the steps I've done so far.
-- backed up the hardisk
-- exp80 full=y
spool network
-- select name from $datafile
-- select name from v$controlfile
-- select * from v$logfile
spool off
-- copy init.ora,tnsname.ora to network
-- reformat the hardisk
-- installed winNT server pack6
-- installed oracle8.1.6

My 805 database has a desinger repository.
So when I did a full EXP I assumed it included the repository with it..( Plz correct me if I am worng)..I installed
816 (using preconfigured database) on my NT server and did a full import, everything wen smooth(except for the designer stuff) any idea !!!!!!!!!!!!!!!!!!!!!!!!!!!!

HOPE THIS HELPS
thanks,

[maachan]

Did you create a schema for the designer repository data or did you install it as SYS?
SYS user schema does not export/import.

If you did create a schema for designer, create the schema in the new database, grant all access and privileges, then import user-mode.

See if that works.

Good luck

[sreddy]

Ocpdude,

I did mention to you before and I am telling you now, to the level of my knowledge, your designer stuff can't be imported the way you import the database/schemas. You have to use designer "Repository Administration Utility" Install/Migrate/Upgrade utility. I did a month ago, which took lot of time and its not going to that easy as you think... tell me the versions of your designer.. I will try helping you with the steps.



[Edited by sreddy on 01-02-2001 at 04:03 PM]

[ocpdude]

I am using Designer6 (same for 805 and 816)...
when I created my repository for 805 I did the following.
--created 2 table spaces (des6, des6_ind)
--created user des6 identified by des6
default tablespace des6
-- grant connect,resource,dba to des6
-- @@chrorole.sql
-- grant des2000_owner to des6

do I have to do the same thing for 816 ???????

Hope this helps

[Edited by ocpdude on 01-02-2001 at 02:28 PM]

[sreddy]

Version of Designer on 8.05 database ?
Version of Designer on 815 database ?

Same or different ?

[sreddy]

{Sorry! I misunderstood and thought you are upgrading/migrating your designer}
Yes! Follow the same steps on 816.

1) Install 816 Binaries.
2) Create 816 database with enough room and precreated tablespace structures as its in 805 database.
3) Try importing it and see.
4) compile all objects and compare the count and status of objects on 805 and 816 database.
5)Try to login to "Repository Administration Utility" as repository owner, check for requirements tab and see it has all privileges as its on 805 and choose under repository mainenance tab, Recreate and Full reconcile option and click start. After its done try to login as a user into designer and see if your designer works.

This is procedure, if Designer Version doesn't change. If it changes, you have to go thru the install/upgrade/migrate option as I mentioned in my previous posting.

See this works.

If doesn't work give a try drop ping all objects of repoistory and import only repository owner schema, continue with step 4 and 5.

[Edited by sreddy on 01-02-2001 at 04:03 PM]