For internal Development purposes, Oracle Designer (as with all Oracle products including Portal, Collab Suite, RDBMS, AS, etc.) is free.
If you use it to work on products directly for external sources (i.e., a customer's ER diagram) then it costs.
Hope this helps.
Happy New Year!
Jim
Actually, SQL*Plus *DOES* support command history recall using the arrow keys, HOWEVER it only works in Windoze (as far as I know).
If anyone knows of a way to get it working in Linux/Unix, I would be thrilled to know how it's done so that I may pass it on to others.
Jim Kotan
Omaha, Nebraska, USA
Does anyone know how to take designs (physical, logical, or conceptual) from Sybase PowerDesigner (PD) 8.0 and bring them in to Oracle Designer (OD) 10g?
I am new to OD and, while I am studying the 900+ page book, I would like to be able to move our designs out of PD and into OD soon so I can...
One thing I just thought of: Go to http://wwww.DBTune.com and see if they do it there. I remember something about them offering free access but don't remember exactly what it was.
Jim
Adawn,
http://www.groups.yahoo.com/oca_dev/files is an invalid link. They apparently removed the "files" directory.
I have almost 5 years as a DBA & am about to start my OCP certification process so would love to have any study materials possible. Once that is done, my company says they will...
I don't know of any, however you CAN, for Development purposes, download Oracle Personal, create your own DB & test things.
Here are the results of your queries:
select translate('123grg','3','6') from dual;
TRANSL
------
126grg
SQL> create table Example(field varchar2(100));
Table created...
alter database datafile 'D:\ORACLE\ORADATA\OEMREP\CWMLITE01.DBF' autoextend on maxsize 100m;
The optional "maxsize 100m" part will set a max datafile size of 100 megs. Be sure that if you set autoextend on you have enough space for all datafiles in that filesystem to expand to that size at once...
Rob,
Please see my post of 7/19, "Sybase PowerDesigner 10 vs Oracle Designer 9i". Perhaps you can shed light on why you would migrate away from OD to PD?
Jim
All,
Although I have 5 years experience as an Oracle DBA, I am new to Data Modelling, which my new job requires that I do. We currently use PowerDesigner 8.0 and, since Sybase is ending its life, we need to either upgrade or move to another product.
Since we are an Oracle Partner, we (like...
All,
Although I have 5 years experience as an Oracle DBA, I am new to Data Modelling, which my new job requires that I do. We currently use PowerDesigner 8.0 and, since Sybase is ending its life, we need to either upgrade or move to another product.
Since we are an Oracle Partner, we (like...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.