I've just tried the default, I did not specify LM. Oracle still made it DM.Quote:
Actually, the default installation now creates it as local.
What you probably meant is that the DB Assistant makes it LM.
Printable View
I've just tried the default, I did not specify LM. Oracle still made it DM.Quote:
Actually, the default installation now creates it as local.
What you probably meant is that the DB Assistant makes it LM.
Julian: When you install the software you get the option of which type of default installation you would like. If you pick the general purpose default installation the SYSTEM tablespace is LM.
Sorry, if I confused you. I did not mean to imply that the default action of the CREATE DATABASE or CREATE TABLESPACE commands resulted in locally managed tablespaces.
Cheers
I take always CUSTOM.Quote:
Originally posted by TimHall
Julian: When you install the software you get the option of which type of default installation you would like. If you pick the general purpose default installation the SYSTEM tablespace is LM.
You must give EXTENT MANAGEMENT LOCAL in the CREATE DATABASE command in order to get the SYSTEM TS as LM.Quote:
Sorry, if I confused you. I did not mean to imply that the default action of the CREATE DATABASE or CREATE TABLESPACE commands resulted in locally managed tablespaces.
Cheers
2.8 gigs my ass. I took a before and after sizing of my hardrive and Oracle 9i R2 took about 4.8 gigs with the "typical" database. Next stop, resizing. Also set aside about 2 1/2 hours to be safe. I didn't have any problems (this one time).
So, lets see what actually works.
Tim / Julian
I have one doubt. How Oracle benefits by giving free downloads for there new products. The software we download is the same they supply to the customer after a legal purchase. For how many days we can use the software downloaded.
Oracle let you download the software free so you get a taste for the product. They hope you'll have a go and beg your company to buy it. There is no time limit and you are given a free single limited development/trial license.
Using Oracle without support can be a nightmare. You need access to Metalink to get any support and patches. Since you can only access metalink if you have a support agreement, and you can only get a support agreement if you have bought the software Oracle are pretty happy you're going to buy it.
Most companies go mad if you even mention unlicensed software so corporate use isn't the problem.
I'd be interested to know how many companies use Oracle illegally.
Cheers