Title: Re: Deleting database
Yechiel,
I am letting RMAN do that for me. I have several scripts that help me
accomplish this.
The first one does a full exportof production. This logical
backup is just in case that I need to recreate my production database from
I think that if you use exactly the same file names and db structure in both
of your
database, you can simply ( if it is possible) bring down the production
database
and copy the files to the test database.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L
encoded content removed -- binaries not allowed by ListGuru
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender
Carel-Jan,
Thanks for your insight in the difference between export/import and
copying databases. Two factors had me initially thinking of doing
export/import: 1) The tables in production are not big and 2) tables are
not subject to heavy changes. As it was pointed out before and although
I am
Hi All,
I have two databases of small size running on a Win2k Server. One is
production and the second one test. I would like to delete the test
database in an automated way (run a script say every weekend), then
recreate it so that I have a fresh database to work with or to import
prod data
Sorry, I forgot to mention I am using Oracle 9.2.0.1.0
-Original Message-
Sent: Tuesday, December 30, 2003 11:47 AM
To: '[EMAIL PROTECTED]'
Hi All,
I have two databases of small size running on a Win2k Server. One is
production and the second one test. I would like to delete the test
Hi,
One way would be
1) From your test database get a list of all
datafiles,redologs,controlfile locations.
2) Spool and store it in a file.
3) Shutdown the database and listeners
4) Use the file to create a script to physically remove the database
related files using OS commands.
Hope this
Julio,
If you need to keep the userid's and other environmentals, I would
create a script that truncates the tables and then import the data to
populate them with the new data. The export can be controlled with a par
file and the import can be part of the truncate script.
Ron
[EMAIL PROTECTED]
Vaidya,
Wouldn't I have to worry about any registry info for the test instance
after physically deleting the OS db files? Would I be able to create
test using the same instance name?
Julio Cesar Quijada-Reina
Programmer Analyst
Computer Services at Alfred State College
-Original
Ron,
I like this idea. Although, I am not really concerned about userid's or
environmentals, truncating test tables and importing the new data in
looks like it would be faster than deleting the entire test database and
then recreating it. But how would I know what tables to truncate?
Thanks
Run oradim.exe from command line to see how to delete SID.
Deleting Oracle service via oradim _will_ remove corresponding
registry entries.
But why bother removing database, wouldn't dropping schema owner
with cascade option followed by full import do the trick?
Branimir
Wouldn't I have
Branimir,
Correct me if I am wrong, but if I used your approach of dropping schema
owner then if I have 25 schemas on my test db, I would have to drop ALL
of them? I would think that dropping ALL schemas would equal removing
entire database.
Julio Cesar Quijada-Reina
Programmer Analyst
Computer
Julio,
You can get a list if tables from the test database and compare it
with a list of tables from the production database. Just select
table_name from dba_tables where owner not = system or sys and that will
give you all of the application tables in the database.
Ron
[EMAIL PROTECTED]
That's right - you would have to drop all schema owners. In my
opinion it is simpler and easier task to automate dropping of
all owners followed by one full import compared to task of
automating database deletions followed by database creations
then doing full import in very last step.
DOS
As far as I can understand your question you are copying your production
environment to test. So, test should be a copy, and not an export/import
logical represantation of prod. Otherwise your tables/indexes will be
reorganized every time you create the new test database. This means
i need your advise with this one as i am trying to delete a
database via the configuration Assistant tool. (deleting because of
i had problems with this database as its control files were
missing).
so should i go ahead and delete the service, because most likely
none of the files would be
John,
Didn't I just complete quite a number of emails on this very issue? I hoped
those resolved it.
Anyway, the assistant can't start the database; so it can't determine the
datafiles that made up the database. You would say Yes to delete the service
anyway and look for the datafiles yourself,
17 matches
Mail list logo