I have an Oracle 10g database on Windows running in no-archive log mode. I am being asked to restore a schema as a different schema name from Monday (1/4/2010). The only way I can think of to do this is to restore the database to a point in time, export the schema, restore the database to its previous state then import the schema. I am not even sure if it is possible to restore the schema as a new name. Please give me the syntax for any commands, this is new to me! Thanks!