Re: Exporting user's data to new database

This is a quirck of imp. Use log=outname.dat instead of redirection

Hth,

Sybrand Bakker, Oracle DBA

Steve . <syarbrou_at_enteract.com> schreef in berichtnieuws enmvjssba00a0fn6aqfhf5oev8jahbh4na_at_4ax.com...
> Thanks. I'm trying to pipe the output to a file to make sure the data
> inside the tables is in there. I do an imp username/password
> file=name.dat show=y full=y > outname.dat. On UNIX
>
> Pipes to the screen and doesn't save to the file. What gives?
> Thanks.
>
> On Thu, 8 Jun 2000 19:06:53 +0200, "Sybrand Bakker"
> <postbus_at_sybrandb.demon.nl> wrote:
>
> >
> >Steve . <syarbrou_at_enteract.com> schreef in berichtnieuws
> >9uevjs4tbstcq33v0ksaouss6mora9qasc_at_4ax.com...
> >> Ok, I'm running Oracle 8.1.5i on Solaris. The database has two
> >> database instances on it, named: k51 and k52.
> >>
> >> k51 has two additional tablespaces on the drive under:
> >>
> >> /usr/oracle8i/u02/cbr_i.dbf
> >> /usr/oracle8i/u02/cbr_f.dbf
> >>
> >> The user that logs into the database is called k5u.
> >>
> >> The end users are having problems with that database instance due to
> >> some SQL script that was run on it. What I want to do is take all the
> >> data stored in k51 for user k5u, and place it in k52. Of course the
> >> tablespace needs to be created for k52, but in a different spot of
> >> course. How do I go about doing this? Also, will I need to recreate
> >> k5u on the second database, or can I somehow reassociate all the info
> >> with a user called k5u2 on the the k52 database instance?
> >>
> >> Tried exp/imp, but when I did an imp show=y I couldn't find any of the
> >> data in the dump file that I knew was in the database, like usernames.
> >> Thanks.
> >>
> >> By the way, I have access to the OEM tools if that will help any.
> >>
> >> Steve
> >>
> >> Newsgroup replies preferred. Remove nospam when replying thru email.
> >
> >1 use the create tablespace command prior to importing. Info on the
 original
> >tablespaces can be found in dba_data_files and dba_tablespaces
> >2 Use the touser of the imp command to 'move' the data to a different
 user
> >3 If you made an user export: in that case there will be no create user
> >statements in the export.
> >

 1>Hth,


> >

> >Sybrand Bakker, Oracle DBA