migration from windows-mssql to linux-oracle. [message #572309] |
Mon, 10 December 2012 06:23 |
|
washide
Messages: 7 Registered: December 2012 Location: Transormator
|
Junior Member |
|
|
Env:
destination-linux:2.6.18-308.13.1.el5,oracle:10.2.0.1 ,source:windows.mssql v:8.00760
I was try migrate one sample database from mssql "Pubs" using Oracle SQL Developer Tool.
After migraton i've got prefixes in tables like MD_<table_name> but i can not see tables from Pubs only a lot of tables like :
MD_COLUMNS
MD_GROUPS
etc...
How to solve it ?
--
ANTY GMO
|
|
|
|
|
|
|
|
Re: migration from windows-mssql to linux-oracle. [message #573050 is a reply to message #572637] |
Thu, 20 December 2012 04:20 |
|
washide
Messages: 7 Registered: December 2012 Location: Transormator
|
Junior Member |
|
|
grant dba to mika it solve my problem.
SELECT grantee, granted_role, default_role
FROM dba_role_privs
WHERE granted_role IN ('DBA', 'EXP_FULL_DATABASE', 'IMP_FULL_DATABASE')
ORDER BY 1,2; 2 3 4
GRANTEE GRANTED_ROLE DEF
------------------------------ ------------------------------ ---
MIKA DBA YES
MIKA EXP_FULL_DATABASE YES
MIKA IMP_FULL_DATABASE YES
[Updated on: Thu, 20 December 2012 04:21] Report message to a moderator
|
|
|
|
|
|
Re: migration from windows-mssql to linux-oracle. [message #573132 is a reply to message #573122] |
Fri, 21 December 2012 05:19 |
|
washide
Messages: 7 Registered: December 2012 Location: Transormator
|
Junior Member |
|
|
I think no , i grant roles acording to manual\help cener from Oracle SQL Developer Tool:
"For example, you can create a user called migrations with the minimum required privileges required to migrate a database by using the following commands:
CREATE USER migrations IDENTIFIED BY password
DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;
GRANT CONNECT, RESOURCE, CREATE VIEW, CREATE PUBLIC SYNONYM TO
migrations WITH ADMIN OPTION;
GRANT ALTER ANY ROLE, ALTER ANY SEQUENCE, ALTER ANY TABLE, ALTER TABLESPACE,
ALTER ANY TRIGGER, COMMENT ANY TABLE, CREATE ANY SEQUENCE, CREATE ANY TABLE,
CREATE ANY TRIGGER, CREATE ROLE, CREATE TABLESPACE, CREATE USER, DROP ANY
SEQUENCE, DROP ANY TABLE, DROP ANY TRIGGER, DROP TABLESPACE, DROP USER, DROP ANY
ROLE, GRANT ANY ROLE, INSERT ANY TABLE, SELECT ANY TABLE, UPDATE ANY TABLE TO
migrations;
"
On my site migrations user is mika.
Aditionally i add exp_full_database and imp_full_database.
--
Best Regards
washide
|
|
|