sumit1974_at_gmail.com wrote:
> Hi,
> I have done a export of a very big database with approximately 200
> tablespaces, and 500 users. I want to import the data into a test
> database.
>
> Before importing the data, i want to create the users and tablespaces
> Is there a way to create the users and tablespaces, using the export
> dump file.
>
> Regards
> Sumit Sharma
>
Yes; tablespaces are not listed, but are actually in the
export dump.
You can create the create user and table/index statements
by looking up the "indexfile=" option on import.
Execute an export once more, with rows=n, and edit the
dump file to extract the create tablespace statements.
Or use tools like (e)grep, awk, etc to extract
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Mon Feb 20 2006 - 12:13:48 CST
