Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: saving an entire schema to disk

Re: saving an entire schema to disk

From: gazzag <gareth_at_jamms.org>
Date: 11 Jan 2006 06:56:47 -0800
Message-ID: <1136991407.729290.310660@o13g2000cwo.googlegroups.com>


>> not sure what oracle version it is...i think it's 9i.

You need to log in to the database using the SQL*Plus client. If you have the SYSTEM password. By way of example:

SQL> select * from v$version;

BANNER



Oracle9i Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for 32-bit Windows: Version 9.2.0.4.0 - Production NLSRTL Version 9.2.0.4.0 - Production

SQL> Received on Wed Jan 11 2006 - 08:56:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US