dbTalk Databases Forums  

oracle 9i: errors by clone a DB by a script

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss oracle 9i: errors by clone a DB by a script in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #41  
Old   
Andreas Mosmann
 
Posts: n/a

Default Re: oracle 9i: errors by clone a DB by a script - 04-29-2008 , 03:38 AM






sybrandb (AT) hccnet (DOT) nl schrieb am 28.04.2008 in
<vkrb145jmii034ah3ek5jqp2vh5v795cco (AT) 4ax (DOT) com>:

Quote:
On Mon, 28 Apr 2008 13:09:17 +0200, Andreas Mosmann
mosmann (AT) expires-30-04-2008 (DOT) news-group.org> wrote:

Maybe because there are more Oracle docs I can read all my life?
And, by the way, many oracle tools are built by the flintstones (f.e.
SQL plus *), there are and must be better ways to do the work.

You do not know what you are talking about.
Doesn't I?
Sql*plus is the successor of UFI.
UFI is the acronym for U(ser)F(riendly)I(nterface).
A joke, isn't it?

Quote:
If you can't work with sql*plus, I suggest you stick to Mickeysoft
products.
Why should I?
1.) I can work with sql*plus. And I also can undress me with a knife.
But both seems to me not really useful if there are better ways (and
there are)
2.) I do not have the choice of RDBMS
3.) Only because I think that some tools are not that useful as possible
I do not have a problem with oracle at all

Nevertheless
Thank you
Andreas Mosmann

--
wenn email, dann AndreasMosmann <bei> web <punkt> de


Reply With Quote
  #42  
Old   
Andreas Mosmann
 
Posts: n/a

Default Re: oracle 9i: errors by clone a DB by a script - 04-29-2008 , 03:53 AM






sybrandb (AT) hccnet (DOT) nl schrieb am 29.04.2008 in
<86nd14tano88itspmv6fbobv49g6fpcf5q (AT) 4ax (DOT) com>:

Quote:
On Tue, 29 Apr 2008 10:00:44 +0200, Andreas Mosmann
mosmann (AT) expires-30-04-2008 (DOT) news-group.org> wrote:

It so happens, databases are *designed*, and one shouldn't have one
database per app.
Why? Please explain your view!
In general I have a customer that wants a solution for his problem.
There are some cases the solution is to develop a software using a
database, f.e. oracle. So I have to develop 1 Application and 1
Database.
Of course, if there already exists a db and the new problem/solution is
related to this data it is possible/useful to integrate the new
data/structure into the existing db and you have more than 1 app to only
one db.
It is also possible that there is an application collectiong data from
more than 1 source, maybe databases/web services or anything else. So
you have 1 application corresponding with more databases.

Quote:
What you describe are the Mickey Mouse procedures so typical for the
toy products provided by Mickeysoft.
Ok, but what is wrong to spend time with useful and paid work instead of
doing the same boring stuff again and again? And please do not tell me
that it is impossible to do fulfil my "wish". Maybe it seems to be
useless for you, but impossible?

Quote:
Grow up, accept Oracle is much more mature than Mickeysoft will ever
produce, or stick to Mickeysoft.
I did not criticised the way oracle is working inside but the delivered
tools. Do you really want to tell me that I have to use stone age tools
to work with a "mature" rdbms? If not, am I a wimp?

Andreas Mosmann

--
wenn email, dann AndreasMosmann <bei> web <punkt> de


Reply With Quote
  #43  
Old   
Andreas Mosmann
 
Posts: n/a

Default Re: oracle 9i: errors by clone a DB by a script - 04-29-2008 , 03:53 AM



sybrandb (AT) hccnet (DOT) nl schrieb am 29.04.2008 in
<86nd14tano88itspmv6fbobv49g6fpcf5q (AT) 4ax (DOT) com>:

Quote:
On Tue, 29 Apr 2008 10:00:44 +0200, Andreas Mosmann
mosmann (AT) expires-30-04-2008 (DOT) news-group.org> wrote:

It so happens, databases are *designed*, and one shouldn't have one
database per app.
Why? Please explain your view!
In general I have a customer that wants a solution for his problem.
There are some cases the solution is to develop a software using a
database, f.e. oracle. So I have to develop 1 Application and 1
Database.
Of course, if there already exists a db and the new problem/solution is
related to this data it is possible/useful to integrate the new
data/structure into the existing db and you have more than 1 app to only
one db.
It is also possible that there is an application collectiong data from
more than 1 source, maybe databases/web services or anything else. So
you have 1 application corresponding with more databases.

Quote:
What you describe are the Mickey Mouse procedures so typical for the
toy products provided by Mickeysoft.
Ok, but what is wrong to spend time with useful and paid work instead of
doing the same boring stuff again and again? And please do not tell me
that it is impossible to do fulfil my "wish". Maybe it seems to be
useless for you, but impossible?

Quote:
Grow up, accept Oracle is much more mature than Mickeysoft will ever
produce, or stick to Mickeysoft.
I did not criticised the way oracle is working inside but the delivered
tools. Do you really want to tell me that I have to use stone age tools
to work with a "mature" rdbms? If not, am I a wimp?

Andreas Mosmann

--
wenn email, dann AndreasMosmann <bei> web <punkt> de


Reply With Quote
  #44  
Old   
Andreas Mosmann
 
Posts: n/a

Default Re: oracle 9i: errors by clone a DB by a script - 04-29-2008 , 03:53 AM



sybrandb (AT) hccnet (DOT) nl schrieb am 29.04.2008 in
<86nd14tano88itspmv6fbobv49g6fpcf5q (AT) 4ax (DOT) com>:

Quote:
On Tue, 29 Apr 2008 10:00:44 +0200, Andreas Mosmann
mosmann (AT) expires-30-04-2008 (DOT) news-group.org> wrote:

It so happens, databases are *designed*, and one shouldn't have one
database per app.
Why? Please explain your view!
In general I have a customer that wants a solution for his problem.
There are some cases the solution is to develop a software using a
database, f.e. oracle. So I have to develop 1 Application and 1
Database.
Of course, if there already exists a db and the new problem/solution is
related to this data it is possible/useful to integrate the new
data/structure into the existing db and you have more than 1 app to only
one db.
It is also possible that there is an application collectiong data from
more than 1 source, maybe databases/web services or anything else. So
you have 1 application corresponding with more databases.

Quote:
What you describe are the Mickey Mouse procedures so typical for the
toy products provided by Mickeysoft.
Ok, but what is wrong to spend time with useful and paid work instead of
doing the same boring stuff again and again? And please do not tell me
that it is impossible to do fulfil my "wish". Maybe it seems to be
useless for you, but impossible?

Quote:
Grow up, accept Oracle is much more mature than Mickeysoft will ever
produce, or stick to Mickeysoft.
I did not criticised the way oracle is working inside but the delivered
tools. Do you really want to tell me that I have to use stone age tools
to work with a "mature" rdbms? If not, am I a wimp?

Andreas Mosmann

--
wenn email, dann AndreasMosmann <bei> web <punkt> de


Reply With Quote
  #45  
Old   
Andreas Mosmann
 
Posts: n/a

Default Re: oracle 9i: errors by clone a DB by a script - 04-29-2008 , 03:53 AM



sybrandb (AT) hccnet (DOT) nl schrieb am 29.04.2008 in
<86nd14tano88itspmv6fbobv49g6fpcf5q (AT) 4ax (DOT) com>:

Quote:
On Tue, 29 Apr 2008 10:00:44 +0200, Andreas Mosmann
mosmann (AT) expires-30-04-2008 (DOT) news-group.org> wrote:

It so happens, databases are *designed*, and one shouldn't have one
database per app.
Why? Please explain your view!
In general I have a customer that wants a solution for his problem.
There are some cases the solution is to develop a software using a
database, f.e. oracle. So I have to develop 1 Application and 1
Database.
Of course, if there already exists a db and the new problem/solution is
related to this data it is possible/useful to integrate the new
data/structure into the existing db and you have more than 1 app to only
one db.
It is also possible that there is an application collectiong data from
more than 1 source, maybe databases/web services or anything else. So
you have 1 application corresponding with more databases.

Quote:
What you describe are the Mickey Mouse procedures so typical for the
toy products provided by Mickeysoft.
Ok, but what is wrong to spend time with useful and paid work instead of
doing the same boring stuff again and again? And please do not tell me
that it is impossible to do fulfil my "wish". Maybe it seems to be
useless for you, but impossible?

Quote:
Grow up, accept Oracle is much more mature than Mickeysoft will ever
produce, or stick to Mickeysoft.
I did not criticised the way oracle is working inside but the delivered
tools. Do you really want to tell me that I have to use stone age tools
to work with a "mature" rdbms? If not, am I a wimp?

Andreas Mosmann

--
wenn email, dann AndreasMosmann <bei> web <punkt> de


Reply With Quote
  #46  
Old   
joel garry
 
Posts: n/a

Default Re: oracle 9i: errors by clone a DB by a script - 04-29-2008 , 12:29 PM



On Apr 29, 1:00*am, Andreas Mosmann <mosm... (AT) expires-30-04-2008 (DOT) news-
group.org> wrote:

Quote:
I come along with oracle but in my opinion it must be allowed to wish
things that still doesn't exist. And I am sure that I am not the only
one with these wishes. Maybe there will be a version where the
enterprise manager has a button "Clone a DB" and if you start it will
ask you the following questions:
- server?
- sys/system - passwords?
- shrink db?
- delete existing db?
and all the other information concerning operation system, installed
oracle version/patchlevel and whatever it finds out itself.
Dream a little dream ...
I see some of that on EM for 10.2.0.3 under Clone Database... I seem
to recall the patch level stuff is a new feature, I for one tend to
avoid new features.

But really, aren't these DBA tasks?

Quote:
1.) I can work with sql*plus. And I also can undress me with a knife.
But both seems to me not really useful if there are better ways (and
there are)
Depends on the requirements. Undressing with knives sounds pretty
exciting for some requirements.

jg
--
@home.com
I thought the part of The Illustrated Man movie where they all had the
same dream, very disturbing.


Reply With Quote
  #47  
Old   
joel garry
 
Posts: n/a

Default Re: oracle 9i: errors by clone a DB by a script - 04-29-2008 , 12:29 PM



On Apr 29, 1:00*am, Andreas Mosmann <mosm... (AT) expires-30-04-2008 (DOT) news-
group.org> wrote:

Quote:
I come along with oracle but in my opinion it must be allowed to wish
things that still doesn't exist. And I am sure that I am not the only
one with these wishes. Maybe there will be a version where the
enterprise manager has a button "Clone a DB" and if you start it will
ask you the following questions:
- server?
- sys/system - passwords?
- shrink db?
- delete existing db?
and all the other information concerning operation system, installed
oracle version/patchlevel and whatever it finds out itself.
Dream a little dream ...
I see some of that on EM for 10.2.0.3 under Clone Database... I seem
to recall the patch level stuff is a new feature, I for one tend to
avoid new features.

But really, aren't these DBA tasks?

Quote:
1.) I can work with sql*plus. And I also can undress me with a knife.
But both seems to me not really useful if there are better ways (and
there are)
Depends on the requirements. Undressing with knives sounds pretty
exciting for some requirements.

jg
--
@home.com
I thought the part of The Illustrated Man movie where they all had the
same dream, very disturbing.


Reply With Quote
  #48  
Old   
joel garry
 
Posts: n/a

Default Re: oracle 9i: errors by clone a DB by a script - 04-29-2008 , 12:29 PM



On Apr 29, 1:00*am, Andreas Mosmann <mosm... (AT) expires-30-04-2008 (DOT) news-
group.org> wrote:

Quote:
I come along with oracle but in my opinion it must be allowed to wish
things that still doesn't exist. And I am sure that I am not the only
one with these wishes. Maybe there will be a version where the
enterprise manager has a button "Clone a DB" and if you start it will
ask you the following questions:
- server?
- sys/system - passwords?
- shrink db?
- delete existing db?
and all the other information concerning operation system, installed
oracle version/patchlevel and whatever it finds out itself.
Dream a little dream ...
I see some of that on EM for 10.2.0.3 under Clone Database... I seem
to recall the patch level stuff is a new feature, I for one tend to
avoid new features.

But really, aren't these DBA tasks?

Quote:
1.) I can work with sql*plus. And I also can undress me with a knife.
But both seems to me not really useful if there are better ways (and
there are)
Depends on the requirements. Undressing with knives sounds pretty
exciting for some requirements.

jg
--
@home.com
I thought the part of The Illustrated Man movie where they all had the
same dream, very disturbing.


Reply With Quote
  #49  
Old   
joel garry
 
Posts: n/a

Default Re: oracle 9i: errors by clone a DB by a script - 04-29-2008 , 12:29 PM



On Apr 29, 1:00*am, Andreas Mosmann <mosm... (AT) expires-30-04-2008 (DOT) news-
group.org> wrote:

Quote:
I come along with oracle but in my opinion it must be allowed to wish
things that still doesn't exist. And I am sure that I am not the only
one with these wishes. Maybe there will be a version where the
enterprise manager has a button "Clone a DB" and if you start it will
ask you the following questions:
- server?
- sys/system - passwords?
- shrink db?
- delete existing db?
and all the other information concerning operation system, installed
oracle version/patchlevel and whatever it finds out itself.
Dream a little dream ...
I see some of that on EM for 10.2.0.3 under Clone Database... I seem
to recall the patch level stuff is a new feature, I for one tend to
avoid new features.

But really, aren't these DBA tasks?

Quote:
1.) I can work with sql*plus. And I also can undress me with a knife.
But both seems to me not really useful if there are better ways (and
there are)
Depends on the requirements. Undressing with knives sounds pretty
exciting for some requirements.

jg
--
@home.com
I thought the part of The Illustrated Man movie where they all had the
same dream, very disturbing.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.