How to change Table Object owner without export/import
Date: Wed, 21 Jul 1999 18:09:34 -0500
From: jcocke@csc.com
Subject: Change owner with exp/imp?
Does anyone know of way to change a table object's schema(owner) without
doing an export/import?
Thanks in advance...john
Date: Wed, 21 Jul 1999 22:04:34 -0400
From: Matt Surico surico@users.buoy.com
Subject: Re: Change owner with exp/imp?
You could do the following, though it's kind of convoluted and
exp/imp would be much simpler:
0. Schema A is the old one, B is the new one, table1 is the table
1. As user A: GRANT SELECT ON table1 to B;
2. As user B: CREATE TABLE1 AS SELECT * FROM A.TABLE1;
3. As DBA, query dba_indexes to see if any indexes on A.TABLE1 exist;
write script to rebuild in schema B using dba_ind_columns.
You still will need to ensure all the proper grants that
existed on A.TABLE1 will be made on B.TABLE1, if necessary, and also
that if you need any stored procs, functions, views, that were based
on A.TABLE1 will be recreated for B.TABLE1 (using the appropriate
dba_% views).
See why exp/imp makes more sense? Oracle takes care of all
these things for you with that utility.
Of course, if all you want to do is reproduce the data without
worrying about the other objects, then steps 0-2 should suffice.
I am unaware of any Oracle-supplied tool that does a simple
schema-change, akin to a chown in Unix.
HTH,
Matt
Date: Thu, 22 Jul 1999 07:49:49 -0300
From: Melanie Perry Melanie.Perry@moncton.org
Subject: RE: Change owner with exp/imp?
Hi John
Yes. You can use the following command :
Create table newowner.table_name as (select * from
oldowner.tablename);
You'll have to be careful who you log in as because the new table will be
created into that tablespace. Also, you will have to apply all the grants
to the new table.
Exp \ Imp would be much easier.......you can specify a specifc table using
this utility.
Melanie Perry
SSA \ DBA
The City of Moncton
Moncton, NB
Date: Thu, 22 Jul 1999 09:05:18 -0400
From: Venkat_Chandra@ncci.com
Subject: Re: Change owner with exp/imp?
There is are couple of short comings with this method of using
Create TableA as Select * from TableB
1. This will not copy the constraints! You may need to separately extract
the
constraints and then recreate them in TableB.
2. If TableA is very large you may run into rollback segment problems. There
fore you may need to create or use (if you have one) large rollback segment
and
make use of this segment using SET TRANSACTION USING ROLLBACK SEGMENT
Hope this helps
Venkat Chandra
ORACLE CERTIFIED DBA
Date: Thu, 22 Jul 1999 18:12:16 +0400
From: mzaveri@eppco.co.ae
Subject: Re: Change owner with exp/imp?
In that case sqlplus->copy command can also be used, with say copycommit of
10000 etc.
Having one instance for each SOB
Date: Thu, 29 Jul 1999 20:35:40 PDT
From: "Peng Hu" peng_hu@hotmail.com
Subject: Sets of Books become a number of instances
Dear gurus,
To minimise the negative impact on each other, the head office decided to
separate one Oracle Financials instance with 7 sets of books into 7
instances on one or more machines. In this way, all the child comapnies will
be only responsible for their own Oracle Financials systems and if one is
down, the others are not affected (we have big problems on this issue from
time to time).
The initial proposals for doing this are:
1. duplicate them so that we have 7 identical systems for the start
and remove/purge redundant data for each system.
Advantages: low risk
Disadvantages: waste disk space
contents are not totally clean
may not be entirely technically feasible
2. use Financials exp/imp/loading utility to grep a set of books and
put into an instance at a time and repeat the process several
times for the rest instances.
Advantages: clean and fit systems
Disadvantages: longer process
manual involvement
risk of missing/incomplete data
Can someone out there enlighten us as whether there are better ways to do
this, or if use one of the above what are the areas we need to pay special
attentions?
Thank you in advance.
Best regards.
Peng Hu
Principal DBA
Origineer Australia
Tel +61 2 9410 1668
+61 416 102 668
Max session exceeded
From: Rudy Wahab [SMTP:rudy@fcm.ed.fujitsu.co.jp]
Sent: Monday, August 02, 1999 7:45 AM
Subject: max session exceeded
Hi alls,
I'm getting this error message on my database log file
ORA-00604: error occurred at recursive SQL level 1
ORA-00018: maximum number of sessions exceeded
According to the manual, I should increase the session parameters
in init.ora file to solve this matter. Problem is, I couldn't find any
line saying session on the init.ora. Can someone tell me which line
should
I change in init.ora or how the parameter sound like to solve this
matter.
Any help is appreciated. Thanks..
regards,
On Mon, 2 Aug 1999, Aguirre, Francisco (CCL) wrote:
Hi Rudy,
I hope this note help you to clarify your question. So, the parameter
sessions depends directly of the processes assigned. I got the note from
Oracle Support Metalink web site. You can also consult the explanation to
this sessions parameter in the Oracle Server Administration and
Configuration Guide.
Good Luck,
Francisco R. Aguirre
Parameter: SESSIONS
~~~~~~~~~~~~~~~~~~~
Parameter type: integer
Parameter class: static
Default value: derived (1.1 * Parameter:PROCESSES + 5)
Related:
Description:
~~~~~~~~~~~~
The total number of user and system sessions. The default number is
greater than PROCESSES to allow for recursive sessions.
The default values of ENQUEUE_RESOURCES and TRANSACTIONS are derived from
SESSIONS. If you alter the value of SESSIONS, you might want to adjust
the
values of ENQUEUE_RESOURCES and TRANSACTIONS.
With the multi-threaded server, you should adjust the value of SESSIONS
to
approximately 1.1 * (total number of connections).
Date: Mon, 2 Aug 1999 22:43:01 +0800 (SGT)
From: Rudy Wahab rudy@fcm.ed.fujitsu.co.jp
To: "Aguirre, Francisco (CCL)" FAguirre@carnival.com
Subject: RE: max session exceeded
Hi Francisco,
I'm sorry that I still didn't get it. I'm still not sure where on
init.ora file can I increase this value?? Or this session value is set in
otehr place...
p/s: my db is 7.3.3 and running on sun solaris 2.5.1 machine
thanks again
regards,
Date: Mon, 2 Aug 1999 09:13:33 -0700
From: Karen Blackwell KBlackwell@rockshox.com
Subject: RE: max session exceeded
Hi Rudy ---
I had a similar problem very early in our "live" activity. I simply added a
line to my init.ora file in the following format: sessions = # (where # is
the number of sessions).
I am on 10.7NCA, rdbms 7.3.3.6 on solaris 2.6
HTH
Karen Blackwell
DBA/System Administrator
RockShox, Inc.
408.570-4912 phone
408.435.7468 fax
Date: Mon, 2 Aug 1999 18:44:05 -0500
From: "Hostetler, Don" Don.Hostetler@impacgroup.com
Subject: RE: max session exceeded
In your oracle home directory (ex: /u01/oracle/product/804/dbs/initsid
name.ora) alter the init file and add the following PROCESSES=200. You may
wish to use a smaller number than 200 based on your configuration. To find
your SID name type "ps -ef | grep pmon" at the UNIX prompt, the system will
respond with ora_pmon_sid name, hence you have your sid name.
Regards,
Don Hostetler
Tablespace for GL
Date: Wed, 4 Aug 1999 12:40:04 -0300
From: Jeff Preston Jeff.Preston@moncton.org
Subject: GL Tablespaces
We are currently having some peformance problems with some of our GL tables.
We only have one tablespace for our GL module, should we have a separate
temp GL tablespace,
would this improve performance?
Date: Wed, 4 Aug 1999 23:35:59 +0100
From: "Jonathan Stuart" jdstuart@globalnet.co.uk
Subject: Re: GL Tablespaces
Jeff,
When you say you have only one tablespace for GL I assume you mean you have
all GL tables in one tablespace and GL indexes in another but no further
separation beyond that? If not, then the first job is to separate your
tables and indexes into separate tablespaces. Next, make sure these
tablespaces are separate from each other and other high activity data files
in terms of disk I/O and controllers. This can be done by either keeping
data files on separate filesystems, smart disk striping or a mixture of the
two.
Next check where your interim GL tables and indexes are being created by
looking at the Storage Parameters form in GL. By default these segments will
be created in your GL tablespaces, however it is good practice, for reasons
of performance and administration, to keep these segments in their own
tablespaces. When locating the data files for these tablespaces again make
sure you keep these separate from the GL data files and other high activity
files. If your volumes are high you will also want to adjust the segment
sizes specified in the Storage Parameters form.
Beyond this you may want to go further and move significant GL segments,
E.G. GL_INTERFACE, GL_JE_LINES, into their own tablespaces, but you should
be sure that this will help before doing so.
Other areas you should definitely look at to get the best out of GL include
the settings of parameters in the Concurrent Program Controls form in GL and
custom indexes. Because every chart of accounts is different the latter
point is vital for getting good performance and custom indexes should be
built which take into account which segments you use.
I hope this helps you.
Regards,
Jonathan.
Date: Wed, 4 Aug 1999 19:17:00 -0400
From: "Ribeiro, Alan" aribeiro@deloitte.ca
Subject: RE: GL Tablespaces
Jeff,
It is a good idea to move the tables that are created on the fly to a
seperate tablespace. It is not supported nor do I recommend moving any
other permanent table to another tablespace.
Alan Ribeiro
Senior Consultant
Technology Infrastructure Group
Deloitte Consulting
Toronto, Canada
aribeiro@deloitte.ca
Date: Thu, 5 Aug 1999 09:08:06 -0300
From: Jeff Preston Jeff.Preston@moncton.org
Subject: RE: GL Tablespaces
Thanks Jonathan, and Alan for all the good info, we've been looking at
creating a seperate tablespace for GL indexes and I
like the idea about a separate tablespace for GL_JE_LINES, and GL_INTERFACES
But to be more specific with my original question, our GL schema has only
one tablespace,
the default tablespace is GLTS, and the temp tablespace is GLTS, shouldn't
the temp tablespace be it's
own seperate tablespace, I was thinking that creating a seperate temporary
tablespace just for GL might improve performance.
Date: Thu, 5 Aug 1999 07:37:01 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: GL Tablespaces
Jeff, we have two tablespaces for gl.one for all tables and one for indexes.
We have a one temp tablespace not specifically related to GL. Most
importance thing is try to separate the index tablespace and data tablespace
separate disks. I didn't hear about the bad performance. We have about
100-110 users at pick time.
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Date: Thu, 5 Aug 1999 09:31:05 -0400
From: "Mark W. Farnham" mwf@rsiz.com
Subject: RE: GL Tablespaces
By "temp" tablespace for GL, do you mean the interim tablespace defined in
gl_storage_parameters or the
temporary tablespace for the GL user? In fact neither of these should be
GLTS.
The true "temporary" tablespace should be a tablespace reserved as
temporary and designated as a temporary tablespace to remove the overhead
of logging and dynamic freespace allocation. This space should have an
initial and next size that is tuned to the sort_area_size and
retained_sort_area_size in use for the database instance. The initial and
next size, at a minimum should be the sort_area_size plus one database
block, and
should be a multiple of the sort_area_size with one extra database block
added on after the multiplication.
One or more "interim" gl tablespaces can be defined either through the
forms or in gl_storage_parameters. For substantial installations this is
usually two separate tablespaces on independent units of disk performance
(also know as stripe sets, meaning sets of volumes sharing underlying disk
drives). Usually it is best to make
the initial and next sizes in gl_storage_parameters the same for all rows,
and to make the pctincrease 0. It is also usually best to make this size
large relative to actual needs so that dynamic space management is not
required multiple times during the processes that use the interim
tablespaces.
Separating out GL_JE_LINES, GL_BALANCES, and GL_INTERFACE is a common and
productive practice, and you will likely find it productive to split out
the indexes on GL_JE_LINES and GL_BALANCES into one or more tablespaces.
Physically reordering GL_CODE_COMBINATIONS into its order of most common
access (check the journal import process and with your FSG users for
starters) can be highly productive. GL_CODE_COMBINATIONS also does not
generally have changes in row length, so it can also be reloaded densely
(with a smaller pctfree) so that it will fit in fewer blocks.
Finally, you may benefit from selective use of solid state disk drives,
particularly for GL_CODE_COMBINATIONS. Please take all of this with a grain
of salt. If you have a small installation or few resources in terms of
independent units of i/o, all this splitting out will do nothing except
make it easier to make it easier to move objects around later if you get
additional disks or array units. The "densification" and physical ordering
techniques can improve throughput regardless of independent i/o
opportunities.
Mark
Date: Thu, 5 Aug 1999 11:07:05 -0300
From: Jeff Preston Jeff.Preston@moncton.org
Subject: RE: GL Tablespaces
Thanks Mark, I was referring to Temporary tablespace for the GL users, I
thought it should
have a seperate temp tablespace, I'm hoping by giving the GL user a separate
temp tablespace, and by separating
the GL indexes and tables on different tablespaces, should help performance.
Jeff
Date: Thu, 5 Aug 1999 16:02:30 +0100
From: jdstuart@globalnet.co.uk
Subject: RE: GL Tablespaces
Jeff,
It used to be useful to create a separate temp tablespace for the GL user,
while all other users used the main temp tablespace, however this was only
applicable when Apps sessions were actualy logged into the database as the
base schema users (GL, AP, AR...).
With the advent of the APPS schema, user sessions are now all running as
APPS and there is no way to have your GL users use one temp space and other
users use another tablespace. So, to answer your original question, if your
system is 10.6 or later a separate GL temp tablespace won't help you.
Even if a GL temp tablespace could help, separating your GL tables, GL
indexes, GL interim tables and GL interim indexes into 4 physically separate
tablepsaces would be a far more productive move because of the contention
between the segments in these tablespaces.
Jonathan.
Date: Thu, 5 Aug 1999 11:06:30 -0400
From: "Mark W. Farnham" mwf@rsiz.com
Subject: RE: GL Tablespaces
I would like more information regarding what Alan is suggesting when he
says that moving any other permanent table to another tablespace "is not
supported."
If Alan is saying that if you fail to move that table's contents correctly,
then it is your own fault, then fine.
If Alan is saying that there is any requirement in Oracle that a particular
segment (other than SYS segments) is located in a particular tablespace,
then I must note that this has never been the case. Separation of major
segments into their own tablespaces is a tuning technique that has been
publicly endorsed and used by Oracle since at least 1988. Automation of
creating the segments in up to two tablespaces per module appeared later,
somewhere in the range 1989 to 1991. Separating large segments which
compete for parallel i/o into separate tablespaces on independent units of
i/o capacity is a "best practice" long since endorsed by the VLDB and
facilitated, in the case of indexes, by the alter index rebuild command.
Suggesting otherwise is not helpful.
If anyone has gotten any contrary feedback from Oracle, support or
otherwise, I would like to hear about it. My intention would be to collate
any such feedback and give it to the OAUG board so that any such fear,
uncertainty, or doubt thus created can be communicated to Oracle and be
stamped out.
Mark
Date: Mon, 9 Aug 1999 13:03:10 EDT
From: RBoren7458@aol.com
Subject: Re: GL Tablespaces
I don't know what version of the applications you are on. In the Oracle
Applications Release 10.7 for UNIX installation Manual on page a-20 and a-21
it talks about moving objects to different tablespaces. If you move a gl
object you will need to update the gl_storage_parameters table. This update
is a menu selection in 10.7 character.
A word of warning. If you are moving a table. Be careful about your
triggers.
Triggers are owned by apps. If you export and drop a table under the schema
owner it will not export the trigger.
Rickey
Unable to access Signon screen on installation of Web Application Server
Date: Mon, 09 Aug 1999 06:13:16 GMT
From: manoj_bhatnagar/Polaris@POLARIS.CO.IN
Subject: DBA-Help on Oracle Web Application Server
Dear All
We have installed the Web Application Server, Database Server and Forms
Server on the same machine.
we have done the following:-
1. Set up virtual directories.
2. Configured the Java Cartridge.
3. Created the Database Access Descriptor.
4. Configured the Forms Server.
5. Modified the Sign-on file afsamples.htm.
6. Started the Web Request Broker, Admin Server, Web Listener, HTTP
Listener and Forms Server.
But we are not able to access the Sign-on screen from the web bowser.
When we give http://psln_oapps.polaris.co.in/oa_html/afsamples.htm to
access it, it gives the error connection timed out.
How we can connect to sign-on screen. Are we going right or there are some
other steps to do it.
Any help on this will be greatly appreciated.
Manoj
Date: Mon, 9 Aug 1999 07:33:53 +0100
From: "Sangster, Simon" Simon.Sangster@viasystems.com
Subject: RE: DBA-Help on Oracle Web Application Server
On our installation the "oa html" section of your url was in upper case with
an underscore seperator "OA_HTML" changing this to lower case results in a
"The requested URL was not found" error rather your connection timed out
problem though ...
Also is there a seperator between "psln" and "oapps" ?
Date: Mon, 09 Aug 1999 08:19:57 -0400
From: "Jim Gehl" JGehl@smtp-gw.lsuc2.lsuc.on.ca
To: oraapps-l@cpa.qc.ca, manoj_bhatnagar/Polaris@POLARIS.CO.IN
Subject: Re: DBA-Help on Oracle Web Application Server
I noticed you have not specified a port number in your URL and you do not
mention configuring a listener. If you have configured a listener specify
the port number you used and put it in your URL.
eg. http://psln_oapps.polaris.co.in:8888/oa_html/afsamples.htm
Jim Gehl
Database Administrator
The Law Society of Upper Canada
Barreau du Haut-Canada
(416) 947-4045
jgehl@lsuc.on.ca
Date: Tue, 10 Aug 1999 07:21:23 +0100
From: "Sangster, Simon" Simon.Sangster@viasystems.com
Subject: RE: DBA-Help on Oracle Web Application Server
on our setup you only have to specify a port if you're not using the default
port.
Date: Mon, 09 Aug 1999 13:53:31 -0700
From: sagarwal@guthy-renker.com
Subject: Re: DBA-Help on Oracle Web Application Server
There are couple of things you can look into :
1. If you are using JInitiator , make sure you have netscape set so
that does not go to Internet before it goes to intranet.
2. Also there is a patch on NT for timeout issue.
3. Check your JAVA_TOP is correct and you followed all the
instructions from release notes and Readme file for your (11.0.2 or
11.0.3) patch.
If you still have problem, write me straight with complete details of
your install.
Sanjay Agarwal
sagarwal@guthy-renker.com
Date: Mon, 6 Sep 1999 15:49:44 +0200
From: George Fungayi Mamvura mamvura@alpha.co.zw
To: oraapps-l@cpa.qc.ca
Subject: Re: DBA-Help on Oracle Web Application Server
Can you ping the host machine? You should be able to get a reply
Check also your directory structure.
Web Application Server - Failed to find Java Class
Date: Tue, 10 Aug 1999 12:55:49 GMT
From: manoj_bhatnagar/Polaris@POLARIS.CO.IN
Subject: DBA: Oracle Web Application Server / Failed to find Java Class
Hi All
We have installed the Oracle Apps. Release 11.0, Web Application Server
3.01, Database Server and Forms Server on the same machine.
We are using the following url to connect to sign-on screen.
http://psln_oapps.polaris.co.in/OA_HTML/us/afsamples.htm
The sign-on screen is coming but we are facing the following problems:
The first problem is that no icons are coming on the sign-on toolbar.
The second problem is that after supplying the username and the password on
the Sign-On screen, we are getting the following error:
Java Exception:
oracle.forms.uiClient.v1_4.engine.RunformException:FRM-99999:Internal
Error: Failed to find Java Class.
Full Details: FRM-99999: Internal Error: Failed to find name of class for
handleClassId=1000. Missing in registry?
We have checked the location of *.jar files also. The files are on the
right directories.
We have checked the CLASSPATH registry and Virtual Path Variable.
We have checked the Registry.dat and OracleApplications.dat files and added
the path for the application icons.
Any help on this will be greatly appreciated.
Manoj Bhatnagar
Associate Consultant
Polaris Software Lab Ltd.
Noida, India.
Date: Tue, 10 Aug 1999 09:20:30 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: Oracle Web Application Server / Failed to find Java Class
Manoj, I didn't see any port number in ur url.
http://server_name:port_num/OA_HTML/US/sample.htm
we are on HP-UX 11.0 with apps version 11.02 and webserver 3.0.
Also check the admin,www are up and running.
hope this helps.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Date: Tue, 10 Aug 1999 11:18:40 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: Oracle Web Application Server / Failed to find Java Class
Manaj,
I agree with Bharat. You should have port no. in the URL.
We are having Ver 11.0 on HP UX-11 and our URL looks like :
http://efs2:8001/OA_HTML/test_browser.htm for our 'test' database.
We also have TWO files, test_browser.htm and test.htm files under
OA_HTML/US ( here it is APPL_TOP/html/US ). Also we have the same copies
in OA_HTML.
Whichever directory you are calling from, see that you have both type of
files.
-- PARAM name="serverPort" value="9005" -- 9005 is the port no. for
forms server
-- serverPort="9005"
--
serverArgs="module=/u01/app/applmgr/product/11.0/fnd/11.0.28/forms/US/FNDSCS
GN userid=applsyspub/pub@test fndnam=APPS"
and see that you enter following lines in ENV file:
FORMS45_MAPPING="http://efs2:8001/OA_TEMP"
export FORMS45_MAPPING
Here 8001 is the listener port.
Hope this should solve your problem.
-chakrapani
Oracle Apps DBA
Date: Tue, 10 Aug 1999 23:13:08 +0100
From: "Jonathan Stuart" jdstuart@globalnet.co.uk
Subject: Re: Oracle Web Application Server / Failed to find Java Class
Hi,
If you are getting to the sign on screen it won't be the port number that is
at fault - the fact that the sign on screen is being displayed proves a web
server connection was made, a forms session started and a database
connection made. The lack of a port number no doubt just means the listener
is listening on port 80.
The Toolbar icons may be due to missing gif files, which seems to be quite
common with R11. Either the gifs are missing or are in the wrong directory -
they should be in $FND_TOP/media and $FND_TOP/media/US. Try running adadmin
and selecting the 'Copy files to destination' option. If you do have missing
gifs this job will report an error when it trys to copy them. Running the
verify required files job in adadmin might also help. The class file error
could be caused by a number of different problems, but I would check first
that your CLASSPATH is correct and that you have the correct class files in
place. For the latter, make sure the correct IO patches were applied in the
right order to give you the correct class file versions (Note, these are the
classes*.zip files, etc, not the jar files).
Jonathan.
Date: Wed, 11 Aug 1999 08:12:59 +0100
From: "Sangster, Simon" Simon.Sangster@viasystems.com
Subject: RE: Oracle Web Application Server / Failed to find Java Class
We had the missing icons on the sign on screen problem a couple
of days ago caused by the www process getting "twisted" during
the download, executing an "owsctl stop www" followed by
"ps -ef |grep www" to identify rogue processes kill -9 to
get rid of them and "owsctl start www" and refreshing the url
solved it (this time!)
Database and Application Server setup
Date: Wed, 11 Aug 1999 14:29:47 -0400
From: "Kurylo, Mary" Kuryma@consumer.org
Subject: NCA Installation
We are in the process of planning an upgrade from 10.7C 11.0x. At this
time we will also be changing our hardware platform. I'm looking for pros
and cons of the different possible setups. Such as ...
1) Database & Application Server on the same Unix box
2) Database on Unix box, Application Server on a different Unix box
3) Database on Unix box, Application Server on an NT box
4) Other?
We have approximately 25 concurrent users and run a lot of FSG's. Also we
are, and will be, running 2 instances of the database and applications.
Please respond with any comments and/or suggestions.
TIA
Mary Kurylo
Applications Development Analyst
Consumers Union of US Inc.
kuryma@consumer.org
Date: Wed, 11 Aug 1999 15:34:53 -0400
From: ddicondina@SUNGARDRS.COM
Subject: Re: NCA Installation
We are migrating from 10.7 character running (Sun Solaris) to 10.7 NCA and
are going to have the database & and application server on the same box.
It was recommended by our consultants to go this route rather than having
the application server on a separate NT machine (stability problems) of
which we had an extra one sitting around. We chose this route because we
didn't want to purchase another UNIX box so we upgraded our Sun box to
handle everything. We are planning on going live on September 20th and so
far our testing has been favorable. We have approxiamately 40 concurrent
users.
Dominic DiCondina
SunGard Recovery Services, Inc
Database creation scripts
Date: Fri, 13 Aug 1999 12:49:36 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: oraapps-l@cpa.qc.ca
Subject: About Database Create Scripts.
We are installing applications. There is a place where database creation
and other scripts
are stored for release 11.0.3 and 8.0.5. Any pointer to script name or
location or script pasted
will be appreciated.
Thx,
Madhu Sudan Dada
Please reply more focused because I have up to crdb.orc and crdb2.orc