Re: Dropping a datafile from test db (ORA-01111)

"Syltrem" <syltremzulu_at_videotron.ca> wrote in message news:<Bxtkd.45$df.1442_at_tor-nn1.netcom.ca>...
> Hi
>
> I copied (part of) a database into another db for a test environment.
> Fact is, I only copied certain datafiles/tablespaces, created a new
> controlfile to build a new database from these copied datafiles, and
> performed a point-in-time recovery.
>
> Of course the new database's alert log file contains messages like this one:
> Tablespace 'HRDATA_IFB' #19 found in data dictionary,
> but not in the controlfile. Adding to controlfile.
>
> But that's ok.
> Now that the db is open, I would like to get rid of those files, as I don't
> need them in the controlfile (or anywhere at all).

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=1060605.6&p_database_id=NOT might give a clue on how to recreate so you can drop.

If you have the situation where all of a schema that you want to propagate is in a [small number of] tablespace, look into the transportable option.

jg

--
@home.com is bogus. "This=20e-mail=20is=20intended=20solely=20for=20the=20person=20or=20entity=20=
to=20which=20it=20is=20addressed=20and=20may=20contain=20confidential=20an=
d/or=20privileged=20information.=20Any=20review,=20dissemination,=20copyin=
g,=20printing=20or=20other=20use=20of=20this=20e-mail=20by=20persons=20or=20=
entities=20other=20than=20the=20addressee=20is=20prohibited.=20If=20you=20=
have=20received=20this=20e-mail=20in=20error,=20please=20contact=20the=20s=
ender=20immediately=20and=20delete=20the=20material.=20" - oracle-l