Tuesday, May 13, 2014

Creating tablespace within RMAN prompt




 rman target "/"

Recovery Manager: Release 11.2.0.4.0 - Production on Tue May 13 06:06:37 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CVRMAN (DBID=*************)

RMAN> sql "create tablespace tbs1 datafile ''+DATA'' size 10M";

using target database control file instead of recovery catalog
sql statement: create tablespace tbs1 datafile ''+DATA'' size 10M

No comments: