Home » RDBMS Server » Backup & Recovery » Transport tablespace with Oracle Standard Edition (W2k8)
Transport tablespace with Oracle Standard Edition [message #658932] Sun, 01 January 2017 10:07 Go to next message
gnoovy
Messages: 8
Registered: January 2017
Junior Member
Hi everybody,

i'm new at this Forum and i have a question about Transport tablespaces between Oracle 10g and 12c with the Standard Editions?
i read on Google that i can only use the Transport tablespace command within rman only with an Enterprise Edition.
So are there any other possibilities to Transport the tablespaces? Or is the only way an Schema user Export /Import?

so thanks a lot for help Smile
Re: Transport tablespace with Oracle Standard Edition [message #658933 is a reply to message #658932] Sun, 01 January 2017 10:57 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
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 #658941 is a reply to message #658933] Sun, 01 January 2017 12:02 Go to previous messageGo to next message
gnoovy
Messages: 8
Registered: January 2017
Junior Member
Hi Solomon,

thanks a lot for your help. that would be a brand new database in Oracle 12C. How can i do a data pump from Oracle 10 to 12c, especially from two tablespaces?

[Updated on: Sun, 01 January 2017 12:27]

Report message to a moderator

Re: Transport tablespace with Oracle Standard Edition [message #658945 is a reply to message #658941] Sun, 01 January 2017 13:46 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
You can't do "from two tablespaces". You export/import schemas/objects.

SY.
Re: Transport tablespace with Oracle Standard Edition [message #658946 is a reply to message #658941] Sun, 01 January 2017 14:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
gnoovy wrote on Sun, 01 January 2017 10:02
Hi Solomon,

thanks a lot for your help. that would be a brand new database in Oracle 12C. How can i do a data pump from Oracle 10 to 12c, especially from two tablespaces?
why are you fixated on tablespaces?

http://docs.oracle.com/database/121/CNCPT/logical.htm#CNCPT004

How will we know when correct solution has been posted here?
Re: Transport tablespace with Oracle Standard Edition [message #658948 is a reply to message #658946] Sun, 01 January 2017 16:20 Go to previous messageGo to next message
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 #658949 is a reply to message #658948] Sun, 01 January 2017 17:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
AL32UTF8 is a superset of WE8MSWIN1252 so no problem will occur.
Re: Transport tablespace with Oracle Standard Edition [message #659070 is a reply to message #658949] Thu, 05 January 2017 09:05 Go to previous messageGo to next message
gnoovy
Messages: 8
Registered: January 2017
Junior Member
ok, perfect so i can do a schema-user Export/ipmort. Only for interest. Is it possible to do a rman full database backup under Oracle 10 and restore this Backup under Oracle12c?
Re: Transport tablespace with Oracle Standard Edition [message #659071 is a reply to message #659070] Thu, 05 January 2017 09:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
gnoovy wrote on Thu, 05 January 2017 07:05
ok, perfect so i can do a schema-user Export/ipmort. Only for interest. Is it possible to do a rman full database backup under Oracle 10 and restore this Backup under Oracle12c?
When you do RMAN restore, you get a "cloned" copy of the source database; nothing more & nothing less.
If you do RMAN backup of V10, then the restored copy will also be V10.
You then could upgrade it to V12 as a separate operation.
Re: Transport tablespace with Oracle Standard Edition [message #659073 is a reply to message #659071] Thu, 05 January 2017 10:07 Go to previous messageGo to next message
gnoovy
Messages: 8
Registered: January 2017
Junior Member
ah ok and in this case the same Charakter set Wink 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 Go to previous messageGo to next message
John Watson
Messages: 8922
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 #659076 is a reply to message #659074] Thu, 05 January 2017 11:30 Go to previous messageGo to next message
gnoovy
Messages: 8
Registered: January 2017
Junior Member
Hi John,

i tried the Migration Assistant but it means that my Oracle 10 is too old for a connection Sad 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...
Re: Transport tablespace with Oracle Standard Edition [message #659078 is a reply to message #659073] Thu, 05 January 2017 11:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
gnoovy wrote on Thu, 05 January 2017 17:07
...
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;
...
This is plain STUPID!
What do you think INTERNAL_USE mean?

Re: Transport tablespace with Oracle Standard Edition [message #659081 is a reply to message #659078] Thu, 05 January 2017 14:25 Go to previous messageGo to next message
gnoovy
Messages: 8
Registered: January 2017
Junior Member
in this case i must say i'm new in Oracle and this two commands where found during Google search for my test environment.
But now i know it better and do the schema user export/import.

The last question for this szenario. Above we said an import between this charakter sets are no problem. But wenn i do an export the exp programm said:

Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)


is this also no problem or should i do some more things in this case? For exp and imp i use the following commands:

exp system/<password> owner=<Schemauser> file=<name>.dmp log=<name>.log consistent=y
imp system/<password> fromuser=<Schemauser> touser=<Same Schemauser> file=<name>.dmp log=<name>.log
Re: Transport tablespace with Oracle Standard Edition [message #659082 is a reply to message #659081] Thu, 05 January 2017 14:33 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Of course it is a problem. You could be losing a whole load of characters.

First, stop using the old exp/imp utilities. Data Pump will do a better job.
Re: Transport tablespace with Oracle Standard Edition [message #659083 is a reply to message #659081] Thu, 05 January 2017 14:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
in this case i must say i'm new in Oracle and this two commands where found during Google search for my test environment.
It is not a question to be or nor to be new just to be a little bit smart and not blindly apply something found using Google search.
When something is named INTERNAL_USE you should think that this is not something to use before either Oracle itself tell you to do so or being an expert and knowing what that's implies.

Re: Transport tablespace with Oracle Standard Edition [message #659084 is a reply to message #659083] Thu, 05 January 2017 15:11 Go to previous message
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?
Previous Topic: rman back up advice/question
Next Topic: Restoring Unencrypted Backups to a TDE Encrypted Database?
Goto Forum:
  


Current Time: Thu Mar 28 11:24:55 CDT 2024