-
Apr 7th, 2014, 03:54 PM
#1
[RESOLVED] Does Oracle have a DEVELOPERS edition like MS SQL?
Ok - with MS SQL I can install "developers" edition on any machine I want - and then copy a production DB to that machine and work on it.
Does Oracle offer the same tool?
And if it does, when I copy an Oracle DB to a local machine do I have "full permissions" to the DATABASE, as I do with MS SQL??
-
Apr 7th, 2014, 04:53 PM
#2
Addicted Member
Re: Does Oracle have a DEVELOPERS edition like MS SQL?
I think you can use whatever version of their DB standard, enterprise, and I think express now? (think they have an express version) for development purposes.
http://www.oracle.com/technetwork/te...se-088383.html
Looks like you can, I didn't read through the whole thing.
-
Apr 8th, 2014, 02:30 PM
#3
Re: Does Oracle have a DEVELOPERS edition like MS SQL?
Yes. Oracle has the full edition available for download. Express editions are also available.
Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
save a blobFileStreamDataTable To Text Filemy blog
-
Apr 8th, 2014, 02:31 PM
#4
Re: Does Oracle have a DEVELOPERS edition like MS SQL?
Originally Posted by szlamany
And if it does, when I copy an Oracle DB to a local machine do I have "full permissions" to the DATABASE, as I do with MS SQL??
Can anyone answer this question? Can I access the restored DB even if I did not have permissions to it on the original production server?
-
Apr 8th, 2014, 02:37 PM
#5
Re: Does Oracle have a DEVELOPERS edition like MS SQL?
Originally Posted by szlamany
Can anyone answer this question? Can I access the restored DB even if I did not have permissions to it on the original production server?
I just spoke with my DBA and he said he does this all the time. However the operating systems have to be the same. This is based on his experience. You cannot copy a file from a Unix operating system and use that in windows.
An option to do this across operating systems is to export the database using the data pump tool and then import it in the windows environment using the same tool.
Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
save a blobFileStreamDataTable To Text Filemy blog
-
Apr 8th, 2014, 02:42 PM
#6
Re: Does Oracle have a DEVELOPERS edition like MS SQL?
The "server" that has the original DB is inhouse here - it's just that the vendor does not give us access to it directly. No SYSDBA access (I'm saying last statement wo/knowin anything about Oracle).
That server does make a backup every night - that the IT person here has access to.
My goal is to get a Dev version of Oracle installed on a new box here - will be same OS - and restore the production BACKUP to that machine.
And I need to know if I can then get full access to this restored copy. MS SQL allows this - if I am ADMIN on the new server I get full access to any DB restored - regardless of the security of the DB on the original server.
-
Apr 9th, 2014, 09:19 AM
#7
Re: Does Oracle have a DEVELOPERS edition like MS SQL?
Burleson Consulting has a blog post about this. For your specific case, you need to start at STEP 3.
Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
save a blobFileStreamDataTable To Text Filemy blog
-
Apr 9th, 2014, 09:29 AM
#8
Re: Does Oracle have a DEVELOPERS edition like MS SQL?
That blog - that step #3 - is that taking a regular backup and loading that?
-
Apr 11th, 2014, 02:51 PM
#9
Re: Does Oracle have a DEVELOPERS edition like MS SQL?
Originally Posted by szlamany
That blog - that step #3 - is that taking a regular backup and loading that?
Yes.
Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
save a blobFileStreamDataTable To Text Filemy blog
-
Apr 11th, 2014, 02:57 PM
#10
Re: Does Oracle have a DEVELOPERS edition like MS SQL?
Thank you so much - I have passed this info on to those who need to see it - and I'm marking this thread resolved!
-
Apr 11th, 2014, 03:38 PM
#11
Re: Does Oracle have a DEVELOPERS edition like MS SQL?
Originally Posted by szlamany
Thank you so much - I have passed this info on to those who need to see it - and I'm marking this thread resolved!
You're welcome. If you're stuck with an oracle related problem, Tom Kyte is an excellent resource.
Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
save a blobFileStreamDataTable To Text Filemy blog
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|