|
|
| Re: Transport tablespace with Oracle Standard Edition [message #658933 is a reply to message #658932] |
Sun, 01 January 2017 10:57   |
Solomon Yakobson
Messages: 3303
Registered: January 2010
Location: Connecticut, USA
|
Senior Member |
|
|
Transportable tablespaces are not available in SE. Do you want to transport tablespaces to existing database with data or brand new database? If latter, clone existing 10G database and upgrade it to 12C. But personally, for versions upgrades I prefer creating brand new shell database and using data pump to copy the data.
SY.
|
|
|
|
|
|
|
|
|
|
| Re: Transport tablespace with Oracle Standard Edition [message #658948 is a reply to message #658946] |
Sun, 01 January 2017 16:20 |
 |
gnoovy
Messages: 8
Registered: January 2017
|
Junior Member |
|
|
Hi everybody,
the Job i have to do is following:
we have a document Management System which can connect to Microsoft SQL Server, Oracle, postgre and so on. one of our customer has an old Version of this program and we want to migrate this Version to the newest Version.
so i have an old Environment with w2k8, our old dms System and Oracle 10 with the character set WE8MSWIN1252. The new Environment is w2k12 r2, brand new Version of our dms System and Oracle 12c with character set AL32UTF8.
our dms System generates two schema-users.
first of all i did an Schema user Export / Import. When i do an Import i get the message: "import-Server uses character set AL32UTF8 (possible charset conversion)". So i don't know if i have any Problems or not.
a first check with the SQL developer to look at the tables seems to be ok, but i don't know exactly. So a colleague said i could try to Transport the tablespaces from the old Oracle10g, instead of create new tablespaces with the same Name in the new Environment with an Schema Import.
So how can i find out if my Import has worked correctly? So wenn a Schema user Export / Import is enough i don't force a tablespace Transport.
I hope you can help me.
[Updated on: Sun, 01 January 2017 16:25] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Transport tablespace with Oracle Standard Edition [message #659073 is a reply to message #659071] |
Thu, 05 January 2017 10:07 |
|
gnoovy
Messages: 8
Registered: January 2017
|
Junior Member |
|
|
ah ok and in this case the same Charakter set  in your post above you wrote that there will be no Problems with the different charakter set. I've done a test bevore i opened this thread with Oracle 10 and Oracle12c with the same Charakter set WE8MSWIN1252 and did the Schema user Export / Import. Next i changed the Charakter set in Oracle12c to AL32UTF8 with the two commands:
alter database character set AL32UTF8;
alter database character set internal_use AL32UTF8;
after that i saw an table entry changed with the letter รถ in an rectangle.
I don't know if i've done an other mistake or that we could say Schema user Export / Import from WE8MSWIN1252 to AL32UTF8 is no Problem, but the Change of an Charakter set with the alter commands could be a Problem?
[Updated on: Thu, 05 January 2017 10:08] Report message to a moderator |
|
|
|
| Re: Transport tablespace with Oracle Standard Edition [message #659074 is a reply to message #659073] |
Thu, 05 January 2017 10:32 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
That technique for changing characterset is unsupported and may destroy your database. Release 12.x comes with the Database Migration Assistant For Unicode (the DMU), and that is what you should use.
Before attempting the export/import you should have used the DMU to scan the source datbase for potential problems.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Transport tablespace with Oracle Standard Edition [message #659084 is a reply to message #659083] |
Thu, 05 January 2017 15:11 |
|
gnoovy
Messages: 8
Registered: January 2017
|
Junior Member |
|
|
@John
thanks for the tip. So i instruced my self in the syntax and it seems nearly the same. For the export it doesn't rant me for the charakter set like the exp command did it.
So is it important for the expdp and later impdp to do something, in my case with the two charakter sets WE8MSWIN1252 on Oracle 10 and AL32UTF8 on Oracle12c?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
Does it makes any sense to do the Schema user Import and scan the own database? I don't think so isn't it? Because this database is already Unicode...