Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import/Export small database with spacing contraints!! Not enough disk space! And can't use vi to modify the exported schema!
In article <36d1e9e0.43595074_at_news.earthlink.net>,
mleung_at_earthlink.net (m.L.) wrote:
>
> First, I want to thanks Steve and couple others who have sent me
> emails regarding my problems.
>
> Now, I still have couple questions:
>
> 1) I typed : imp user/password show=y full=y file=**dmp >
> [snipped]
> 2) When I used Steven's ugly_DLL script and then ran the resultiing
> sql script, it created all the tables except that it changed the
> ownership of all the user tables to 'system' instead of 'oracle'.
>
> Shouldn't the resulting sql script keep the original owner for the
> tables? Did I miss something?
>
The export file contains "connect {owner_name}" in the stream. This is how the owner is managed. I believe that this becomes "ALTER SESSION SET CURRENT_SCHEMA= "{owner_name}" in the ugly file. I don't know what Steven's ugly_DLL script does with this command.
For just the tables, you can generate a file containing the index creation SQL, the table creation SQL is provided as remarks. It would work something like this:
imp scott/tiger full=y rows=n indexfile={table create cmds} file={dump file}
# the following grep "removes" the index creation commands.
# these can be run later
grep "^REM " {table create cmds} > {table create cmds only}
# you can now edit the init and next sizes for the tables (and indexes).
vi {table create cmds only}
# execute the table create comands in the smaller schema.
HTH
James
> Please either post your response here or email me at
> mleung_at_intelus.com or mleung_at_earthlink.net.
>
> thanks. you guys are the best
> Michael Leung
>
> On 21 Feb 1999 22:24:19 -0600, hause011_at_garnet.tc.umn.edu (Steven
> Hauser) wrote:
>
> >I have a script that uses oracle imp/exp utility and a filter to
> >get schema out of oracle.
> >
> >URL: http://www.tc.umn.edu/~hause011
> >
> >
> >--
> >---------------------------------------------------------
> >Steven Hauser
> >email: hause011@tc.umn.edu URL: http://www.tc.umn.edu/~hause011
> >---------------------------------------------------------
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 23 1999 - 09:41:03 CST